How to export data from Close.com with paginated API into a single CSV file

How To
,
1

Hi everyone,

I’m trying to create an automation in that exports all data from the Close CRM into a single CSV file. However, I’m facing a limitation with the Close.com API, which only allows 100 records per request (Pagination documentation).

I know I need to find a way to:

  1. Start with an initial request to get the first 100 records.
  2. Set up a loop into repeatedly call the API, incrementing the offset parameter (e.g., offset=100, offset=200, etc.) to retrieve subsequent batches of records.
  3. Consolidate all results and save them into a single CSV file.

Has anyone successfully implemented a similar workflow? Are there any best practices or tips for setting up the looping structure without exceeding API limits or losing data?

Thanks in advance for your help

Best

Michael

2

Yes, there’s even a Make Academy tutorial on pagination!

For more information, see Pagination - retrieving all data from APIs

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like