Managing Zoho API Credits with the ODBC Driver
The Devart ODBC driver for Zoho is designed to use the minimum number of API credits for operations. However, the exact number of credits consumed depends on various factors, including the type of data you're accessing.
Why Does the API Consume More Credits?
Several factors can lead to additional API credit usage:
Primary key-based field access: Some fields can only be accessed through the primary key, which results in extra API calls if included in the query.
SubForm fields: Zoho requires a separate API call for each row that contains a SubForm field.
Aggregate entities: Fetching related entity data requires additional API calls to retrieve underlying data for each record.
Best Practices to Minimize API Credit Consumption
To reduce the number of API credits used:
Only select the specific fields you need for your operation.
Avoid including SubForm fields in your queries, unless absolutely necessary, as they require additional API calls.
Use filters to limit the data retrieved and make more efficient queries.
By following these best practices, you can optimize your usage of Zoho API credits and keep operations efficient.
Related Articles
How to Configure Devart ODBC Drivers for Optimal Performance
To ensure optimal performance when using Devart ODBC drivers, it's recommended to fine-tune several key parameters: Connection Timeout — Set an appropriate timeout to avoid long waits on unresponsive connections. Data Fetching Size — Adjust the ...
Guide: Configuring ODBC Driver in Azure Data Factory
This guide walks you through the steps of setting up and using an ODBC driver in Azure Data Factory (ADF) for seamless data integration. By following this guide, you will be able to configure an ODBC driver, create a Linked Service, and define an ...
Setting Up MongoDB Atlas and Connecting via Devart ODBC Driver
This article will guide you through the process of setting up MongoDB Atlas, creating a cluster, configuring access, obtaining the connection string, and connecting to MongoDB Atlas using the Devart ODBC Driver for MongoDB. 1. Creating a Cluster in ...
Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver
This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...
How to Work in Power Query Using ODBC Driver
1. Connect to an ODBC Source In Power BI Desktop, go to the Home tab and click on Get Data to connect to an ODBC source. From the list of available connections, select the DSN connection that you created in the ODBC Administration tool. You can learn ...