XERO querydb

repeatinginvoices

Fields:

- Schedule

-- StartDate (Schedule.StartDate)

Date Fields in queries

- 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