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,
Self Client, Zoho Projects, and User-level authentication
Hey everyone, I'm new to this style of development, and have some questions. I'm looking to develop a C# application that hooks into a company's Zoho Projects to read/write/do whatever. I have a Self Client setup, and the OAuth2 working just fine. What I'm looking to achieve is require the users of the application to authenticate or login using their Zoho account against the company's project permissions. I may be poorly wording it, so for example. - I launch the application, and generate the application's
Kaizen #49 - Share Records #API
Hello Everyone! Welcome back to another week of Kaizen! In this post, we will discuss Share Records via Zoho CRM API. Record-level sharing In Zoho CRM, users can share individual records from any module with other users in the organization. You can share records using share records API. Pre-requisite Users with the Administrator profile can always share records with other users in the organization. For users with other profiles, the sharing permission must be enabled. To enable share permission,
The New Error Codes in CRM API - RECORD_LOCKED and NOT_APPROVED
Hello everyone! As you all are aware, Zoho CRM offers an option to upload images for a record. When a user uploads images, Zia vision checks if the record meets any Zia vision configuration rules' criteria, and validates them. Click here to know more about Zia vision. As a part of our upcoming enhancement, we are going to support the image processing state for the records. We have added two new error codes related to the same in the Zoho CRM APIs. 1. RECORD_LOCKED Zia image processing state In our
Setting a custom lookup field with PHP SDK
I have a custom module "investments" that has a lookup field to the contacts module. If I get an instance of ZCRMRecord with the correct entity id etc can I just set this relationship using something like $contact value is returned from a call to searchRecordsByEmail $investment->setFieldValue("Investor", $contact); However this throws an invalid data error. Couldnt find any examples of the correct way to do this.
AttributeError: 'AttributeError' object has no attribute 'message'
Hello. I'm trying to read all records of any given module (In this case is 'Contacts'). I've successfully got token and authenticated. I've used the example i've found on documentation. Just ported to Python 3.x. My environment is Python 3.7.5 (also tried with 3.5.7), latest zcrm-python-sdk. Traceback (most recent call last): File "/home/thiras/.local/share/virtualenvs/wtcrm2zoho-KRDZy6H-/lib/python3.7/site-packages/zcrmsdk/Request.py", line 65, in get_bulk_api_response return BulkAPIResponse(response,response.status_code,self.url,self.request_api_key,self.request_method)
C# api - Products GetRecord loop Timeout?
Hi Guyz, I am trying to get products' details of a product list. I get the Deals list, then looping through the deals ang get deal related product record. But my loop freezes on 6th request and gives a Request Timeout Exception after awhile. But its weird It freezes on 6th request every time I tried. Below is my code; ZCRMModule moduleIns = ZCRMModule.GetInstance("Deals"); BulkAPIResponse<ZCRMRecord> response = moduleIns.GetRecords(CustomViewId) List<ZCRMRecord> DealRecords = response.BulkData;
API is not working
Hello, I'm working on a requirement to fetch data from Zoho and load into MySQL. Earlier the get_records() , get_instances() for individual modules were working but now it's giving me error as below, even though I refresh the token and reconnect. Please check on priority and assist me on the same : Traceback (most recent call last): File "C:\Users\Amitkumarsahu\AppData\Local\Programs\Python\Python37-32\lib\site-packages\zcrmsdk\OAuthClient.py", line 139, in get_access_token return oAuthTokens.get_access_token()
How to get User id from crm
How can i get the user id from zoho crm and assigned a task to user.
Connect to API without access token
Hi Dev, I want to insert lead data into my CRM. My app is simple when the user submits their data and then we just save data into leads in Zoho. Is there any ways to connect to Zoho without oauth2? maybe using secret_key or client_id only. Thanks
Kaizen #48 - Related Lists and Related Records #API
Hello everyone! Welcome back to another post in the Kaizen series. This week, we will discuss everything about Related lists and records. In this post, we will cover the following: What are related lists and related records in Zoho CRM? How to retrieve metadata of related lists? How to fetch the records of a related list? How to add/update records to a related list? How to delete a record from a related list? 1. What are related lists and related records in Zoho CRM? A record usually contains extra
LOGIN REST api for Zoho CRM
I'm developing a mobile app which is using Zoho CRM apis i.e fetching list of CRM users, records and insert record. Is there any Zoho CRM api for user login? I've generated access token from web portal able to get response of insert/get records apis. Before accessing all these records, to validate users credentials(email id and password), which api should be used? Note: I have checked generating access token api which inputs password which will be generated from web portal. Account password can't
Finding a Zoho CRM developer
Hi, Im a php developer. I know a little about Zoho CRM and the functionality within it. I have a client who wants a very basic CRM, however theres a custom form needed and I just cant figure out how to do it. Ive tried contact a few people on UpWork, but they come back with over-engineered expensive solutions with features that are just needed! They all want to build it outside of Zoho CRM! Is there a developer here who can interface with Zoho's API and want to discuss the project? As I say, its
Can access zoho data from moodle ?
Is it possible to access zoho crm's data from moodle? If yes then what API available for this?? And what steps do i need to take to access zoho user's data from moodle.
Workflow Trigger
If I mass update a date/time field in the CRM and trigger a workflow based on that time, will updaterecord() trigger further workflows if I pass "trigger"{["workflow]} in the options map? filename = "" + fname + " " + lname + ""; rez = zoho.workdrive.createFolder(filename,"dtosffcc9acdc23d644558d260cbe1a37aca5","attach_workdrive"); data = rez.get("data"); conWD = data.get("id"); attributes = data.get("attributes"); conWDurl = attributes.get("download_url"); update = Map(); update.put("zohoworkdriveforcrm__Workdrive_Folder_ID",conWD);
Update to Search Records for New Sign-ups from September 15, 2020
Hi everyone! This post is to inform all the developers who work with functions (DRE) of an update to Search Records. We all know the Search Records API filters records based on certain criteria and gives the response. You can make the search records request from one of the following places: Functions (DRE calls) API calls When you search for records through a function (with a single criterion), your criterion can contain one of the comparators such as not_equal, greater_equal, greater_than, less_equal,
I catch ZohoOAuthException
Hi! I have a problem with my code: require 'vendor/autoload.php'; ZCRMRestClient::initialize(); try { $oAuthClient = ZohoOAuth::getClientInstance(); $grantToken = '1000.297767e7a02214c5e4432dcc1906f615.c1198106e59644b6539e110f684f4a27'; $oAuthTokens = $oAuthClient->generateAccessToken($grantToken); } catch (ZohoOAuthException $e) { echo $e; } result: Notice: Undefined offset: 1 in D:\phpProjects\zoho_form\vendor\zohocrm\php-sdk\src\com\zoho\oauth\client\ZohoOAuthClient.php on line 185 Warning:
Conditional Show/Hide Fields on Webform
Is there a way to make the display of fields on a Webform conditional upon the value of another field?
Enable Notification using ZOHO CRM Notification Api , is there any wrong thing i did?please Replay ASAP
Url https://www.zohoapis.com/crm/v2/actions/watch Header scope:ZohoCRM.notifications.ALL Authorization: Zoho-oauthtoken 1000.f5971d88a8a89d5ee73242850ebf5ac7.f601a579fdb39f9294363a9388543444 Content-Type:application/json sample Input { "watch": [ { "channel_id": "1003330068002", "events": [ "Leads.all", "Deals.all" ], "channel_expiry": "2019-06-06T16:30:00+05:30", "token": "T1000000068002",
Cannot update Contact Field values via API after renaming them
Hello. I think we have recently stumbled upon an issue/bug from your end. Our team is using the Upsert Records endpoint for Contacts in order to insert or update them. We are using a custom layout. After we rename an already created field (Single line) of the layout we will be unable to update the value of it for every contact through the API call. We can only update it if we use the Old name (the one we had set before renaming it, which does not make sense) For example if we created a field and
Extension pointers #10: Define and raise a signal to receive timely notifications in Zoho CRM
Customer relationship management is a significant factor involved in the success of a business. When interaction with customers at all touch points is properly targeted, customers are satisfied and business flourishes. This makes it a necessity to stay
Related List - linking Contacts to a new module's related list.
Hi all, and thank you for any help you can provide. I have created a new module. I would like to create a related list in that new module that links the contacts to into the new module's related list. (I need the new module to have the Contacts like the Account module currently does) Thank you for your help, it would be greatly appreciated.
Kaizen #45 - Handling Attachments API in Java and Java SDK (Part 2/2)
Hello everyone! Welcome back to yet another post in the Kaizen series. In our last post, we started our discussion about handling the attachments in Java and Java SDK where we discussed listing the attachments and uploading the attachments to a record in Zoho CRM. This week, we will discuss the other two operations in attachments API. 1. Download an attachment 2. Delete an attachment. 1. Download an Attachment To download a file attached to a record. Request method: GET Request URL: {{api-domain}}/crm/v2/{module_api_name}/{record_id}/Attachments/{attachment_id}
Kaizen #44 - Handling Attachments API in Java and Java SDK (Part 1/2)
Hello everyone! Welcome back to yet another post in the Kaizen series. This week, we will discuss about the attachments API in Java and Java SDK. 1. Introduction to Attachments API Attachments in Zoho CRM are an important aspect of any record as they
Sub-concurrency for Complex APIs
Hello everyone! We all know API calls are metered through credits. Concurrency and sub-concurrency limits are applied based on the CRM edition and the type of request, respectively. Earlier, we applied sub-concurrency to only a few APIs individually, as mentioned in an older post. However, to maintain optimal performance, avoid slowness, and maintain resource availability, we have now grouped the below as complex APIs, and set the sub-concurrency limit to 10 for this group. This sub-concurrency limit
Migration of Zoho CRM APIs and Functions to v2.0 - Updated!
Hello everyone, A year back, we released the CRM API Version 2.0 that provides a lot more than what we have in API v1.0. Along with that, we also announced the deprecation of API v1.0 and its sunset on December 31, 2019. Here is the link to the previous announcement. We would like to remind you to migrate to the latest version of CRM APIs as soon as possible, as the older version will not be available next year onwards. If your code still uses the version 1.0 of the APIs they will stop working from
Next Page