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.

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

• 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 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

• Recent Topics

• Collapsing and expanding of lists and paragraphs

  hello Would you ever implement Collapsing and expanding of lists and paragraphs in zoho writer ? Best regards

• Migrating Brevo Automation Logic to Zoho Campaigns

  Hello Zoho Campaigns Support Team, I am in the process of migrating my email marketing from Brevo to Zoho Campaigns. I have around 10,000 contacts, which I have already successfully exported from Brevo and imported into Zoho Campaigns. I now need guidance

• Is there a way to delete workspaces?

  I want to remove one of the workspaces in my Campaigns account. I don't see any obvious way to do this. Am I missing something?

• New Custom View -Sorting the Custom fields

  While creating a New Custom View in invoice , Customers, Bills ,expense etc , the sorting of custom fields are not available , a query function "order by / sort by  " may also be included in  Define new criteria module  which will be more beneficial to

• Make CAMPAIGNS email look as simple as possible

  Hi there I'm trying to make my Campaigns email look as much like a normal email as possible. I'm a bit stuck with the "justification" of the email email block. Can I LEFT JUSTIFY the "whole email" to make it look "normal"? (Please see screenshot attached)

• Canadian Banks ?

  Can you advise which Canadian Banks can be used to fully sync credit cards and bank accounts? Thanks

• Sorry! we encountered some problems while sending your campaign. It will be sent automatically once we are ready. We apologize for the delay caused.

  Hello. Lately we are having problems with some campaigns, which show us this error message. Sorry! we encountered some problems while sending your campaign. It will be sent automatically once we are ready. We apologize for the delay caused. We can't find

• Can I remove or divert certain contacts from an active Campaigns workflow?

  I have created a workflow in Zoho Campaigns, which sends different emails, once contacts have been added to a mailing list. To choose which email to send to the contacts, there are conditions, which divert contacts based on their company type and their company size. There was a subsection of this workflow, where company size wasn't selected correctly, and some contacts have been sent down the wrong path and received the wrong email. The workflow contains a reminder loop and a further series of emails.

• How to map fields from Zoho Recruit to Zoho People

  I've got these fields from my Job Offer that I'm trying to map to the Work information fields in Zoho People, but they arent showing up. For example, how do I get the department name field (in the job post) to map to the work information field in Zoho

• UTM in zoho campaigns

  Helloo everybody!!! Someone know how IF ZOHO CAMPAIGNS has UTM for tracking the url of any campaigns. thank u

• Full Context of Zoho CRM Records for Zia in Zoho Desk for efficient AI Usage

  Hello everyone, I have a question regarding the use of Zia in Zoho Desk in combination with CRM data. Is it possible to automatically feed the complete context of a CRM record into Zia, so that it can generate automated and highly accurate responses for

• Knowledge base printing

  I saw a posting about printing the knowledge base as I was looking for the answer, but we would like the ability to print out the entire knowledge base with a click, keeping the same organization format.   Bonus would include an index of keywords and

• Search not working!

  I have items in my notebook tagged but when I search for a tag nothing comes up! Any fix for this?

• Updates for Zoho Campaigns: Merge tag, footer, and autoresponder migration

  Hello everyone, We'd like to inform you of some upcoming changes with regard to Zoho Campaigns. We understand that change can be difficult, but we're dedicated to ensuring a smooth transition while keeping you all informed and engaged throughout the process.

• How do i integrate google analytics to Zoho Campaigns?

  Looking to track Zoho Traffic from email Current topic is outdated

• How do teams manage meeting follow-ups across Zoho tools?

  We’re using Zoho tools for collaboration and tracking, but managing meeting notes, action items, and follow-ups across teams is still challenging. Curious how others are handling this within Zoho workflows. Are there best practices or integrations that

• Mejoras urgentes para ZOHO MEETING

  Tengo unos meses usando Zoho Meeting. En general, es buena, pero hay cosas vitales que no logra cumplir con mínima calidad. 1) Calidad de audio y video: urge mejoras. Audio con retraso, imagen borrosa, mal recorte de silueta con fondos virtuales. Además,

• Saving sent email campaign as PDF

  I'm looking to add all campaigns sent to an archive folder in sharepoint. Is there anyway to accomplish this in Zoho Flow ? I'm falling at the first hurdle ... can I automatically save a sent campaign as a PDF to a folder location ?

• Exporting All Custom Functions in ZohoCRM

  Hello, All I've been looking for a way to keep about 30 functions that I have written in Zoho CRM updated in my own repository to use elsewhere in other instances. A github integration would be great, but a way to export all custom functions or any way

• Conditional Layouts On Multi Select Field

  How we can use Conditional Layouts On Multi Select Field field? Please help.

• Appreciation to Qntrl Support Team

  We are writing this topic to appreciate the outstanding level of support from Qntrl Team. We have been using Qntrl since 2022 after shifting from another similar platform. Since we joined Qntrl, the team has shown a high level of professionalism, support,

• How can I hide "My Requests" and "Marketplace" icon from the side menu

  Hello everybody, We recently started using the new Zoho CRM for Everyone. How can I hide "My Requests" and "Marketplace" from the side menu? We don't use these features at the moment, and I couldn't find a way to disable or remove them. Best regards,

• Whatsapp Integration on Zoho Campaign

  Team: Can the messages from Zoho Campaign delivered through Whatsapp... now customers no longer are active on email, but the entire campaign module is email based.... when will it be available on whatsapp.... are there any thirdparty providers who can

• Mandatory Field - but only at conversion

  Hello! We use Zoho CRM and there are times where the "Lead Created Date & Time" field isn't populated into a "Contractor" (Account is the default phrase i believe). Most of my lead tracking is based on reading the Lead Created field above, so it's important

• Using data fields in Zoho Show presentations to extract key numbers from Zia insights based on a report created

  Is it possible to use data fields in Zoho Show presentations along with Zoho Analytics to extract key numbers from Zia insights based on a report created? For example, using this text below: (note that the numbers in bold would be from Zia Insights) Revenue

• Free webinar: AI-powered agreement management with Zoho Sign

  Hi there! Does preparing an agreement feel like more work than actually signing it? You're definitely not alone. Between drafting the document, managing revisions, securing internal approvals, and rereading clauses to make sure everything still reflects

• WhatsApp Channels in Zoho Campaigns

  Now that Meta has opened WhatsApp Channels globally, will you add it to Zoho Campaigns? It's another top channel for marketing communications as email and SMS. Thanks.

• CRM For Everyone - Bring Back Settings Tile View

  I've been using CRM for Everyone since it was in early access and I just can't stand the single list settings menu down the left-hand side. It takes so much longer to find the setting I need. Please give users the option to make the old sytle tile view

• Lets have Dynamics 365 integration with Zohobooks

  Lets have Dynamics 365 integration with Zohobooks

• Add notes in spreadsheet view

  It would be great if we could Add/edit notes in the spreadsheet view of contacts/leads. This would enable my sales teams to greatly increase their number of calls. Also viewing the most recent note in the Contact module would also be helpful.

• Opening balances - Accounts Receivable and Payable

  Our accounting year starts on 1st August 2013 and I have a Trial Balance as at that date, including Accounts Receivableand Accounts Payable balances, broken down by each customer and supplier. Q1 - do I show my opening balance date as 31st July 2013 or

• Cancel Subscription

  Hi , Im want to cancel my account but without success please help me to do it

• Making an email campaign into a Template

  I used a Zoho Campaign Template to create an email. Now I want to use this email and make it a new template, but this seems to be not possible. Am I missing something?

• Direct Access and Better Search for Zoho Quartz Recordings

  Hi Zoho Team, We would like to request a few enhancements to improve how Zoho Quartz recordings are accessed and managed after being submitted to Zoho Support. Current Limitation: After submitting a Quartz recording, the related Zoho Support ticket displays

• Multiple Cover Letters

  We are using the staffing firm edition of Recruit and we have noticed that candidates cannot add more than one cover letter. This is a problem as they might be applying for multiple jobs on our career site and when we submit their application to a client,

• URGENT: Deluge issue with Arabic text Inbox

  Dear Deluge Support, We are facing an issue that started on 12/Feb/2026 with custom functions written using Deluge within Qntrl platform. Currently, custom functions do not accept Arabic content; it is replaced with (???) characters. Scenario 1: If we

• File Conversion from PDF to JPG/PNG

  Hi, I have a question did  anyone every tried using custom function to convert a PDF file to JPG/PNG format? Any possibility by using the custom function to achieve this within zoho apps.  I do know there are many third parties API provide this with

• Now in Zoho One: Orchestrate customer journeys across apps with Zoho CommandCenter

  Hello Zoho One Community! We’re excited to introduce Zoho CommandCenter as a new capability available in Zoho One. For the whole customer journey As Zoho One customers adopt more apps across sales, marketing, finance, and support, a common challenge emerges:

• annualy customer report

  we need a report per customer that looks like this invoic number cleaning laundry repair management 01 january xxx euro xx euro xx euro xxx euro 02 february xxx euro xxx euro x euro xxxx euro and so on the years 12 months is that possible to make and

• Totals for Sales Tax Report

  On the sales tax report, the column totals aren't shown for any column other than Total Tax. I can't think of a good reason that they shouldn't be included for the other columns, as well. It would help me with my returns, for sure. It seems ludicrous

• Next Page