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

    • 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 ...

    • ODBC Driver For InterBase. Error:"Cannot load client library: <path libs>

      This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for InterBase interacts with the server through the client library using a ...

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

      This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for FireBird interacts with the server through the client library using a ...

    • 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 ...