Common COQL Errors
COQL "Minimum Successful Response" script for testing/setup:
queryMap = Map();
query = "select Last_Name from Contacts where Last_Name is not null" queryMap.put("select_query", query);
response = invokeUrl [
url: coqlurl
type: POST
parameters: queryMap.toString()
connection: "zcrm" ];
info response;
Generic Error Message (may be sent for a number of issues): {"code":"INVALID_REQUEST","details":{},"message":"unable to process your request. please verify whether you have entered proper method name, parameter and parameter values.","status":"error"}
Things to check:
1. API version, try both v2 and v3
2. If using a Zoho "Connection" feature, make sure COQL is explicitly enabled in the scope using a Zoho OAuth connection.
3. COQL requires mandatory WHERE clauses on all requests! This can be something trivial like "where Last_Name is not null"
4. COQL does not support all modules the way the api does. At present (July 2022) COQL can query the following modules:
leads, accounts, contacts, deals, campaigns, tasks, cases, events, calls, solutions, products, vendors, pricebooks, quotes, salesorders, purchaseorders, invoices, and custom modules
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Kaizen posts 2025: API series
Here is a complete list of Kaizen posts related to APIs published in 2025. Sl No Title Description 1 FAQs on COQL API Check out the frequently asked questions on the Zoho CRM COQL API in the Zoho Community Forum with answers. 2 A Comparison of Zoho ...Kaizen posts 2020: API series
Here is a complete list of Kaizen posts related to APIs published in 2020. Sl No Title Description 1 Bulk Read API This post explains in detail the Bulk Read API in Zoho CRM. 2 Bulk Write API This post helps you with the step-by-step process of bulk ...Kaizen posts 2023: API series
Here is a complete list of Kaizen posts related to APIs published in 2023. Sl No Title Description 1 Scoring Rules - Part -1 Learn about scoring rules and how to create, delete, update and execute scoring rule APIs 2 Scoring Rules - Part -2 Learn ...Kaizen posts 2026: API series
Here is a complete list of Kaizen posts related to APIs published in 2026. Sl No Title Description 1 Email-Deal Associations in Zoho CRM Learn how Zoho CRM’s Deal Prediction Mechanism works and how to use Link/Unlink Deal APIs. The post also compares ...Kaizen posts 2019: API series
Here is a complete list of Kaizen posts related to APIs published in 2019. Sl. No. Title Description 1 OAuth2.0 and Self Client API This post covers the OAuth 2.0 protocol and explains how you can make use of Zoho's Self-Client option to authenticate ...
New to Zoho LandingPage?
Zoho LandingPage Resources