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
- Query
- Source
- Variables
- Serializer
- 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.
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.
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
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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
New to Bigin?
Topic Participants
Shylaja S
Rich Brandwein
Pablo Silva Osorio
Jaya Suriya J
Prabhu
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 thisKaizen #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 howKaizen #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
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
When Does WorkDrive integrate with Books?
When Does WorkDrive integrate with Books?POP mailbox limits
If I am accessing a remote POP mail server using Zoho Mail is there a mailbox quota for the account or is it all related to my mail account storage limits?Warranty Service and Repair in Zoho FSM
Hi There, We are a retail store that sells products and also performs installations and repairs. Our field technicians handle this work. Some repairs are covered by manufacturers, who reimburse us for both parts and labour. In these cases, we performZoho Sheet for Desktop
Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?WhatsApp phone number migration
Hi @Gowri V and @Pheranda Nongpiur, Thanks for implementing the promised enhancements to the integration between Zoho CRM and WhatsApp. The previous discussion has been locked, so I'm opening this new one. I am copying below a specificWebDAV support
I need WebDAV support so that I can upload/download (and modify) documents from my local file system. Is anything planned in his direction?SPF: HELO does not publish an SPF Record
I am using Zoho mail. Completed all of the required prerequisites from the dashboard to avoid any issues with mail delivery. But when checking on mail-tester.com getting the following error. Can anyone help me solve this?How do I create an update to the Cost Price from landed costs?
Hi fellow Zoho Inventory battlers, I am new to Zoho inventory and was completely baffled to find that the cost price of products does not update when a new purchase order is received. The cost price is just made up numbers I start with when the productPrice Managment
I have been in discussions with Zoho for some time and not getting what I need. Maybe someone can help explain the logic behind this for me as I fail to understand. When creating an item, you input a sales rate and purchase rate. These rates are justRegarding the integration of Apollo.io with Zoho crm.
I have been seeing for the last 3 months that your Apollo.io beta version is available in Zoho Flow, and this application has not gone live yet. We requested this 2 months ago, but you guys said that 'we are working on it,' and when we search on GoogleActual vs Minimum
Hi all, I am sure I am not the only one having this need. We are implementing billing on a 30-minute increment, with a minimum of 30 minutes per ticket. My question is, is there a way to create a formula or function to track both the minimum bill vs theGenerate leads from instagram
hello i have question. If connect instagram using zoho social, it is possible to get lead from instagram? example if someone send me direct message or comment on my post and then they generate to leadKaizen #234 - Automating Deal Handoff with Zia Assistant API, Workflow, Deluge, and Widget in Zoho CRM
Hello all! Welcome back to a fresh Kaizen week. In this post, we will explore how to automate the deal handoff process in Zoho CRM using Zia Assistant API + Workflow + Deluge + Widgets. Here’s how the final output looks when a deal is reassigned 1. DealHow do you print a refund check to customer?
Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.Ability to assign Invoice Ownership through Deluge in FSM
Hi, As part of our process, when a service appointment is completed, we automated the creation of the invoice based on a specific business logic using Deluge. When we do that, the "Owner" of the invoice in Zoho FSM is defaulted to the SuperAdmin. ThisEnhancement to ICR’s field prompting: Preferred data extraction using advanced field prompting
Dear Customers, We hope you’re well A quick background Intelligent Character Recognition (ICR) comes as part of Zia’s optical recognition capability called Zia Vision. When we introduced it last April, the data extraction was training-based and was applicableSee a list of all records enrolled in a cadence?
I am looking for a way to see a list of all leads or contact currently enrolled in a cadence. I do not see any way to do this through the cadence UI.Limitation in chart of accounts
There is a limitation of 4000 accounts in chart of accounts Zoho needs to remove this limitHow do I change the account bank charges are charged to?
I want bank charges charged to my Credit Card Fees account. Is there a way to do this?Real signature in Zoho Expense PDF report ?
Hello ! Is there a way to put a real signature on the signature line when a PDF report is generated in Zoho Expense? Through Zoho Sign or another way? Can't seem to make it work.Copy paste settings
Hello all i have 2 organizations running in ZOHO books in one organization i have customised Tax rates, codes and customized templates instead of manually doing again in org 2 can i have some shortcut to copy paste or export and import??Custom TDS on Vendor Credits via API
Hi, We are using Zoho Books APIs for posting Bills and vendor credits. We are unable to post custom TDS amount posting vendor credits. Can you please share the API spec and Payload that need to be sent for Custom TDS for Vendor Credits."Unlink" Advance from Bill without Deleting the Payment Record
I am writing to highlight a significant workflow issue in Zoho Books (India Edition) regarding Vendor Advances and Bills. The Scenario: I recorded an Advance Payment to a vendor. I matched/reconciled this payment in the Banking module. I received a BillWhat is the best way to convert MSG file to Word format?
The best way to convert MSG files to Word format is by using a reliable and professional tool Aryson MSG file Converter. Manual methods are often time-consuming and may not preserve email formatting, attachments, or metadata accurately. In contrast, ArysonZoho Projects : Task should auto-update to 'In Progress' if timer started
Namaskaram. Right now, if a Task's timer is started, the Task stays in 'Not Started' status. One has to manually update it to 'In Progress'. From a #uxdesign standpoint, it is an unnecessarily two step process to start working on a task. It would be better that, if I start the timer on a task, it should automatically change to 'In Progress' status. Crafted with ❤️ Zoho Gurus | Zoho One Practice Team @ CubeYogi Zoho Authorised Partner | 7+ Yrs | 200+ Projects | 100+ CustomersInvoice template with sales tax totals
Hi everyone, I am trying to edit my invoice template so that only the total sales tax collected for my tax group shows up. Right now, under by sub total, each individual tax shows up and that takes up a lot of unnessary space, so I just want the oneZoho Delayed Posting & Loss of Article Thumbnails on BlueSky
Hello! I am wondering if anyone else has had the either of the following issues when posting to socials via Zoho and if there is a fix? 1. Post says it is scheduled or it is live when sent off via Zoho but it doesn't show up on socials till some timeConnection Not Secure (Certificate Mismatch) Error
Hi, Just a fyi, when you go to https://bigin.zohocloud.ca/bigin/Home you get a "Your Connection Is Not private" error. (Certificate mismatch to domain.) I get to that page after I have signed up and signed in as a customer and select the Access BiginUnable to create new finance account in Zoho Books Android app due to missing account number field.
Free plan I have enabled a setting via the website requiring unique account codes to be specified for all accounts. When using the android app, go to expenses, new expense, select account, new account. Promoted to enter the Account name and description.Recording the Investment
Hello, - One Investor Invested to our company, So how do we record investment which we received in our bank in the Zoho books ? - How do we record if we provide shares to the investor in the Zoho books? ThanksClient and Vendor portal at the same time
We have companies that serve both as clients and vendors and they are linked. However, we have a problem giving them access to the vendor/client portal. If they accept the invitation from the client portal, when we try to invite them to the vendor portalIntegrate Multiple ZohoBooks organization with zoho projects
We have successfully connected our Zoho Books with Zoho Projects for synronizing timesheet data. Our Business specialty is, that the staff of the Main company (A) is working on several projects, but the Clients are sometimes contracted and paying to aWays to calculate the difference form two years or months
Hi to everyone I have this request: I need to show the difference or variation from two periods (years or months) whether using a Pivot View or a graph, in this is case is better in a Pivot view. In the pivot view I will have the amount or results fromCareer site URL - Suggestion to modify URL of non-english job posting
Hi, I would like to suggest making a few modification to career sites that are not in english. Currently, the URL are a mix of different languages and are very long. It makes for very unprofessional looking URLs... Here is an example of one of our URLIntroducing Contract Settings & Backdated Contracts in Zoho Contracts
We are rolling out updates that give you more control over how contracts are created and managed in Zoho Contracts. From defining default workflows with Contract Settings to aligning agreements with real timelines using Backdated Contracts, these enhancementsCelebrating our customers on International Client's Day
Hi everyone, Every customer is part of our Zoho Desk family, and we wouldn’t want to miss celebrating you on this special day. This International Client's Day, we’d like to take a moment to appreciate every customer who has helped us grow and build meaningfulFaster Ticket Response with use of Snippets in comments
Hello everyone, Responding to tickets often involves repeating the same messages, whether it is sharing updates with customers or leaving notes for internal collaboration. To make this easier and more consistent, we are allowing agents to use snippetsImproving Zoho Creator's email deliverability
Hi all, We're pleased to announce updates to email handling in Zoho Creator to improve the deliverability of the emails sent from the Creator platform. These updates have been designed keeping in mind the fact that emails from domains with strong senderWhat's New in Zoho Billing | February 2026
February brings a powerful set of updates to Zoho Billing, from smarter subscription management and flexible payment options to better reporting and more control over your hosted pages. Here's everything that's new this February. Create SubscriptionsReassign Partially Saved Entries
Hi, I would like to be able to go to Partially Saved Entries and like the option to delete them I would like the option to multi-select and be able to reassign them to another user to complete (Such as when a user has left the company). Thanks DanNext Page