XERO Xero Support
You can connect to multiple XERO accounts using the syntax
>AddServer XERO "alias"
EG
>AddServer XERO "ACMEInc"
---
We use the XERO api
https://developer.xero.com/documentation/api/accounting/overview
So for the most up to date info on fields etc please refer to this.
---
HOW TO BUILD A WHERE CLAUSE
Ref:
https://developer.xero.com/documentation/api/accounting/invoices#optimised-use-of-the-where-filter
--- Note:
The xero "invoices" table holds both invoices sent and received.
So you should filter this on the "Type" column which contains 1 of 2 values
- ACCREC
- ACCPAY
ACCREC is invoices you send and ACCPAY is invoices you pay
ref: https://developer.xero.com/documentation/api/accounting/types#invoices
>querydb invoices Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31) and Type=="ACCPAY"
