Read data using Direct COQL Endpoint

Runs a direct Zoho CRM COQL query using the get_module_data_coql endpoint. Enter the full COQL statement in the sql_query parameter. The connector sends the query to Zoho's /coql API and automatically pages results when your query does not include a LIMIT clause.

Use this endpoint when you want full control over the COQL query, including selected fields, filters, joins, sorting, and aggregate expressions. For a guided parameter-based experience, use the get_module_data_coql_builder endpoint instead.

Tip: If you want to run native COQL directly without calling an endpoint with WITH(...), use the #DirectSql prefix. See the native COQL pass-through example below.

API v2 supports up to 200 rows per page. Newer API versions such as v7 or v8 support larger page sizes, up to 2000 rows per page. For the Emails module, use API v2 and keep PageSize at 200 or less.

SELECT *
	FROM get_module_data_coql
	WITH(
		  sql_query = 'select Last_Name, First_Name, Company from Leads where Company like ''Test'' order by id desc'
		, Version = 'v8'
		, PageSize = '2000'
	)