Xero Accounting Endpoint: JournalsAccrual: Difference between revisions
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger. | The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger. | ||
This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields | Note an alternate endpoint named [[Xero Accounting Endpoint: JournalsAccrualTable|JournalsAccrualTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | ||
This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''', '''JournalDate''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields do not support all types of operators or complex filters. | |||
For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash|JournalsCash]]. | For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash|JournalsCash]]. | ||