ZOHO CRM Integration Error

Status
Not open for further replies.

tech2go

Bronze Partner
Joined
Aug 19, 2013
Messages
2
Reaction score
0
Hi I'm getting this error

Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason= - Content={"code":"INVALID_QUERY","details":{"reason":"the field is not available for search","api_name":"Home_Phone"},"message":"invalid query formed","status":"error"}


Started scenario with empty id
Started Auth
Request text: https://accounts.zoho.com/oauth/v2/token
Request form value refresh_token set to 1000.695af5d5b0d8aea746d213e9fe212293.37e8039ea752bc48d944424d446e19a0
Request form value grant_type set to refresh_token
Request form value client_id set to 1000.KRUDIAYB74U695354V2UA0VVQHQTQH
Request form value client_secret set to 5fa969320af4b36dc166036d1b40f2996adb5400dd
Response text: {"access_token":"1000.3dceb4458b40fc1cf102b22682fdb8b4.20bcf8b22455aa304581341f4253f72f","expires_in_sec":3600,"api_domain":"https://www.zohoapis.com","token_type":"Bearer","expires_in":3600000}
Response finished
Variable AccessToken set to 1000.3dceb4458b40fc1cf102b22682fdb8b4.20bcf8b22455aa304581341f4253f72f
Variable ApiDomain set to https://www.zohoapis.com
Finished Auth
Request text: https://www.zohoapis.com/crm/v2/Contacts/search?criteria=((Phone:equals:551234) or (Mobile:equals:551234) or (Home_Phone:equals:551234) or (Other_Phone:equals:551234) or (Fax:equals:551234))&fields=Account_Name,id,First_Name,Last_Name,Phone,Mobile,Home_Phone,Asst_Phone,Other_Phone,Email,Fax
System.Exception: Server returned a non successful status code - HTTPStatusCode=BadRequest - Reason= - Content={"code":"INVALID_QUERY","details":{"reason":"the field is not available for search","api_name":"Home_Phone"},"message":"invalid query formed","status":"error"}

at CrmIntegration.ScenarioProcessorBase.ProcessRequest(ScenarioRequest request, IValueManager customManager, HttpClient client, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.ProcessScenario(ProtocolScenario scenario, IValueManager customManager, CancellationToken token)
at CrmIntegration.ScenarioProcessorBase.Execute(ProtocolScenario scenario, CancellationToken token)
at CrmIntegration.CrmProcessor.GetContactInfoFromCrm(String contactNumber, String destinationEmail, Boolean createIfNotFound, CancellationToken token)

Found a solution in previous thread -----

"Regarding the error you get, the problem is that the field "Home_Phone" is hidden for entity Contacts. You need to make it visible in Zoho, and the issue should be fixed."

But don't how to do it in zoho, please help. Thanks
 
Status
Not open for further replies.

Members Online Now

Forum statistics

Threads
111,842
Messages
589,320
Members
164,677
Latest member
skander