New APIs in Zoho CRM—Query API and Bulk Write API
Hello everyone!
We are delighted to announce the release of two new APIs—Query API and Bulk Write API.
Query API
Query API allows you to write your own queries to fetch data from Zoho CRM.
Similar to SQL, CRM Object Query Language(COQL) uses the SELECT statement to fetch records. This API allows you to fetch upto 200 records in a single API call.
Highlights
- Query API is based on SQL syntax and is easy to use.
- Query API supports some major SQL comparators such as like, not like, equal, not equal, greater than, lesser than, is null, is not null, between-and etc. for improved search results.
- It is easy to join or relate two modules through lookup fields using the "."(dot) operator.
Bulk Write API
The Bulk Write API allows you to insert, update, or upsert a large amount of data into your CRM in a single API call, thereby reducing the number of API requests.
This is an asynchronous API, and so the response of your request is not available immediately. The system will notify you once the job is completed.
Highlights
- Bulk Write API lets you import as many as 25,000 (twenty-five thousand) records in a single API call.
- This API is useful when you want to perform a background process such as initial data sync between Zoho CRM and external services.
- This API also supports polling to know the status of your bulk write job and callback where the system notifies you of job completion in the callback URL.
We hope you found this post useful. Do share your feedback in the comment section.
Regards,
Shylaja