How can I use COQL
Hello, I want today, to use COQL, but I don't understand how I can use this. Where I put the code ? I see the documentation, and I understand how it work, but I don't understand where the code must be placed. Thanks; RB
Response does not include refresh token
I have created a "server-based application". I ran the code on terminals. `` ` $ curl -X POST https://accounts.zoho.com/oauth/v2/token \ -F "grant_type = authentication_code" \ -F "client_id = {client_id}" \ -F "client_secret = {client_secret}" \ -F "redirect_uri
Can we integrate internal ERP with Zoho?
Can we integrate internal ERP with Zoho, which would help in syncing contacts between Zoho CRM and our ERP.
Pagination and Date Filter is Not Working in Zoho CRM V2 API
We are trying to get leads from our Zoho CRM using API version 2. We only need to get the last modified leads from our system. According to your documentation we have passed the parameters to request as follows We have to get the records which are updated/created on or after 2019-11-04T00:00:00+00:00 means after 12 AM on 4th Nov to 5th Nov 12 am. In our CRM there is last records which are updated/created on 24th October. After that no data is modifed and created still the response is showing all
How to Post XML leads into CRM
Hello All My lead services is offering the following XML as the lead format type for delivery over HTTP Post Can this be done? How is it done? I would like the leads to be put into the que for approval so they are not written directly to the database I have read the ZCRM FAQ and it is not clear to be at all how this can be done Any thoughts or comments would be welcomed. Thanks in advance. If someone could volunteer that is fine if you are looking for compensation to develop this for us we
Simple way to get Auth Token?
Hello, I am creating a PHP application where I first need to have a user login (verify they have a Zoho account so I should get their Auth Token) I am having trouble understanding in the PHP example how I am supposed to call this: https://accounts.zoho.com/apiauthtoken/nb/create?SCOPE=ZohoCRM/crmapi&EMAIL_ID=Zoho CRM Username or Email ID&PASSWORD=Your Zoho CRM Password I am guessing I will need to use CURL and I will need to have the variables Username, Password, and Zoho CRM(which i am not sure
Kaizen #56 - Upsert Records #API
Hello everyone! Welcome back to another week of Kaizen. In this post, we will discuss the Upsert Records API. 1. The purpose of upsert records API Using the upsert records API, you can either insert or update records in a module. When you fire an upsert
OAuth POST to generate Access Tokens blocked by CORS
Hey all, As the title suggests, I'm trying to set up an application that makes GET requests to my CRM. But I'm having issues getting past the OAuth token generation. I have no issues navigating to the authentication URL to grab the grant token, but once I've got the token, my application cannot POST to the auth URL to get the Access Token. I get this error: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.
ExtensionPointers - JS SDK Series #2: Fetching the related records of a Zoho CRM module from a widget
Each business requires a mutual integration between its individual components in order to operate efficiently.Zoho CRM is a complete enterprise setup, with all its modules mutually linked with each other to keep your data up to date. The Related List
Notification API patch request is successful but doesn't update anything
Hi, I'm using the Notification API to be notified when an opportunity (which is called ether a Potential or a Deal in your API it seems) is created or edited. The creation worked fine but since a notification channel expires after a maximum of one day
About PHP SDK client application registration
I use the PHP SDK. However, I am in trouble because the procedure on the site and the actual page are different. When I visit accounts.zoho.com/developerconsole, I'm redirected to https://api-console.zoho.com/. The redirected page is different from the
Upsert API call is updating unexpected Zoho Contact
We are seeing an issue using the Upsert API endpoint where the requested duplicate_check_fields provided appears to occasionally fail and upserts an unexpected entity. Observations: The API endpoint we are using to update data: `https://www.zohoapis.com/crm/v2/contacts/upsert` 1st Sent request ``` { data: [ { "Email": "example@example.com", "First_Name": "Timothy", "Custom_Id": "544", "Another_Custom_Id": "6840" } ], duplicate_check_fields:
how do I create a widget with the HTML / CSS / JS files I made?
how do I create a widget with the HTML / CSS / JS files I made? I can only create if it is external hosting (Ex: Codepen), but I wanted to use the hosting of the zoho itself. I already sent the .zip file and pointed to the path of the index.html, but
"code": "AUTHENTICATION_FAILURE"
I have created api and auth token, and directly posted using postman, but it showing an error, Please send me the solution for that
Zoho CRM custom function API request syntax - calling from Google Apps Script with custom arguments in Body/Payload
Putting this down here as it's taken me ages to figure out - hopefully can save time for somebody else. Objective: call custom Zoho CRM function from Google Apps script, with custom arguments in the Body/Payload Sample Google Apps script code function
How to search records by date in the JS SDK?
Does anyone know if it's possible to search records within a date range via the JS SDK? the COQL query I have working is (changed for legibility) : SELECT Name FROM Leads where (Created_Time >= fromDateTime and Created_Time <= toDateTime and Resource = resourceID) I'd like to be able to execute this same query via the JS SDK but this doesn't work: ZOHO.CRM.API.searchRecord({Entity:"Leads",Type:"criteria",Query:"((Created_Time >= fromDateTime and Created_Time <= toDateTime and Resource = resourceID))"})
ZohoOAuthException when trying to fetch access token with Java SDK
Hello, I first tried the french documentation which was obsolete. I had to go to the english documentation to have up-to-date information. Or so I thought. I had to modify the given code. Instead of ZohoOAuthClient client = ZohoOAuthClient.getInstance();
client.generateAccessToken("generated_grant_token"); I had to write : ZohoOAuthParams zcrmAuth = new ZohoOAuthParams(); zcrmAuth.setClientId("(replacing for posting"); zcrmAuth.setClientSecret("(replacing for posting)"); zcrmAuth.setRedirectURL("https:
Update Layout field in accounts using bulk write API not working
Hi, I am using bulk write API to upset accounts in CRM and it is working fine except for one thing: When I map the Layout field to a Layout field in the csv that contains the id of the layout I want to set for the accounts it is not updating/setting the layout in the accounts. I have also tried to set the default layout for the user that creates the job with the one I want to set and it doesn't get set on new accounts. How can I do it? I have searched for information but the only information I have
configuration.properties not found
Hello guys i got a problem when im trying to use the Api. 0Current user should either be set in ZCRMRestClient or in configuration.properties fileUnknown but configuration.properties exists and contain the currentUserEmail apiBaseUrl=www.zohoapis.com apiVersion=v2 sandbox=false applicationLogFilePath=/***/*** currentUserEmail=***@***.com
Can I pass data to widget which open from botton click?
Hi I create a button in contacts view . The button will popup a widget. I want pass the contacts ID which I select to widget. Please show me how can I do? Kenny
searchRecords api method
Trying to understand why the following is happening. I have created 3 account in the CRM with the following account names Wonder Company Test Sample Company When I make the following call, I get all companies returned as the result https://crm.zoho.com/crm/private/xml/Accounts/searchRecords?authtoken={My Auth Key}&scope=crmapi&criteria=(Account Name:a) I would of expected none to be returned, it in theory it is getting accounts that "Start With a"
Do I need a new license as a developer?
Hi Im working on the CRM for the client. The client has a license. Do I also need a license if Im working in the CRM? Ill only be doing about 5 hours per week on the project. If I use the client's login details, will it block her out of the CRM while Im logged in? Thanks
ZOHO CRM API and Zillow API
Here is what I am trying to do. I was wondering if there was a way to use a zillow api or any other real estate related API to populate information into a ZOHO CRM lead. I wanted to be able to grab information from Zillow like the Z estimate and beds, bath, square footage, school districts, etc from zillow. I wanted to do it in a way that I just clicked a button and it auto populated into my Lead fields. Right now I can go to my real quest account and export the field and then input them into
How to remove the human interaction for Zoho CRM OAUTH
Presently, it appears that we can only obtain a grant token by having a human interact with their browser i.e. 1. my service starts up without a grant token so it then displays a URL that a human can go to 2. the human goes the browser, consents to the data being shared and then submits 3. Zoho then sends the grant token to my services's redirect url I would prefer to eliminate the human interaction as services and their hosts are often restarted. Is there a way to have my service directly obtain
Kaizen #52 - Currencies #API
Hello everyone! Welcome back to another post in the Kaizen series! This week, we will discuss Multi-currency in Zoho CRM. What will you learn from this post? Multi-currency in Zoho CRM Managing multiple currencies via Zoho CRM API Enabling multi-currency for your organization Retrieve currency details Add new currencies to your organization Update currencies Multi-currency and Inventory modules in Zoho CRM 1. Multi-currency in Zoho CRM Multi-currency support in Zoho CRM lets you carry out business
Zoho Creator and Document Server
So I am designing a website through Zoho Creator and using Pages. There are documents that are connected to the CRM and others that do not. Is there anyway to fetch the PDF of a Purchase Order or Invoice directly using APIs? Otherwise, we would have to use the Documents Portal inside Zoho CRM. How do we restrict access to Documents based on the Customer Portal (Not Users) and its permissions (assuming we will do the fetch based on a URL given by the Documents Portal inside Zoho CRM)? For our documents
Convert Stage Id to Stage Name
When querying the Stage_History of a record it returns { ... "Stage": "33354123000061234" ... } How do I go about converting that Id into the display value?
Client facing web application for vendors and buyers
Hi all, I'm pretty new to Zoho. I'm working with Zoho CRM API to develop a client facing web application. Vendors can log in and access, modify records (specifically products and sales orders) and buyers can see products and invoices. My idea was to have a Zoho user per client and assign each of them a specific role (vendor, buyer). This way I could set up permissions for them in CRM to have access to the correct data. The part I'm confused about is whether multiple users can be linked to a specific
Kaizen #51 - Handling Users with ZohoCRM API
Hello everyone! Welcome back to yet another post in the Kaizen series. This week, we will discuss the Zoho CRM Users API in detail. Users in Zoho CRM A user is the one who is allowed to access and manage the CRM records. Generally, anyone using CRM is a user. Further you can assign profiles and categorize the users based on their roles and permissions. There are 4 major operations in Users API: 1. Get User(s) Data 2. Add User 3. Update User 4. Delete User Note: 1. The oauth scopes required for all
Should I be using lookup fields in this scenario?
I want our CRM to contain details of all the Vets that we do business with. We need to select a Vet based on what treatments they offer. Certain operations are only available for certain animals. And only certain treatments are available for certain operations. We need to be able to filter Vets that offer a treatment or operation for a given animal. So I think what I want to see is a dropdown which shows all the animals. Then - when selected - another dropdown appears which displays all the operations
zcrmsdk.CLException.ZCRMException: <exception str() failed> when trying to get fields on Contacts
Hello, I can’t figure out why this code does not work. The first five lines work fine and the print dir of the contacts_instance prints the last call but it fails on the last call. Code: crmsdk.ZCRMRestClient.initialize(configuration_dictionary) contacts_instance = crmsdk.ZCRMModule.get_instance('Contacts') print(dir(contacts_instance)) contacts = contacts_instance.get_records().response_json["data"] print(len(contacts)) contact_fields = contacts_instance.get_all_fields() Result: /Users/ddow/venv37/bin/python
Kaizen #50 - Deals Metadata #API
Hello everyone! Welcome back to another post in the Kaizen series! This week, we will discuss the Metadata API for the Deals module and explain every key in the response. What are metadata? Metadata are the additional information about a record's data or a module. For instance, the metadata of the Deals module comprises details like related list properties, whether the module is visible to the current user, whether the module can be accessed via API, and so on. You can fetch the metadata of a module
I can't access the ZOHO creator form in ZOHO CRM.
Hi Guys, I Build App in Zoho Creator as the name of "Add Account" and written Delegu code for saving the Account/Contacts records into ZOHO CRM, it's working fine smoothly saving the records into ZOHO CRM. I am facing a problem that when I tried to access the "Add Account" App in Zoho CRM through (Setting --> Web tabs--> Links) I am getting an error message of "Sign in to your Zoho account to view this Form." along with a sign-in button, I have clicked many times to get into form but no luck, but
Accessing MassEmail or Reports from API
Hello, I am currently trying to retrieve data from Zoho CRM programmatically (via API), regarding mass emails (bouncing rate, opened mails, etc...) for monitoring. However, so far, I have found no way to retrieve such data, (even indirectly via a Report, for example): - Listing all modules via API, I do not see any "email" related module, and "Reports" is marked as not `is_api_supported` - However, if I list related modules for "Contacts", I do find an "Emails" module - Furthermore, when I try to
How to integrate FullContact API with Zoho CRM API?
Essentially, FullContact is a lookup for more information on a person when certain parameters are passed (for example email, name, company). On GET request, the FullContact API should return XML or JSON of whatever available public information there is on a person. What I want to do is a POST onto CRM Leads of that data. I've been looking and trying to use Webhooks from Zoho but have not been able to do a successful POST onto my Leads module. (Probably an issue with the XML formatting) FullContact
How To Get Deals Per Contact?
Is there an extremely efficient way to get a list of Contacts with a Created_Time in a date range, and then get a count of their completed deals? I was trying to do a join in COQL but the docs are pretty hard to follow on this. The next thing we need to know is not only how many deals we did for all the contacts in that date range, but what the sales amount was. We're trying to update a third-party business intelligence dashboard with these statistics. (And yes, we're going to use a cache table between
How to use pagination when getting records through a COQL Query in Zoho CRM REST API V2?
When I send a COQL query POST request to this endpoint https://www.zohoapis.com/crm/v2/coql?page=2&per_page=10 with this body { "select_query" : "select Last_Name, First_Name, Modified_Time from Contacts where Modified_Time >= '2020-01-10T00:00:00-05:00'", } I get 75 results. How do I properly paginate results when getting records through a COQL Query? According to this link pagination in API V2 should be possible: page: To get the list of records from the respective pages. Default value is
Extract the Lead ID that was converted into a potentials via API
When a Lead is converted into a Potential, I would expect the Lead ID is stored within the potentials table. However, this fields is not currently not available within the API. Is there a way to access this information via the API? Thanks.
Update to Connections - Deploy from Sandbox to Production
Hello everyone! Connecting any third party application through a function is done mostly through Connections. However, while deploying the functions from Sandbox to Production, we do not include these connections. We are happy to inform you that moving forward, you can deploy the functions along with their connections from Sandbox to Production. This enhancement will immensely benefit the customers who rely on writing functions first in Sandbox, testing them (UAT) there, and deploying them to Production.
Attach Files or Photos to records using Zoho CRM Developer API
Attaching files to records directly from your desktop to a record in your CRM is easy. But then, what happens if you want to attach files from an external service? Let's say - you have connected your CRM account with an Invoicing Application using our Developer API. You want to attach all invoices to corresponding records in your CRM account. Our Developer API now has methods that let you do this. uploadFile Method The uploadFile method lets you attach files to records. When files are uploaded,
Next Page