Read data using COQL (Native SQL)

Executes a COQL (CRM Object Query Language) query to retrieve data. This example demonstrates using the get_module_data_coql endpoint to run a server-side query, which can be more efficient than client-side filtering. Note that COQL queries have a limit of 200 rows.

SELECT * from get_module_data_coql WITH(sql_query= 'select Last_Name, First_Name, Company from Leads where Company like ''Test'' limit 200')