Bulk Read APIs - An Overview

Bulk Read API allows you to fetch a large set of data. This API is very useful whenever you need to export a large amount of data or to take a backup of your data without a big impact on your API limits.
This is an asynchronous API, which means that the response to your request is not available immediately. You must check the job status periodically to see if the data is ready to download.

Download OAS

Zoho Creator uses OAS to describe the functionality and actions of each API in a format that can be used across various programming languages. Download the OAS for the Bulk Read APIs below:

Note:
  • The results are only available as a downloadable .zip file — a single CSV file, containing the report data.

How it Works

Step 1 : Create a bulk read job
Create (or make) a POST API call by providing the module, the list of fields to be exported, and criteria, to filter the records. It will create an asynchronous job and return a unique identifier param, 'id', which is the reference of your request.

Step 2: Check job status
You can also choose to check the status of the job at periodic intervals, by making a GET API call using the 'id' of the job.

Step 3 : Download the result
When the job is completed successfully, the 'download_url' is available in the 'result' attribute of the response of the API. You can now download the result of the job by calling the 'download_url'. A ZIP file will be downloaded, containing the CSV file within it.