Queries in Zoho CRM

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

      • Recent Topics

      • Zoho Payroll's Year in Review 2024

        As we roll into 2025, we'd like to pay tribute to all the milestones we hit in 2024! From releasing out new features that streamlined your workflows to updates that made payroll management smoother, we’ve had a prolific year—all while keeping you, our

      • Zoho Desk Mobile App Year-End Roundup - 2024

        Hello Everyone, Greetings! As you gear up for the festive season, we are excited to share a quick journey into all that is released in 2024! Availability of each feature in iOS and Android released in 2024 are as follows: For more information on the above

      • Task Completion vs Estimated Time

        I need to represent the Estimated Date vs Actual Completion Date for multiple Tasks. How Can I Do this in Zoho Analytics.

      • Upload Field - cannot be checked in rules configuration.

        We wanted to create a process to verify whether the upload fields are empty or not. If empty, then it should deny during submission. We don't want to use the mandatory field setting because in a 10 pager form, some upload field located in page 1 will

      • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

        Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

      • Is it possible to hide Developer Space for all user in Zoho Projects

        Hello! I am Zoho admin in a company and we want to use Zoho Project to manage projects, but after a few days of testing we are not able to "hide" the Developer Space from all kind of users except the admin. To sum up, I want to hide this for all users.

      • Chat function not working properly

        Ever since upgrading to plus, the chat is all messed up. it is coming up behind the web page so that I cannot see what I'm typing and cannot read replies. I can only see the bottom of the text box at the bottom of the page, and then it is blocked. I've

      • Wrong Time on Exported Records

        Hello, All records in my exported Notes .csv file have the incorrect time for Created Time. They are all 8 hours ahead. I've already verified that my time zone is correct in both Personal Settings and Company Settings. Is there any way to fix this?

      • Adding tag to specific record as an acion in a workflow

        Hi! I've created the following workflow in the module 'Leads'. When a record meets the criteria, there should be a tag added to the specific record in the module 'Contacts'. In the module 'Leads', there is a look-up field named 'Kandidaat' which is connected

      • Sync workspace - table

        I have connected two workspaces and I have imported two different query tables from one workspace to the other one, that was a succes. But now I want to import another query table from the same workspace to the other but I get an error. Why is that? (there

      • Subir o Preço Unitário já acrescido de um valor

        To com um desafio grande, e se alguém conseguir me ajudar, seria ótimo! O que eu preciso é que o na hora de adicionar um item no subformulário dos itens cotados do módulo Orçamentos, o preço de lista do item venha acrescido de 20% automaticamente e de

      • Ring in the New Year with Guided Conversations for Smooth Offline Support

        As we step into the new year, it’s time to refocus, re-energize, and gear up for fresh opportunities. But what about your customers as they begin the year with their own set of challenges or queries to resolve? With Zoho Desk’s Guided Conversations (GC),

      • 2024 Wrap: Rediscover these features and enhancements in Zoho CRM

        Hello everyone! I wish all of you a joyful and prosperous 2025! As we welcome 2025, I’m excited to share a recap of the year 2024 and highlight some of the coolest new features and enhancements we’ve added to the Zoho CRM platform. Last year, we announced

      • Exploring SalesIQ's Top Features of 2024: An Insider's Look 🔍

        As we wrap up another year at Zoho SalesIQ, it's time to reflect on how far we've come. This year has been incredible for us in our journey to build a more powerful, flexible, and customer-centric engagement platform. We've introduced several features

      • Free user licenses across all Portal user types

        Greetings everyone, We're here with some exciting and extensive changes to the availability of free user licenses in CRM Portals. This update provides users with access to all Portal user types for free to help them diversify their user licenses and explore

      • How to map a global picklist from one module to another

        Hi there, i currently have a new field that is called sales office which we use for permission settings between our different offices located in different countries. It is a global set picklist with three different options: MY, SG and VN. I want to be

      • updateTask Zoho Connect API

        When I do POST request by https://connect.zoho.com/pulse/api/updateTask with parameters scopeID, taskId, title, status and with header Zoho-oauthtoken, I got next response: {'updateTask': {'reason': 'You are not authorized to do this action.', 'result':

      • Alert for Back Navigation in Zoho Creator Widgets on Mobile Apps

        In Zoho Creator widgets, when a user navigates back on mobile devices, the data within the widget is reset. This leads to a loss of any unsaved changes or inputs, causing frustration for users. To enhance user experience, we need to implement a confirmation

      • Can Creator integrate with a CRM Sandbox

        zoho & Creator Noob -  I would like to build a Creator App and integrate it to the CRM Sandbox.  Then, when I have the bugs worked out integrate it to the production CRM account.  Can Creator do this ?  I built a test Creator App and integrated it to the CRM in a test zoho account fairly easily.  

      • Allow Multiple Scheduled Appointments with Zoho Support

        Dear Zoho Team, I hope you're doing well. First, thank you for introducing the option to schedule support calls via the Zoho CRM booking link. This has been a fantastic enhancement, eliminating the need for back-and-forth coordination when scheduling

      • Zoho CRM - best way to search an account and assign to a deal

        Hi Everyone I am looking for some advice. I want to find the best way to complete the below steps. We have a deal and once it reaches a certain stage we need to allocate a supplier / vendor to this deal along with the salesperson. I want to add (ideally

      • Zia Call Intelligence only up 10 License

        I have been trying to install Call Intelligence for two days now, but strangely, the button is missing at this point. The documentation could be better, but most importantly, someone should inform small businesses like us that they don’t even bother enabling

      • Accrue Leave by Hours Worked?

        My locality (Michigan, US) has enacted a law that requires that 1 hour of sick leave be accrued for every 30 hours worked. I cannot see how to implement this policy in Zoho People. There does not appear to be a mechanism for accruing leave proportional

      • Zoho LandingPage is integrated with Zoho One!

        Greetings to the Zoho One users out there! We're delighted to let you know that Zoho LandingPage is available in Zoho One too! With Zoho LandingPage, you can host custom-made landing pages, and persuade the visitors to dive deeper by making further clicks,

      • Are downloadable product available in Zoho Commerce

        Hi all. We're considering switching to Zoho Commerce for our shop, but we sell software and remote services. Is there a features for downloadable products? I can't find any information about this. Thank you very much Alice

      • Fixed assets recording

        Hello there, I recorded a bill for a vendor contain (Computer) so the PC is a fixed assets, do I need to do a manual journal to include this PC under the fixed assets category (furniture & equipment)? If yes, please take me through the manual journal

      • error in importing customers

        get this error message while importing customers, there is no column for COUNTRY CODE in sample excel file

      • Workflow Based on Manual Journal

        Manual journal entries are one of the few areas that cannot kick off a workflow automation in Zoho Books currently. I would propose considering adding that. My use case is that the payroll provider I use (a flavor of SurePayroll) has a Zoho Books automation

      • Digest Décembre - Un résumé de ce qui s'est passé le mois dernier sur Community

        Bonjour chers utilisateurs, Toute l'équipe Zoho france vous souhaite une année remplie de joie, de réussite et de prospérité. Alors que nous débutons cette nouvelle année avec des projets innovants, des astuces, des produits et bien d'autres choses encore,

      • BANK FEED - MAYBANK , provider from YODLEE IS NOT WORKING

        As per topic, the provider YODLEE is not working for the BANK FEED. It have been reported since 2023 Q3, and second report on 2023 Q4. now almost end of 2024 Q1, and coming to 2024 Q2. Malaysia Bank Maybank is NOT working. can anyone check on this issue?

      • New Year Wishes to the Zoho Finance Developer Community!

        Hello developers, Happy New Year! As we step into 2025, we wish you a journey filled with growth, success, and exciting opportunities ahead. We’re thrilled to announce that we have something exciting in store for you. Welcome to the Zoho Finance Developer

      • Update Candidate Status Through Workflow in Blueprint

        Hi Team,  We have a blueprint built out with custom functions that update particular fields based on candidate actions. When particular fields are updated we need to move the candidate forward in the blueprint. We tried to do this through a workflow,

      • Button Display Conditions

        Hi Guys, Is it at all possible to have extra button conditions? Context: We have data in our deals module which has a custom button which converts the deal into contacts + set up relationships between them. At the end of the conversion we set a field

      • Ayuda con zoho creator x zoho Crm

        Hola a todos, Estoy teniendo dificultades al sincronizar datos entre Zoho Creator y Zoho CRM. Mi objetivo es lo siguiente: Busque un registro en el módulo Contactsde Zoho CRM utilizando el correo electrónico del registro de Zoho Creator. Si se encuentra

      • How to Replace an Assessment in a Job Opening on Zoho Recruit

        Hi everyone, I’m currently using Zoho Recruit and would like to replace the assessment linked to a specific job opening. I want to remove the existing assessment and add a new one. What is the best way to do this without losing any important data or affecting

      • Fixed asset management

        I want to know if there is any individual module for fixed assets management

      • Input GST Reversal for damaged goods

        In our line of business, some items are damaged and we are doing inventory adjustments to remove them from stock. However, as per GST guidelines, there is a specific rule that we have to reverse Input GST availed for such items and needs to be reported

      • Introducing Record Summary: smarter insights at your fingertips

        Hello everyone, Building on the recent launch of Zoho's in-house Zia Large Language Model (Zia LLM)—a major milestone in Zoho CRM’s AI capabilities—we’re excited to introduce the Record Summary feature. This powerful addition makes use of Zia LLM to simplify

      • No longer get Cliq notifications on phone if app not started

        On Android, I used to get notifications on my phone whether I was in the app, or it was started. Then about a month ago, I stopped seeing notifications on my phone UNLESS I had already started the app. So if I reboot my phone, and never start the app,

      • Error AS101 when adding new email alias

        Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.

      • Next Page