Zoho CRM connection: missing COQL scope
The ZOHO CRM connection does not include the COQL scope, which prevents from running COQL requests in custom functions.
The Zoho CRM COQL API documentation states the required scopes for COQL requests:
scope=ZohoCRM.coql.READ
(and)
scope=ZohoCRM.modules.all
(or)
scope=ZohoCRM.modules.{module_name}.{operation_type}
=> the ZohoCRM.coql.READ scope is required
But here is the complete list of scopes included in the CRM connection:
ZohoCRM.modules.pricebooks.READ,ZohoCRM.modules.products.CREATE,ZohoCRM.modules.vendors.DELETE,ZohoCRM.modules.purchaseorders.CREATE,ZohoCRM.modules.activities.WRITE,ZohoCRM.send_mail.salesorders.WRITE,ZohoCRM.modules.vendors.WRITE,ZohoCRM.settings.READ,ZohoCRM.modules.quotes.DELETE,ZohoCRM.modules.all,ZohoCRM.modules.deals.DELETE,ZohoCRM.send_mail.invoices.WRITE,ZohoCRM.modules.invoices.DELETE,ZohoCRM.settings.layouts.read,ZohoCRM.modules.calls.WRITE,ZohoCRM.modules.accounts.WRITE,ZohoCRM.modules.pricebooks.CREATE,ZohoCRM.send_mail.accounts.WRITE,ZohoCRM.modules.custom.DELETE,ZohoCRM.settings.layouts.READ,ZohoCRM.modules.Leads.CREATE,ZohoCRM.modules.events.READ,ZohoCRM.modules.leads.WRITE,ZohoCRM.settings.extensions.ALL,ZohoCRM.modules.cases.CREATE,ZohoCRM.modules.leads.CREATE,ZohoCRM.modules.cases.READ,ZohoCRM.modules.campaigns.DELETE,ZohoCRM.modules.contacts.WRITE,ZohoCRM.modules.invoices.CREATE,ZohoCRM.modules.solutions.CREATE,ZohoCRM.send_mail.quotes.WRITE,ZohoCRM.modules.notes.ALL,ZohoCRM.modules.activities.DELETE,ZohoCRM.modules.deals.WRITE,ZohoCRM.modules.contacts.CREATE,ZohoCRM.modules.purchaseorders.DELETE,ZohoCRM.signals.ALL,ZohoCRM.modules.tasks.CREATE,ZohoCRM.users.ALL,ZohoCRM.modules.quotes.READ,ZohoCRM.modules.tasks.WRITE,ZohoCRM.settings.related_lists.all,ZohoCRM.modules.cases.DELETE,ZohoCRM.send_mail.ALL.CREATE,ZohoCRM.modules.quotes.CREATE,ZohoCRM.modules.calls.DELETE,ZohoCRM.modules.calls.READ,ZohoCRM.modules.salesorders.DELETE,ZohoCRM.modules.tasks.READ,ZohoCRM.modules.events.CREATE,ZohoCRM.modules.salesorders.WRITE,ZohoCRM.modules.zoho_projects.ALL,ZohoCRM.modules.custom.WRITE,ZohoCRM.modules.purchaseorders.WRITE,ZohoCRM.modules.salesorders.CREATE,ZohoCRM.send_mail.contacts.WRITE,ZohoCRM.settings.modules.READ,ZohoCRM.modules.tasks.DELETE,ZohoCRM.modules.campaigns.CREATE,ZohoCRM.send_mail.leads.WRITE,ZohoCRM.modules.campaigns.READ,ZohoCRM.modules.accounts.READ,ZohoCRM.modules.custom.READ,ZohoCRM.modules.salesorders.READ,ZohoCRM.send_mail.deals.WRITE,ZohoCRM.settings.ALL,ZohoCRM.modules.events.WRITE,ZohoCRM.modules.accounts.CREATE,ZohoCRM.modules.deals.READ,ZohoCRM.send_mail.purchaseorders.WRITE,ZohoCRM.modules.leads.READ,ZohoCRM.modules.solutions.DELETE,ZohoCRM.modules.custom.CREATE,ZohoCRM.modules.solutions.READ,ZohoCRM.modules.purchaseorders.READ,ZohoCRM.modules.vendors.READ,ZohoCRM.modules.activities.READ,ZohoCRM.modules.campaigns.WRITE,ZohoCRM.modules.calls.CREATE,ZohoCRM.modules.deals.CREATE,ZohoCRM.modules.invoices.WRITE,ZohoCRM.modules.quotes.WRITE,ZohoCRM.modules.events.DELETE,ZohoCRM.modules.solutions.WRITE,ZohoCRM.modules.vendors.CREATE,ZohoCRM.modules.products.DELETE,ZohoSearch.securesearch.READ,ZohoCRM.modules.Leads.WRITE,ZohoCRM.modules.products.WRITE,ZohoCRM.modules.accounts.DELETE,ZohoWriter.Merge.ALL,ZohoCRM.modules.contacts.DELETE,ZohoCRM.modules.pricebooks.WRITE,ZohoCRM.modules.products.READ,ZohoCRM.modules.cases.WRITE,ZohoCRM.modules.pricebooks.DELETE,ZohoCRM.modules.invoices.READ,ZohoCRM.modules.leads.DELETE,ZohoCRM.modules.contacts.READ,ZohoCRM.send_mail.custom.WRITE
=> There are a lot of scopes… but not the ZohoCRM.coql.READ
Therefore, all COQL requests ran from custom function fail:
=> Please fix this by adding the ZohoCRM.coql.READ scope to the Zoho CRM connection.