UseCOQL
When set to 'true' (the default), the provider uses the Query API (COQL) to retrieve data from Zoho CRM.
Data Type
bool
Default Value
true
Remarks
COQL is optimized for flexibility and easy querying, particularly for single-table or single-view queries. It allows you to use SQL-like syntax to retrieve data efficiently.
The following lists the limitations of the Query API by Schema.
| v2 | Maximum of 50 columns per query. |
| v2.1 | Maximum of 50 columns per query. |
| v4 | Maximum of 50 columns per query. |
| v8 | Maximum of 200 columns per query. |
For schemas v2, v2.1 and v4, if you need to retrieve more columns than these limits allow, consider using other APIs such as the Bulk API, which have different capabilities and limits. Refer to the relevant documentation for your schema (v2, v2.1, v4, or v8) for details on these limits based on the selected schema version.