API usage with Google Apps script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-02-2025 10:21 AM - edited ‎01-02-2025 10:22 AM
Using a Google Apps script, we have been able to pull call data via the API into a Google Sheet. But due to the 4000 row limit, we need a way to pull data more than once (for the date range we are using) until there is no more data to be pulled. On a monthly basis and annual basis, we have many more than 4000 calls. Need advice on how to do this. Code snippet?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2025 08:58 AM - edited ‎01-06-2025 08:59 AM
start_after_transaction_id
with the most recently returned transaction_id of the bulk set you are downloading. Assuming you have a limit
defined of 4000, this will return 4000 until you have downloaded all transactions.start_after_transaction_id: Transaction_id to start retrieving after. This should be the last value retrieved previously. Default (or empty string) means start at the oldest. (from the Transaction API documentation)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2025 01:54 PM
My understanding is that the limit of 4000 rows is a limit of the API not of the script we are using to pull data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2025 01:26 PM
Yes, you are absolutely correct - the limit of the API is 4000 per request. Our advice is to update the Transaction API parameter start_after_transaction_id with the most recently returned transaction_id of the bulk set you are downloading. Doing this for each request will allow pulling of data that will continue 4000 at a time until all are downloaded.
