XERO querydb: Difference between revisions

From Data Islands
No edit summary
No edit summary
 
Line 34: Line 34:


querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES
querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES
Note:
For Repeating Invoices and Invoices we are creating a line for each line item.
So when you run an update you should use the unique value which will be the Line Item ID and not the Invoice Number or Reference.
EG
>push repeatinginvoices u "LineItems_LineItemID" "XERO Repeating Invoices"

Latest revision as of 14:14, 13 June 2023


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


Note:

For Repeating Invoices and Invoices we are creating a line for each line item.

So when you run an update you should use the unique value which will be the Line Item ID and not the Invoice Number or Reference.

EG

>push repeatinginvoices u "LineItems_LineItemID" "XERO Repeating Invoices"