Xero Accounting Endpoint: JournalsAccrualTable: Difference between revisions

Created page with "== Overview == The Xero '''JournalsAccrualTable''' endpoint provides the journal records on an accrual basis that had a material impact on your..."
 
No edit summary
 
Line 3: Line 3:
The Xero '''JournalsAccrualTable''' [[Xero Accounting Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.
The Xero '''JournalsAccrualTable''' [[Xero Accounting Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger.


Note this endpoint is an alternate format of the [[Xero Accounting Endpoint: JournalsAccrualTable|JournalsAccrualTable]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Note this endpoint is an alternate format of the [[Xero Accounting Endpoint: JournalsAccrual|JournalsAccrual]] endpoint. It 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.  
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.