How to paginate or get more than 300 reports using Expensify API?
Hi Team,
We integrate the Expensify API into our product. Our requirement is to pull last three years Expensify report data into our system. We have gone through API documentation but could not find how to paginate or pull bulk records. I read somewhere in the community we can pull up to 300 records.
We are using this data to show vendor-wise expenses.
It will be great if you can help us with paginating the reports if more than 300 reports.
Many thanks in advance.
Answers
-
Greg Schroeder Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 64 Expensify TeamOptionsHi @vishal22patel! To make sure I'm clear, are you using the Report Exporter for this use case? How are you filtering to generate the selection of reports in your desired sample?
While the API is typically a self-serve tool, I'd recommend as much detail as possible to your post so other Community contributors with API knowledge can contribute. 👍
-
@Greg Schroeder Yes. We are using Report Exporter. The startdate has been passed into "inputSettings" filters (Startdate = 3 years from now).
-
@Greg Schroeder Do you have any idea?
-
@vishal22patel have you tried the advice outlined here? I would also recommend replying to that post to see if that Community member was able to export large amount of data successfully 🙂
