Introducing 'Queries' In Zoho CRM

Introducing 'Queries' In Zoho CRM

Hello everyone!

We are here with an exciting feature - Queries in Zoho CRM!

A little context before we dive right into the feature specifics :)

In today’s fast-paced business environment, immediate access to relevant data is essential for informed decision-making.
We are thrilled to announce Queries, a powerful feature that allows you to dynamically retrieve data from CRM as well as third-party services directly within our platform. With Queries, you can streamline your workflow, gain deeper insights, and make data-driven decisions without leaving the product.

Whether you fetch records from CRM or data from any other third-party services, the Queries feature gives you the power to present that data the way you want. For example, displaying only closed deals of a contact on a canvas or displaying the details of a ticket from Zoho Desk on a screen(Kiosk) in Zoho CRM.

All you have to do is write a query that solves your business need and associate that query with the relevant CRM feature like Canvas, Kiosk etc. This helps you leverage the power of data retrieval using REST API and COQL, along with schema management, serialization of responses, and other functionalities in data handling.

Let us consider a Canvas Detail View where Deals is a related list in the Contacts module. Here, a contact can have multiple deals associated, but you want to display only those that are won.

You can write a query with the required criteria to filter out the deals and simply drag and drop them on to your canvas just like how you include other components now. Simple, isn't it?

Read on to know more!

Components of Queries

  1. Query
  2. Source
  3. Variables
  4. Serializer
  5. Schema

1. Query

Query is a component of this feature that allows you to fetch data. You can set variables, serialize the response, and manage the schema during query creation.
Query configuration depends on the Source type. You can choose the source type as COQL, Modules, or REST API to construct your query.
  • COQL type is based on CRM's Object Query Language, very similar to SQL.
  • Module type is to retrieve the records from a module by selecting the module and its fields. You can also specify the conditions to filter records.
  • REST API type is to retrieve data from external services.

2. Source

A source is the data provider.
Zoho CRM provides pre-configured sources like COQL and Module in Queries to fetch records from Zoho CRM. Apart from this, you can also create your own source in the REST API standard to fetch data from other services.

Info
Right now, you can add a source as a REST API. Future enhancements will allow you to have sources like GraphQL, Databases like MYSQL & PostgreSQL, Cloud Databases from AWS, Azure and Google Cloud, OData Protocols, etc. This broadens the range of services you can connect with Zoho CRM and simplifies data handling.

3. Variables

Queries allow you to use dynamic variables in the query for module criteria, COQL statement, endpoints, headers, etc,. When you are testing the query, a pop up asks for the test value of the variable.
However, you should pass the values of the variables(like merge fields) to the query during association.


4. Serializer

Serializer lets you modify your response using JavaScript to use it for further processing. For example, you can combine the Full_Name and Designation fields in the Leads module to be displayed as Full_Name (Designation) in the response using the serializer.


5. Schema

Schema refers to the path of each field in the result of the query. You can alter the schema to suit the field types in CRM and change their labels to suit your needs.


Association of Queries

Queries is a game-changer for users as all your data is available inside Zoho CRM's interface. Currently, you can associate queries in Canvas Detail view and show the responses of the query as "field name and value" or a list.
In Kiosk Studio, you can associate a query and use it in a screen or in the criteria component.

Canvas Detail View

Use case

Fetch only those deals of a specific account whose stage is "Negotiation" through a query. Associate this query to a Canvas and add the fields of the query to it.
Step 1: Associate a Query



Step 2: Drag and drop the fields from the associated query on the Canvas.




Kiosk Studio

Use Case
Pass the user ID as an input from the first screen to the second screen where a query is used to fetch and display the user details.

Step 1: Enter the User ID to the input field on a screen.




Step 2: Associate and configure the required query to fetch and display the relevant user details. The query will take the user ID that was input in the first screen as a variable.








Queries can be associated with the "Decision" component of Kiosk, as well, as depicted in the following images.





Info
In future enhancements, you will be able to associate a query in various features of Zoho CRM, for example in the Canvas List View as a column, in Client Script to fetch data, in Standard Detail View/List View and etc.

Supported Editions

Queries is available for the Enterprise/Zoho One and Ultimate/CRM Plus editions, and will be available in the Professional edition soon.

Exciting, isn't it? We are sure this feature will save you tons of time!
Give it a try and let us know your comments.
You can read our documentation here.

Cheers!
Shylaja S
Zoho CRM

    Access your files securely from anywhere


            Zoho FSM Video Tutorials


                  All-in-one knowledge management and training platform for your employees and customers.






                                        Zoho Developer Community




                                                              • Desk Community Learning Series


                                                              • Digest


                                                              • Functions


                                                              • Meetups


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner


                                                              • Word of the Day


                                                              • Ask the Experts



                                                                        • Sticky Posts

                                                                        • Announcing the new SKILL.md for Zoho CRM and the updated OAS repository!

                                                                          We are introducing a new zoho-crm skill to make working with Zoho CRM Developer tools (like APIs, functions, widgets, client scripts, queries etc) easier and faster, with the help of AI in your preferred AI harness like Claude Code, Codex, Cursor, VSCode
                                                                        • Kaizen #261 : Using Zoho CRM Skill to generate complex COQL queries

                                                                          Hello everyone, In the previous Kaizen posts, we introduced the zoho-crm SKILL.md and discussed how it can help you when you are working with Zoho CRM APIs and Client Script. In this Kaizen, we will focus on using the Zoho CRM `SKILL.md` with GitHub Copilot
                                                                        • Kaizen #256 - Build an Arrival Readiness Web Tab in Zoho CRM

                                                                          Hi everyone! Welcome back to the Kaizen series! In the post, we discuss a use case in hospitality industry: how an Arrival Readiness web tab widget can be used to let reception staff identify and resolve issues before arrival of guests. Use case In the
                                                                        • Kaizen #198: Using Client Script for Custom Validation in Blueprint

                                                                          Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
                                                                        • Kaizen #226: Using ZRC in Client Script

                                                                          Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this


                                                                        Manage your brands on social media



                                                                              Zoho TeamInbox Resources



                                                                                  Zoho CRM Plus Resources

                                                                                    Zoho Books Resources


                                                                                      Zoho Billing Resources

                                                                                        Zoho Projects Resources


                                                                                          Zoho Sprints Resources


                                                                                            Qntrl Resources


                                                                                              Zoho Creator Resources



                                                                                                  Zoho CRM Resources

                                                                                                  • CRM Community Learning Series

                                                                                                    CRM Community Learning Series


                                                                                                  • Kaizen

                                                                                                    Kaizen

                                                                                                  • Functions

                                                                                                    Functions

                                                                                                  • Meetups

                                                                                                    Meetups

                                                                                                  • Kbase

                                                                                                    Kbase

                                                                                                  • Resources

                                                                                                    Resources

                                                                                                  • Digest

                                                                                                    Digest

                                                                                                  • CRM Marketplace

                                                                                                    CRM Marketplace

                                                                                                  • MVP Corner

                                                                                                    MVP Corner






                                                                                                      Design. Discuss. Deliver.

                                                                                                      Create visually engaging stories with Zoho Show.

                                                                                                      Get Started Now


                                                                                                        Zoho Show Resources

                                                                                                          Zoho Writer

                                                                                                          Get Started. Write Away!

                                                                                                          Writer is a powerful online word processor, designed for collaborative work.

                                                                                                            Zoho CRM コンテンツ


                                                                                                              Nederlandse Hulpbronnen


                                                                                                                  ご検討中の方




                                                                                                                            • Recent Topics

                                                                                                                            • Mass Update Option for Changing Work Order Owner

                                                                                                                              Hello FSM Team/Mr. Abid, We would like to inquire if there is an option to mass update or bulk change the Owner of Work Orders in Zoho FSM. Current Situation: At the moment, the Owner of a Work Order can only be changed individually, which becomes time-consuming
                                                                                                                            • Categorize Items with Item Headers

                                                                                                                              Hello customers, Did you ever want to classify items based on specific categories to help your customers understand your invoice better? With the new Item Header feature, you can easily categorize items in your invoices and estimates and give them a common title.  Item Headers are available in the Invoices, the Recurring Invoices and the Estimates module. It can be carried forward from estimates to invoices at the time of converting the estimates.  To add an item header: Go to the Estimates, Invoices
                                                                                                                            • Careers Site & Job Openings

                                                                                                                              Hello, It would be good to have a section in the careers site with past and inactive jobs. On that note, active jobs to automatically move to this section once the target date in the job opening is reached. At the moment, Recruit administrator will have
                                                                                                                            • TeamInbox - Configure Email Sending Delay

                                                                                                                              Hello, The feature in Zoho Mail to automatically DELAY a sent message by X minutes is a wonderful feature to catch mistakes before they are sent out. Is this possible with TeamInbox? If not, is it on the roadmap to add it in? Thanks
                                                                                                                            • Zoho Desk API Custom Module not all data is showing up

                                                                                                                              When i get a record by id for my new module: responseDetailed = invokeurl [ url :"https://desk.zoho.eu/api/v1/cm_tickets_CM/" + record.getJSON("id") type :GET parameters:"" connection:"desk_connection" ]; The response doesnt contain all fields, the field
                                                                                                                            • Can you sync CRM contacts to TeamInbox?

                                                                                                                              Can you sync CRM contacts to TeamInbox? Or at least upload them? From what I can see, you have to enter them manually one at a time.
                                                                                                                            • Team Inbox Support Is TERRIBLE

                                                                                                                              Team inbox has the worst support team i've ever dealt with. They take forever to reply to your emails/issues, if you even get a reply. They don't have a phone number so you can't talk with anyone. There is clearly bugs in their system and they don't address
                                                                                                                            • Introducing ServiceDesk Plus Integration

                                                                                                                              Integrate Zoho Sprints with ServiceDesk Plus (SDP), a service management system that wraps IT asset management, IT service management, and configuration database management into a unified solution. With this integration, agile teams can track and manage
                                                                                                                            • Request for Backscatter Protection and Filtering Options

                                                                                                                              Hello Zoho Support, Recently, my domain has been targeted by an email spoofing/backscatter attack. Attackers are using our legitimate email addresses, particularly one as forged sender addresses when sending messages from unauthorized servers. Our SPF
                                                                                                                            • Keeping phone number text format exporting from Books to Sheet

                                                                                                                              We have a custom function that copies data from our customers in Books to Sheets. In the process the customers' phone numbers (unless they contain a space) get treated as numeric values, so leading zeros get stripped off, and in some cases scientific
                                                                                                                            • print preview

                                                                                                                              We are using microsoft edge, till 12 sep we were getting directly print option. Now we are getting this preview option we have to click print option again. How to bypass this-preview option?
                                                                                                                            • NOT SYNCING ORGANIZATIONS-ZOHO BOOKS AND ZOHO INVENTORY

                                                                                                                              I purchased the zoho books before and again i purchased zoho inventory after 2 day while syncing the orzaniazation i deleted the trial account of inventory and started the new organization on same user. The problem is that the new inventory organization
                                                                                                                            • Vehicle Tracking

                                                                                                                              we have GPS devices that installed on our vehicles, and we would like to know if it's possible to  get vehicle live location data from the GPS device To Zoho Creator App.   Thank You
                                                                                                                            • [Critical] Massive delays with e-mail

                                                                                                                              It takes half an hour or longer for emails to arrive or replies to go out! Another thing I have noticed with outgoing e-mails is that I see an error message when I click on "Show original" (tab "HEADER"). If I click on the "CONTENT" tab, the mail body
                                                                                                                            • Cliq iOS can't see shared screen

                                                                                                                              Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards
                                                                                                                            • Sheet co-edit: no live presence — also on Collaborate demo?

                                                                                                                              Two Sheet co-edit sessions open OK (same document_id, document.edit: true), but there’s no real-time collaboration: no cell highlights, Group Chat → Users stays empty. Writer co-edit works on the same Office Integrator setup. We see the same on the official
                                                                                                                            • ZohoのAIエージェント、作り方から使いどころまで。デモとユーザー事例で学ぶ|12/8東京・無料

                                                                                                                              ユーザーの皆さま、こんにちは。 ゾーホージャパンの中野です。 12月8日(火)、Zohoコミュニティで初めてとなる「Zoho コミュニティ ユーザー総会 2026」を開催します。 年に一度、ユーザーとZoho社員が集まる総会として、今回は100名規模での開催を予定しています。 ユーザー企業の実践事例、AIエージェント / Zoho MCP のデモ、CRM・Campaignsの活用セッションなど、 日頃の交流会よりも幅広いプログラムをご用意しました。 以前のご案内から新たに予定している内容も含め、当日の見どころをご紹介します。
                                                                                                                            • How to sync Organisation Contacts to Android / AES

                                                                                                                              After migration form Exchange compatible server, I got Org Contacts: I've turned on EAS Organisation contacts sync. But on my phone they don't appear and there is no contacts folder to select for these contacts. Only personal contacts. They do appear
                                                                                                                            • Zoho Inventory | Can't uncheck/turn off Advance Tracking

                                                                                                                              Hi, I wanted to know if there's a way to turn off Advanced Tracking (such as Serial Number or Batch Tracking) for an item in Zoho Inventory. I’ve read that you might need to delete associated transactions and clear the opening stock to disable these features.
                                                                                                                            • A way to report on all leads for a given month

                                                                                                                              Is there a way to report on ALL leads created in one month by source.  I need to include both open, closed lost and converted leads.   Right now I can only see source of non converted lead and cannot find a way to add the converted leads to the same report.   I'm trying to do this to gain insight into my sources of leads, volume in and disposition of each lead.
                                                                                                                            • Unable to delete domains from Zoho Campaigns

                                                                                                                              This error occurs while deleting a domain "This domain cannot be deleted because we've found $1sender addresses associated to it." But I have no more sender addresses of this domain anymore. I can't delete the domain.
                                                                                                                            • Ability to translate Zoho CRM Kiosks

                                                                                                                              Hi team, Is support for translating kiosk text and screen names in the Zoho CRM translation tool planned on the roadmap? Thanks,
                                                                                                                            • Automating CRM backup storage?

                                                                                                                              Hi there, We've recently set up automatic backups for our Zoho CRM account. We were hoping that the backup functionality would not require any manual work on our end, but it seems that we are always required to download the backups ourselves, store them,
                                                                                                                            • Account for Cryptocurrency Holdings in Zoho Books/Custom Currencies?

                                                                                                                              Hello, I've recently started using Zoho to run my small business and I've really been enjoying all of its features. However, I've been struggling to find a way to account for cryptocurrencies in Zoho Books. My company mines a Cryptocurrency token called
                                                                                                                            • CNIL - Suivi de Pixel

                                                                                                                              Bonjour à tous, À la suite de la nouvelle recommandation de la CNIL sur les pixels de suivi dans les e-mails, savez-vous si Zoho Campaigns permet : de conditionner le suivi des ouvertures au consentement de chaque contact ; de proposer un lien permettant
                                                                                                                            • #21 The Customer Sent Part of It Back

                                                                                                                              Ravi delivered 200 trays to a customer and raised an invoice for the full order. Two days later, the customer returned 60 trays. The customer had also paid an advance against the invoice. Ravi now needs to account for the returned items, adjust the amount
                                                                                                                            • Zoho Assist Feature Update: November 2026

                                                                                                                              Screen Analyzer Zoho Assist’s Screen Analyzer, part of Answer Bot, helps technicians troubleshoot faster during live sessions. Capture the full remote screen or a specific portion, and it instantly analyzes the snapshot to detect errors and issues. It
                                                                                                                            • Zoho Assist Feature Update: October 2026

                                                                                                                              H.265 support for Native Viewer and Mobile Viewer H.265 (HEVC) delivers sharper screen sharing at lower bandwidth than H.264. Already live in the Web Viewer, the codec is now available for the Windows Native Viewer and Mobile Viewers too. Support is in
                                                                                                                            • Trident Missing

                                                                                                                              No way you guys get so close to having trident complete for over a year then just kill it off. Wow just wow
                                                                                                                            • Feature Request: Fully customizable record layouts in Zoho FSM (movable sections and custom subform tables)

                                                                                                                              Hi Zoho FSM Team and Community, We’d like to suggest a feature that we think would help many FSM users: full control over the layout of record detail pages, starting with the Work Order view. Current situation When you open a Work Order, its sections
                                                                                                                            • KB Articles from Zoho Learn - Import as .md

                                                                                                                              I love the concept of being able to use articles from Zoho Learn as knowledge base articles for Zia Agents. This will absolutely help with proper documentation and organization of company processes and SOPs. This was a great concept. However, even when
                                                                                                                            • Why don't Zia agents support file uploads?

                                                                                                                              I am trying to build a Zia Agent that allows uploading of a PDF file and uses the GLM5 model to process it and extract information. But agents.zoho.com has no way to enable file uploads on the agent. Additionally, GLM5 based agents keep outputting their
                                                                                                                            • Building Toppings #10 - Using signals to build real-time notifications between Bigin and Zoho Desk

                                                                                                                              Hello Biginners! In our previous post, we covered Bigin Variables and Widgets. In this post, we'll explore another component: Signals. To show how Signals work, we will build a real-time use case integrating Bigin and Zoho Desk. It connects Zoho Desk
                                                                                                                            • ¡Gracias por acompañarnos en los Workshops de Zoho España!

                                                                                                                              Los pasados 3 y 4 de noviembre celebramos una nueva edición de los Workshops de Zoho España en el Hotel NH Las Ventas de Madrid. Dos jornadas de formación práctica, demostraciones en directo y encuentros con expertos de Zoho en las que compartimos conocimientos,
                                                                                                                            • Never miss a follow-up with personal reminder agent | Zoho Cliq AI Use Case #03

                                                                                                                              A task mentioned mid-conversation rarely survives the conversation. Someone asks you to follow up, you say you will, and by the time you remember, the message is three hundred lines back, buried under two meetings and a dozen other threads. Personal Task
                                                                                                                            • Calendar won't load

                                                                                                                              I run into this problem about once a week, where I try to open my Zoho calendar in a web browser, and it just gets stuck, waiting forever to load (see attached screenshot). I'm usually using Edge or Duck-Duck-Go browser. Sometimes it loads just fine,
                                                                                                                            • Change 'default' project dashboard

                                                                                                                              Is it possible to change the default project dashboard for all projects? Both in layout and in what widgets are shown? We have a lot of (short-running) projects and I want to quickly see the tasks and milestones when I open a Project, but I don't want to change the layout for all my projects manually. Thanks, Menno
                                                                                                                            • Multiple subscription plan line items in Zoho Billing quotes

                                                                                                                              I run an IT company and sell a lot of licences. A client might have multiple subscription plans including software licences in different categories. A client might have Microsoft licences, antivirus licences, web hosting and maintenance package services.
                                                                                                                            • Unable to integrate Whatsapp Messaging into Zoho CRM - Business Messaging

                                                                                                                              Hello, I want to set up Business Messaging in our Zoho CRM and am struggling to set it up. I have logged into the account and our facebook business page, our business shows in the dropdown for WhatsApp Business Account but does not for WhatsApp Business
                                                                                                                            • Files in Teamspaces: keep your team's documents where the work happens

                                                                                                                              Release Note: This feature is available for all accounts across all DCs Hello Everyone, A Teamspace is built around a specific team and a shared objective, and it holds the modules and projects that team works with every day. The document that team depends
                                                                                                                            • Next Page