I am using the XML-RPC api and am trying to pull all past/historial invoices into an external database so I can query with a BI tool. I then plan to sync that db with new data each day. I am querying the invoice table. infusionsoft.Invoices
I’ve read that there is a limit of 1000 records each time I make an api call and will need to loop through pages. That said, I called infusionsoft.Invoices and was able to pull over 10k records for a given month. Anyway, just curious on the data limits for this api, and if anyone has advice on ETL’ing ecommerce data into a db for better reporting please advise
Update: I tried via the rest api - there is a 1k limit on retrieving orders. Though it seems the tables via xml don’t have a limit. That said, the rest api has a bit more data in the ‘list orders’. Is my only solution to loop through sales everyday for the past 10+ years?