You can do a SUM query, heres an example: { "select_query":"select SUM(Annual_Revenue), Company, Last_Name from Leads where Annual_Revenue >= 1000 Group by Company, Last_Name" }
Do you know if anyone has added COQL to one of the OpenSourced SQL Query tools or Web Based Query tools? It would be very handy to have a MS SQL Studio like query tool. I have run across an ODBC driver and an OleDB Provider (driver) for Zoho - however I don't know if those drivers are using COQL or if they are making API calls to each module separately and then combining results into a single final result record set.
Ah - I think you are suggesting using Zoho Analytics with Zoho CRM connection and use the Query tool in Zoho Analytics. Good call. I guess I somehow was not certain that tool was restricted to using the same COQL API that we use or if they had augmented functionality in some manner. Thanks for that suggestion Andrew!
Great video Andrew. Do you know if Zoho has plans on their roadmap to support aggregate functions ex SUM(AmountField) in a COQL query?
You can do a SUM query, heres an example:
{
"select_query":"select SUM(Annual_Revenue), Company, Last_Name from Leads where Annual_Revenue >= 1000 Group by Company, Last_Name"
}
This query API can also be used in the external app. I have an external application and I want the same result as this. Is it possible?
Yes. You'd need to manage the Oauth connection externally however
Do you know if anyone has added COQL to one of the OpenSourced SQL Query tools or Web Based Query tools?
It would be very handy to have a MS SQL Studio like query tool.
I have run across an ODBC driver and an OleDB Provider (driver) for Zoho - however I don't know if those drivers are using COQL or if they are making API calls to each module separately and then combining results into a single final result record set.
I don't know if anyone has made that extension.
If you're attached to SQL, you can connect CRM with Zoho Analytics and write your query there
@@aetherautomation "attached to SQL" - Do you mean using MS-SQL management Studio on local machine?
Ah - I think you are suggesting using Zoho Analytics with Zoho CRM connection and use the Query tool in Zoho Analytics.
Good call. I guess I somehow was not certain that tool was restricted to using the same COQL API that we use or if they had augmented functionality in some manner.
Thanks for that suggestion Andrew!