Xero - beautiful accounting software

Xero Developer Help Center

Xero Developer Community

Community > Getting Started >

Azure Data Factory & Journal_Lines

Started by Flock Consulting -   in Getting Started

Hi all,

We are working with a client to help ingest their Xero data in to a SQL Database for further processing & modelling. Our ideal approach would be to utilize the Xero connector in Azure Data Factory, and for the most part, this works fine.
Unfortunately, for their larger Xero organizations, requests to the Journal_Lines table will always time out. There does not appear to be any way to limit the number of rows similar to the "If-Modified-Since" header in the Journals API.

Has anyone had any experience with the same? Any guidance would be much apprecaited.
The Journals endpoint by default limits the response to 100 journals, however if those 100 journals contain a large number of lines it can cause issues. It isn't currently possible to further filter response to reduce the size.

It is worth noting that our timeout is set to five minutes, so you may find that if you are able to increase your timeout to match the call may complete.

If you continue to see issues, please reach out to our support team.

Robin B (Community Manager)