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.