- 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
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