Zoho Integration

[Evolute IT]

Pretty sure this is why its not working:
Exception during call reporting: 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":"Extension Number"},"message":"invalid query formed","status":"error"}

The thing is I have it setup with Extension number and when I look at the profile the extension number is there in Zoho so I am not sure why the field wouldn't be available for search

https://www.3cx.com/community/threads/zoho-crm-jounaling-issue.76432/post-347809

 

[Doberman_techAJ]

https://www.3cx.com/community/threads/zoho-crm-jounaling-issue.76432/post-347809

Okay so i did that an the odd thing is I am getting and INVALID TOKEN yet when I run the test on the integration everything comes back fine

 

[edossantos]

Okay so i did that an the odd thing is I am getting and INVALID TOKEN yet when I run the test on the integration everything comes back fine

Can you show the full error message you're getting? You get this error in the 3cxSystemService.log, but testing from the console works fine?

 

[Doberman_techAJ]

Can you show the full error message you're getting? You get this error in the 3cxSystemService.log, but testing from the console works fine?

This is the error I get in the command prompt:
C:\WINDOWS\system32>curl "https://www.zohoapis.eu/crm/v2/users?type=AllUsers" -X GET -H "Authorization: Zoho-oauthtoken 1000.a77e9006795c1e1cec0251379a06c79f.4b58832ccbb74a6d63a87d91b0f65ba2"
{"code":"INVALID_TOKEN","details":{},"message":"invalid oauth token","status":"error"}


I do not get an error anywhere else other than when i make the call and it gives the invalid query error

 

[edossantos]

The token you're using in that curl command is invalid. Check which token is using 3CX when it performs a valid request.

 

[Doberman_techAJ]

The token you're using in that curl command is invalid. Check which token is using 3CX when it performs a valid request.

Okay Just checked it again in the test and get the same access token and same result in the command prompt

 

[edossantos]

I see that you're sending the request to https://www.zohoapis.eu

Is your account in .eu as well? Or 3CX is using .com?

 

[edossantos]

I see in your initial post that your account is using .com, so you need to adjust the curl command to send the request to .com as well.

 

[Doberman_techAJ]

I see that you're sending the request to https://www.zohoapis.eu

Is your account in .eu as well? Or 3CX is using .com?

Okay fixed that and now I got a garbled mess to read

 

[edossantos]

Use this page to format the JSON response in an easy to read format ;-)
https://jsonformatter.curiousconcept.com/

 

[Doberman_techAJ]

Use this page to format the JSON response in an easy to read format ;-)
https://jsonformatter.curiousconcept.com/

Awesome that got me to what I needed and now its logging properly. Thanks!