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

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • 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
          • Kaizen #222 - Client Script Support for Notes Related List

            Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore how
          • Kaizen #217 - Actions APIs : Tasks

            Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.
          • Kaizen #216 - Actions APIs : Email Notifications

            Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

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

                              Zoho CRM コンテンツ




                                ご検討中の方

                                  • Recent Topics

                                  • Payroll and BAS ( Australian tax report format )

                                    Hello , I am evaluating Zoho Books and I find the interface very intuitive and straight forward. My company is currently using Quickbooks Premier the Australian version. Before we can consider moving the service we would need to have the following addressed : 1.Payroll 2.BAS ( business activity statement ) for tax purposes 3.Some form of local backup and possible export of data to a widely accepted format. Regards Codrin Mitin
                                  • Invalid scope choice: Workdrive integration in CRM

                                    Bug: There is an invalid option in the permission choices for Workdrive integration in CRM. If the entry "WorkDrive.teamfolder.CREATE" is selected, it will return a message indicating invalid OAuth scope scope does not exist.
                                  • What's New - February 2026 | Zoho Backstage

                                    February 2026 brings a major new addition and a collection of enhancements across Zoho Backstage. We thought about writing a long introduction, but the updates in this release make a strong case on their own. So we’ll skip the buildup and dive straight
                                  • Attaching files to emails within CRM Deals.

                                    Hello, We have recently started using the extension "Workdrive for CRM" (Related List) to view/store our documents for each Deal, instead of using Attachments. Overall it feels like a better way to go but the user experience is not so great when it comes
                                  • Anyone worked out how to export or screengrab a full heatmap?

                                    I'd love to be able to include a copy of a heatmap in a report but can't work out how to grab the whole thing as there doesn't appear to be an export function? Thanks in advance.
                                  • Establishing Relationships among contacts/leads with Reciprocal

                                    Is there any way to create a relationship between contacts and leads and be able to go into just one of the files and have it reciprocate the entry in the other file? For example, if I have two people say John and Jane Smith who are husband and wife.
                                  • Placeholder for Agent Signature in Email Templates

                                    Dear Zoho Team, I hope this message finds you well. We currently face a limitation when designing email templates in Zoho Desk. While we can create email templates and include a footer at the end, the agent signature is always appended by default at the
                                  • Custom View and Custom Fields on Zoho Books

                                    Hi, I have some custom fields on Estimates and Invoices. I also use Custom Views so I can have a lot of information at a glance. I want to include my custom fields as columns in my custom views of estimates / invoice, but it looks like is not possible.
                                  • %PaymentLink%

                                    Does not work. Software creates a BAD link. ....and yes payment options are turned on. Link on the invoice pdf once opened will work but this template is a joke.
                                  • Syncing calendar with Google Calendar doesn't work when events are sent to auto repeat

                                    Hi... The ZOHO CRM -- GOOGLE CALENDAR sync is broken. If I create a single event on either side, sync works, but if I create an event with auto repeat on either side it doesn't work. Furthermore, events created before the sync don't show up in the calendar.
                                  • Allow Global Admin to access/edit all forms without changing owners

                                    Hi there, Please consider adding a feature where the Global Admin of the account an automatically access/edit any form in the Company Account. I'm the Global Admin on our Zoho One plan, and we have multiple users that use/create forms. But for me to access
                                  • Can Zoho Marketing Automation send OTP codes via WhatsApp during user registration?

                                    The flow I would like to implement is: A user signs up in the mobile app and enters their phone number. The system generates a one-time verification code (OTP). The OTP is sent to the user via WhatsApp message. The user enters the code in the app to confirm
                                  • Where to show Customization Field ?

                                    Dear Sir, I have made some New Field in Item Field Customisation. Now I don't require that field in Estimate, Sales Orders etc. I just wants that field in Sales Invoice to Show/Hide... Is that possible ?
                                  • What's New in Zoho Analytics - February 2026

                                    Hello Users! We're back with another round of updates for Zoho Analytics. This month's release focuses on giving you greater flexibility in how you visualize, manage, and act on your data - with new features like custom visualizations, remote MCP server,
                                  • Zoho Books (and other Finance Suite Apps) - Clickable Item Name on Invoices and Reports

                                    Hi Zoho Books team, It would be really helpful if the Item Name on Reports were clicable to take me to the item. The same on Invoices, often I am looking at an invoice and I want to look at the deails of a product. A link here would be helpful to jump
                                  • ZOHO Reports are taking longer time to get refresh

                                    Hi Team, Since last few days, I'm facing issues in getting updated reports. For eg: right after making an expense entry or even posting a journal, it is taking longer then expected for the updated reports. Refer below: "You are viewing the report that
                                  • Display actual mileage on an invoice

                                    My users are creating expenses in Zoho expense. For example, they expense 10 miles and get paid 7 dollars (10 miles * IRS rate of .70). If I look at the expenses in Zoho Books, it does show them at 10 miles at .70 cent When I add these expense to an invoice
                                  • Can't change form's original name in URL

                                    Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new
                                  • Can you create relationships BETWEEN contacts within the same module

                                    I am setting up my CRM, and I want to have a way to connect contacts within the same module.  Is there a way to do this?  If not - how do I decide how to split up contacts to make connections?  What are best practices for this? We have clients who need
                                  • Function and workflow to create customer payment and send receipt

                                     I am attempting to set up a workflow/custom function for the automatic creation of a customer payment and sending the email receipt, but am receiving the error "Improper Statement Error might be due to missing ';' at end of the line or incomplete expression" I've been over everything several times and cannot see where the error is (code is copied into the attached document).  I haven't used custom functions before with Deluge, so it's very likely something very simple, or I've completely mucked
                                  • Disable Sign Up option in Zoho Creator Portal and show only Sign In page

                                    Is it possible to disable the Sign Up option in a Zoho Creator portal? The requirement is to show only the Sign In page and completely remove or hide the Sign Up page, so users cannot create accounts directly from the portal login page. Is there any setting
                                  • Restrict Payment Methods

                                    Allow us to restrict certain payment methods specific for each customer.
                                  • How to install Widget in inventory module

                                    Hi, I am trying to install a app into Sales Order Module related list, however there is no button allow me to do that. May I ask how to install widget to inventory module related list?
                                  • Can I view the KB in the same way as a customer logged in as my Agent?

                                    Sorry if this seems a mad question.  I have some Articles that I want to be seen by my Agents and the status of these is set to Agents only.  We also have some that are set to Public. When I sign in with my private email address (as a customer) I can
                                  • What’s New in Zoho Inventory — Latest Features, Integrations & Updates | December 2025

                                    Zoho Inventory has evolved significantly over the past months, bringing you smarter, faster, and more connected tools to streamline your operations. Whether you’re managing multichannel sales, complex fulfillment workflows, or fast-moving stock, our newest
                                  • Which user's capacity is used for Shared Mailbox storage?

                                    We use shared mailboxes at our company, and their size is increasing daily. Which user(s)'s total mailbox limit is being used up by this space?
                                  • Evernote (ENEX) import limitations

                                    I have been with Evernote since 2010, but the latest price increase is ridiculous. I am currently testing Zoho Notebook as a replacement. I am impressed so far - if it were not for critical need to import legacy Evernote notes, I would 100% migrate to
                                  • Can I create a CODE 128 custom field for my items in Zoho Inventory and then use it for generating Sales Orders?

                                    Can anyone helps me, I don't want to use the SKU code for scanning my products.  ​Because all my products have a CODE-128 label attached.
                                  • Prevent duplicate with custom fields?

                                    I was wondering something about custom field/custom modules in Zoho Desk. For some reason you can make a custom field mandatory but not unique? For example, if I create a custom module to manage equipment and renewal and make a field serial number no
                                  • Zoho Books' 2025 Wrapped

                                    Before we turn the page to a new year, it’s time to revisit the updates that made financial management simpler and more intuitive. This annual roundup brings together the most impactful features and enhancements we delivered in 2025, offering a clear
                                  • Multiple Vendor SKUs

                                    One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
                                  • Create Invoice automated with Package

                                    Does anyone knows how to create an invoice from a SO when we have created the package? We do these manually. and validate that the product packed is the product invoiced (if the order is partially packed) Regards, JS
                                  • Unable to integrate Zoho Projects and Zoho Workdrive

                                    I'm a Zoho One subscriber. When I go to Zoho Projects > Settings > Marketplace > Zoho Apps I do not see an option for Zoho Workdrive but I do see one for Zoho Docs that does nothing. How do I get the option to integrate Zoho WorkDrive and Zoho Proje
                                  • Disable payment thank-you emails

                                    Hello, can someone please tell me how to disable sending of the "Payment Thank-You" emails? 
                                  • How to backdate record payment for the invoice

                                    I would like to record a payment which happened 2 days ago, but I am not able to select any date later than today. I backdated the invoice, too, but it doesn't change anything
                                  • Help with deluge script

                                    Hi Community, this is my first Deluge script. I've pieced it together from reading various articles I want to use it in a workflow to 1 Convert a lead to a contact 2. Create a record in a custom module Below is what I have got so far but it does not fire
                                  • Marketer's Space: Why email authentication matters in Zoho Campaigns

                                    Welcome back to another post in Marketer's Space! If you've recently started using Zoho Campaigns, you've probably come across terms like SPF and DKIM. You may have also noticed emails that show "via zcsend.net" in Gmail when testing or sending campaigns.
                                  • Feature Request: "Send Invitation" Toggle for Events

                                    I am writing to request a critical "Quality of Life" update for the Activities module. Currently, adding people to the Participants field in an Event triggers an automatic email invitation/acceptance tracking with no way to opt-out. For general events
                                  • Edit email address that appears on invoice

                                    Hi How do I change the email address that appears on invoices, it is showing the email address that i used to sign up to zoho with but I want to change it to another email address that we use for accounts. also is there a way to edit the position of a
                                  • Introducing Zoho Sprints 3.0

                                    Zoho Sprints is consistently evolving in steady increments. The introduction of the latest version, with its enterprise level solutions, brings to you advanced capabilities that propel your agile efforts in the right direction. Here's a quick glimpse
                                  • Next Page