When set to 'true' (the default), the provider uses the Query API (COQL) to retrieve data from Zoho CRM.

Syntax

Connect-ZohoCRM -UseCOQL bool

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.

When Schema is set to 'v2', 'v2.1', or 'v4', COQL has the following limitations:

• Queries are limited to a single table or view.
• Maximum of 10,000 rows and 50 columns per query.

If you need to retrieve more columns or rows than these limits allow, consider using other APIs such as the Bulk API or REST API, which have different capabilities and limits. Refer to the relevant documentation for your schema (v2, v2.1, or v4) for details on these limits based on the selected schema version.