Exporting Large Datasets via API

O3's 'list' API endpoints are limited to 500 records per page. In order to consume more than 500 records, API users can utilize the 'take' and 'skip' parameters to page the data. Alternatively, users can utilize the 'grid-export' endpoints to export larger datasets in CSV format, as outlined below.

First, initiate the background export using a 'grid-export' API endpoint, as shown below.

Note that ‘selectColumns’ is a required parameter for exports.

The result will contain a unique identifier as shown below:

Next, poll the export endpoint to check the export status. We recommend polling every 15-30 seconds.

When the export is complete, the result will contain a URL that you can use to download and parse the CSV results.