XERO Xero Support: Difference between revisions

From Data Islands
(Created page with " 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")
 
No edit summary
Line 1: Line 1:




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:
Note:


Line 10: Line 24:
# ACCREC
# ACCREC
# ACCPAY
# 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\""

Revision as of 16:41, 17 August 2022


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

  1. ACCREC
  2. 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\""