UseCOQL
When set to 'true' (the default), the provider uses the Query API (COQL) to retrieve data from Zoho CRM.
データ型
bool
デフォルト値
true
解説
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.