[API]Import JSON / CSV to CRM Contacts
Hello, I successfully import a .JSON file into Analytics module of Zoho and we are very happy with it. Same thing inside Campaigns. Now we want to periodically synchronize our .JSON file inside the CRM "Contacts" module, then Analytics and Campaigns. Is this possible ? How can we do that ? I read a lot of API documentation but I can't find anything clearly explained. Thanks in advance for your support.
Associating an account as Parent Account to an existing account.
I added an account and want to add a parent account to it. I tried to set Parent_Account field. Its a LookUp type of field. Below is my code. "record.SetProperty("Parent_Account", serviceAccnt.Parent_Account);".. where serviceAccnt.Parent_Account is the same object that we get from Parent Account inside the account. This is not working. I can set string and int type of field but not LookUp type of field. Is there any other way to set a "LookUp" type of field.?? OR Please tell how to add a Member
Fetch Accounts by Parent Account
I am using Zoho C# SDK. I want to fetch all child accounts of a Parent Account. I am using this code snippet to get all child accounts- "BulkAPIResponse<ZCRMRecord> response = module.SearchByCriteria("((Parent_Account:equals:" + accountName + ")", methodsParams);" Its giving Error - "ZCRMSDK.CRM.Library.CRMException.ZCRMException: 'invalid query formed' ". Its NOT working for "Parent_Account". Please give solution to fetch all child Acounts by Parent Acount. Thanks
Problem with fetching Tasks module
Hello, I am working as a developer for Leadfeeder. We noticed a strange behavior for one of our customers. When we run synchronization, we fetch information about the Zoho configuration. One of the requests is GET with the following endpoint: https://www.zohoapis.com/crm/v2/settings/fields?module=Tasks The problem is that we get the following error: BODY: {"code":"INVALID_MODULE","details":{},"message":"the module name given seems to be invalid","status":"error"} I've checked other support topics,
API Update : New Error Code in CRM APIs to Handle Data Storage Limits
Hello everyone! As you are aware, we have introduced edition-wise Data Storage limits for Zoho CRM. Please refer to this announcement on the same. In continuation with this update, we are introducing the error code MAX_RECORDS_LIMIT_REACHED with the status code 400, in our APIs. After this update goes live, when you insert records via the API, and you exceed the data storage limit for your edition, you will face this error. Here is how the error response looks like for the Standard edition and lower.
API v2.0 Migration Update: Copy Customization, Extensions, and Functions
Hello everyone! As you all know, we deprecated the v1.0 APIs last year, and they will reach their end-of-life (EOL) on December 31, 2019. Please refer to this announcement for more details. We have also sent reminder emails to the primary users of all organizations that still use the v1 APIs, urging them to migrate to v2.0 at the earliest. Apart from reminder emails, we have also put up in-product banners, alerting the users of existing v1 code. For more details on the next essential steps, refer
C# SDK Auth fails when using self client grant token
I generate a self-client grant token for ZohoCRM.modules.ALL an use it in the attached code example. It runs but crashes with a 400 error code. When I attached a proxy to view the traffic a call is being made to https://accounts.zoho.com/oauth/user/info which is returning a 400 error code. I am using the v2.1.2 Nuget package for ZCRMSDK, but when I looked at the code posted on github, I noticed a very similar issue, https://github.com/zoho/zcrm-csharp-sdk/blob/master/ZohoCRM/OAuth/Client/ZohoOAuthClient.cs#L87,
List of emails from modules using crm REST API
Hi, I would like to know if there is currently a way to export emails informations from Contacts or accounts (and generally from a supported module) in a similar fashion than notes and attachments. https://www.zohoapis.com/crm/v2/Accounts/XXXXXXXXXXXXX/Attachments https://www.zohoapis.com/crm/v2/Accounts/XXXXXXXXXXXXX/Notes When I try the following I get an empty list. https://www.zohoapis.com/crm/v2/Accounts/XXXXXXXXXXXXX/Emails The response { "email_related_list": [] } Cheers, Marc
Add encryption function to module Formula field
Sometimes we want to use a field value in a url or form and not show its actual value to the user. For example: https://myzohoform.myzohoorganization.com/?&subscriber=joeblow@me.com&provider=suzie@experts.com What if I dont want to expose "suzie@experts.com"? I dont want people contacting her or sending her spam. So I have to encrypt it. Zoho lets me do that with Base64 encoding/decoding and MD5 one-way encryption, but I have to mess with that in functions. Why not offer those as options in a Formula
C# MVC: UriFormatException: Invalid URI: The format of the URI could not be determined
Hi there, im getting the error "UriFormatException: Invalid URI: The format of the URI could not be determined". This is happening on line 55 of code below, which is "APIResponse response = restClient.GetOrganizationDetails();" This is my code: Can anyone see what might be going wrong? I've been trying to find what the URI is that its breaking on but can't find any mention of it in the stack trace. Much appreciated, Sarah.
Custom ZOHO modules access
How can I access (read, insert data) non-standard (custom) modules? I try to insert data to custom module and get an error response: {"code":"INVALID_MODULE","details":{},"message":"the module name given seems to be invalid","status":"error"} I guess it's because I don't know how to set the scope to acces the module. Module, which I want to acces is called CustomModule2, but when I try to set is in the scope on generating a grant token I get an error When I set scope as ZohoCRM.modules.ALL or ZohoCRM.modules.Custom.ALL
Receiving 500 Server Error when fetching certain deals
Hi Guys, We are encountering strange behaviour with the Zoho SDK. Everything has been working so far but now I just created a new Deal to test our code with and we are now encountering a 500 server error when attempting to fetch that Deal. (simple getRecord) We have two applications (deals) that are pretty much the same. One works and returns the ZCRMRecord while the other returns a 500 Internal Server Error. The first application that is working is 4111341000006299048 The second application that
Setting a discount to the sales order using the API.
I have encountered a problem while implementing Sales Order creation via the API. When I try to set the discount field for a Sales Order record and declare the overall discount - it is not applied to the record: http://prntscr.com/qn1md0. In the v1 API the "Discount" and "Adjustment" fields were set the same way: ... <FL val="Adjustment">123</FL> <FL val="Discount">123</FL> ... Now when I try to do a simmilar thing in the v2 API, it no longer works: $record = ZCRMRestClient::getInstance()->getRecordInstance("Sales_Orders",
Introducing Serverless Functions!!
Serverless architecture, also known as "Function-as-a-service"(Faas), provides a platform for developers to write functions to integrate the CRM and any third-party application. These codes, written in Deluge, can be triggered from any other third party services or it can be triggered directly from any web or mobile app. Most applications require a server that lets them host their applications, parsing, sharing and computing data. However, having to set up a server just for the sake of providing
fetching data from two different zoho crm account using one client id and one access token
Hi all, I am facing an issue while getting data from https://crm.zoho.in/ . I am using the clientid and client secret, generated for zoho crm account assigned to amritatest**@gmail.com. The client ID is 1000.0JLDYGYRZMS9CXU7F3H8ZX839P****. Using our Application(.Net supported) we hit the https://accounts.zoho.in/oauth/v2/token url and generated access token then using that we fetched the correct data. After one hour I tried to fetch data again using that access token (generated for amritatest**@gmail.com)
What can trigger a function
I know that that (1) Forms or (2) Field changes can trigger Workflows I know that Workflows can trigger Functions What else can directly trigger Workflows? API? Webhook? Button? Some other thing? What else can directly trigger Functions? API? Webhook? Button? Some other thing?
C# SearchByCriteria with datetime
Hi. I try to create query using CreatedTime and ModifiedTime with operator "greater than or equal to" on account module. Can You help Me ? Module is "Account" or "contact". ZCRMSDK_CRUD.ZCRMModule ModuleSel = ZCRMSDK_CRUD.ZCRMModule.GetInstance(module); string crit = "((CreatedTime>=2019-01-01T00:00:00) or (ModifiedTime>=2019-01-01T00:00:00))"; ZCRMSDK_RESPONSE.BulkAPIResponse<ZCRMSDK_CRUD.ZCRMRecord> response = ModuleSel.SearchByCriteria(crit); Have you got example searching by criteria, using date
Zoho Phone Bridge for Asterisk 13 having issues
We deployed phone bridge from link posted in other topic https://help.zoho.com/portal/community/topic/zoho-phone-bridge-asterisk-13 app starts just fine, no errors, it's possible to initiate calls however widget always stays in connecting state Attaching relevant log files Please assist with troubleshooting/debug Thanks!
data coming from different zoho crm accounts using one client id
Hi all, I am facing an issue while getting data from https://crm.zoho.in/ . I am using the clientid and client secret, generated for zoho crm account assigned to amritatest**@gmail.com. The client ID is 1000.0JLDYGYRZMS9CXU7F3H8ZX839P****. Using our Application(.Net supported) we hit the https://accounts.zoho.in/oauth/v2/token url and generated access token then using that we fetched the correct data. After one hour I tried to fetch data again using that access token (generated for amritatest**@gmail.com)
Sorting Deals by id ascending does not work, descending does
I'm dealing with a confounding issue retrieving Deals via the endpoint https://www.zohoapis.com/crm/v2/Deals?sort_order=asc&sort_by=id&page=1&per_page=200 Returns a list of ids not sorted by id at all. https://www.zohoapis.com/crm/v2/Deals?sort_order=desc&sort_by=id&page=1&per_page=200 Returns a list of ids sorted by id descending. Has anyone else seen this? I'm not seeing the same issue with other modules.
Kaizen #6 - Environments and Domains in Zoho CRM [Part2/2]
Hello Everyone! Welcome to another week of Kaizen. This post is a continuation of Kaizen #5 - Environments and Domains in Zoho CRM [Part1/2]. What you will learn from this post? If you want to integrate your web application with Zoho CRM, this post will help you understand how to handle multiple domains for your application. 1. Handling multiple domains for web-based clients 1a. Web-Based Clients As we all know, in a web-based client, your application is used by multiple users from different domains
How can we specify currency when inserting a record in Invoices module?
We are using upsert record API to add a record in the Invoices module using the V2 API. But the record is added as the USD currency and not as GBP. The Home Currency is setup as GBP. Documentation dosen't specify any attribute to use as currency. Is is possible to use currency code in the API?
Update function from v1 to v2 if function install through the Plug-in
Hi, I wan to update the one of the Function added under Developer Space > Functions as a deprecation warning is getting displayed for the same. But I am seeing a message like "Sorry! You can not edit or delete this function as it has been installed through the Plug-in". Please guide me how can I update this Function from V1 to V2. Thanks.
Zoho Technology Partner
Hello. I am a developer of an application (Google Spreadsheets add-on) connecting Zoho CRM to the client's spreadsheet, and I am trying to become a Zoho Technology Partner. I've twice filled a partner application - about 3 weeks ago and a week ago, however, I have not received any response. Can somebody help me to contact a real person in Zoho who is responsible for the partner program? Thank you.
ZOHO API USING CURL IN PHP NOT RESPONSE
HI, I am try to insert record in lead by using zoho API with CURL functionality but always i am getting "false" response. When i use this same code to my another web server then record will added successfully in my zoho lead. Please help me. REGARDS, Uttareshwar
Migrating V1 APIs configured in Webhook
When you have configured Zoho CRM's V1 APIs—insertRecords and updateRecords (to handle data transfer from one CRM organization to another) as webhook in Automation Rules, you will face difficulties during V2 migration (since V1 APIs use auth token, and V2 APIs use OAuth). You can handle this in two ways: Custom function Zoho Flow 1. Custom Function Users with Enterprise, Zoho One, CRM Plus, and Ultimate editions can opt for this solution. Create a custom function and convert it into a REST API function.
Failed to connect to MySQL: (1045) Access denied for user 'root'@'localhost' (using password: NO)
can you help me here i have site and i am using one form to take customer data and send to the zoho via API v1 but now i want to upgrade to the API v2 so i followed by php SDK and i follow this url to create user https://www.zoho.com/crm/developer/docs/php-sdk/organization-sample.html?src=create_user and i used this below code <?php include 'zoho-sdk/vendor/autoload.php'; use zcrmsdk\crm\setup\restclient\ZCRMRestClient; use zcrmsdk\crm\setup\users\ZCRMProfile; use zcrmsdk\crm\setup\users\ZCRMRole;
CAN AN ACCOUNT BE ASSOCIATED WITH A CUSTOM RELATED RECORD
I have a custom module which i want to link it with Accounts or Contacts using API. However, dev docs stated that only some module relations are supported by update record API: Campaigns - to - Leads, Contacts Products - to - Leads, Accounts, Contacts, Potentials, Price Books Is there anyway i can achieve this using supplied APIs? Please help.
V2 Oauth issues
I created a client id months ago in preparation for the deprecation. The same code yields { "error": "invalid_code" } I'm guessing the refresh token has expired. I plan to use this api on the server side. Why do I need to access the browser to keep my code working? On top of this it doesn't work after generating self-client code. Just does not work.. What is going on here? I've tried in postman and the browser. invalid_code is misleading as it doesn't tell me what the issue really is. Did I
Kaizen #11 - The $Properties in Zoho CRM #API
Hello everyone! Welcome back to yet another post in the Kaizen series! This week, we will discuss the $Properties in Zoho CRM . What will you learn from this post? What are $properties? $properties common to all the modules Module-specific $properties 1. What are the $properties? The $properties represent the derived properties of a record in Zoho CRM. They are not available as fields in Zoho CRM. For instance, $converted —It represents the state of a lead or a quote. If you convert a lead or
Insert lead in zoho using api v2
I'm using the c# sdk in order to insert a "lead" in Zoho. So far I've been able to generate grant, refresh and access token. My problem is that the c# sdk documentation stop there. How can I insert a lead from the v2 API? This is what I have so far : //Generate from refresh token ZCRMRestClient.Initialize(); ZohoOAuthClient client = ZohoOAuthClient.GetInstance(); string refreshToken = "1000.xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"; string userMailId = "x.x@x.com";
Update function from v1 to v2 if function install through the Plug-in
I wan to update the one of the Function added under Developer Space > Functions as a deprecation warning is getting displayed for the same. But I am seeing a message like "Sorry! You can not edit or delete this function as it has been installed through the Plug-in". Function name dre, there are 2 of it actually Thanks.
ZohoOAuthException Caused by:'Exception while fetching access token from refresh token
Hi ! We are implementing ZohoCRM into our Laravel (5.7) application We are using ZohoCRM sdk and we are using database for persistence but when we use Sdk for more then 5 times it gave us error (which i included as screen shot) Because of lack of PHP SDK support and difficult to find any solution , there are no way or solution that can help us Below is the snippet's which we are using in order to make this issue fixed ZCRMRestClient::initialize(); $oAuthClient = ZohoOAuth::getClientInstance(); $grantToken
Zoho CRM APi v2 not triggering workflows
I have noticed that the new implementation is not triggering workflows as the v1 API was. I am using the PHP SDK and the code: $trigger=array("workflow","approval","blueprint"); $responseIns = $record->create($trigger) but, while the record is created, the workflow does not run. Having looked at the forums it appears a few people had similar problems, but I'm not sure what the resolution was.
How to add lookup fields and Multiselect field with PHP API
Hi I'm developing a integration to send leads to Zoho CRM through the API. I'm having problems with the lookup and multiselect fields. I'm using this code to set the multiselect value: $specialFormat = json_encode(array($movingPriority)); $record->setFieldValue("Prioridad_de_Mudanza",$specialFormat); But I'm getting the following error: Details:{"expected_data_type":"jsonarray","api_name":"Prioridad_de_Mudanza"} And regarding the lookup fields, we are using the following code: $inmuebleInfo = array();
SearchByCriteria in V2 API not returning all records
We have used your SDK to convert from V1 to V2 API calls. We are testing the conversion and have noticed that SearchByCriteria does NOT return all expected records. Here are a couple examples: This search only returns 4 records while it should return 13: GET https://www.zohoapis.com/crm/v2/Sales_Orders/search?criteria=((Subject:starts_with:Wendy))&page=1&per_page=200 This search returns 0 records and should return 1 by the Sales_Order_NO GET https://www.zohoapis.com/crm/v2/Sales_Orders/search?criteria=((Sales_Order_No:starts_with:SO106883))&page=1&per_page=200
Insert picklistvalue from API
Hi! Are there any functions on the rest api to insert picklistvalues into fields? There are a method AddPicklistValue() on the ZCRMField class but I am not sure how to use it. I am using C# SDK by the way. // Regards Tomas
How can I get data related using api version 2?
I need to obtain the related data of an account to get their contacts, I am using the node js sdk but there is no documentation of that part, I am using version 2 of the api.
Get record api V1 vs V2 not same data
Hi. On Api V1, function getRecordById get all fields of form data and some relational data: }, { "val": "Account Name", "content": "RESTAURANT DOPA BCN, S.L." }, { "val": "PARENTACCOUNTID", "content": "1945000004723108" }, { "val": "Parent Account", "content": "GRUPO EL PINTXO" }, { "val": "Account Type", "content": "Cliente de Distribuidor" }, In a V2 API this param not found and I need this to work. How retrieve this relation (Parent and Child relations) Thanks.
Kaizen #10 - Search Records API and Query API
Hello everyone! Welcome back to this week's Kaizen post! In this post, we will discuss the Query API and the Search Records API, and when you should use them. Query API The Query API allows you to query the records using the CRM Object Query Language(COQL). COQL is based on the SQL syntax and uses the SELECT statement in the query to fetch records. When should you use the Query API? When you want to use DB comparators such as =, >, <, >=, <=, is null, is not null, between, not in, like, and not like
Next Page