The odbc-driver uses a large number of calls API Zoho Credits

The odbc-driver uses a large number of calls API Zoho Credits

Our driver uses the minimum possible amount of API credits for operations on Zoho data.
The number of API credits consumed by each operation is determined by the Zoho API for specific tables, field types, etc.
There are several reasons for the additional consumption of ZOHO API credits:
- Gaining access to fields whose values can only be obtained when querying using the primary key. If the request includes at least one such field, then an additional call will be made to obtain its value;
- Call Zoho for each row returned by the query. An example is fields of type subform;
- Use of aggregate entities. In this case, reading each record of the related entity requires retrieving the underlying entity's data.
Try to select only the data that you really need at the moment.A request with explicit fields will require significantly fewer credits. Especially in the case when among such fields there will be no fields of the SubForm type (they always require an additional API call).


    • Related Articles

    • ODBC Driver for QuickBooks

      Currently, Devart ODBC Driver for QuickBooks supports only the QuickBooks Online platform however our team is working on the possibility of implementing the compatibility with other QuickBooks products.

    • ODBC Driver for FireBird. Error:"Cannot load client library: <path libs>

      The error you describe might mean that the driver didn't find the specified "Client Library" or that the client library doesn't match the bitness of your DSN. Please be informed that Devart ODBC Driver for FireBird interacts with the server through ...

    • Can I use the odbc driver in Power BI Online?

      However, I am encountering an issue with data updating in the cloud via Power BI Gateway. Despite the smooth operation in Power BI Desktop, the data does not seem to update as expected when using the cloud service. Do you have any documentation or ...

    • How to configure Devart ODBC drivers for optimal performance?

      To optimize Devart ODBC drivers, consider configuring parameters that influence the connection timeout, data fetching size, and logging level. Adjust settings based on the database you are using, especially for cloud connections like Salesforce or ...

    • how to work in Power Query using odbс driver

      Connect to an ODBC source. In the Power BI Desktop Home tab, select Get Data> to connect to an ODBC source. From the list of available connections, select the required DSN connection created in ODBC-Administration You can familiarize yourself with ...