XERO querydb
From Data Islands
repeatinginvoices
Fields:
- Schedule
-- StartDate (Schedule.StartDate)
Date Fields in queries
- DateTime(YYYY, MM, DD)
EG
- DateTime(2022, 01, 01)
Example
querydb repeatinginvoices Schedule.StartDate >= DateTime(2022, 01, 01) AND Schedule.StartDate <= DateTime(2022, 12, 31)
querydb invoices Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)
To get the xero invoice pdf files
querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES
