XERO querydb

From Data Islands
Revision as of 16:05, 16 August 2022 by WikiSysopdi (talk | contribs)


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