3CX V16 Zoho Integration

[kbist]

Hello,

Zoho integration not working after v16 upgrade, I'm getting this error.

Unknown function: IIf

Started scenario with empty id
Started Auth
Request text: https://accounts.zoho.com/oauth/v2/token
Request form value refresh_token set to
Request form value grant_type set to refresh_token
Request form value client_id set to
Request form value client_secret set to
Response text: {"access_token":"","expires_in_sec":3600,"api_domain":"https://www.zohoapis.com","token_type":"Bearer","expires_in":3600000}
Response finished
Variable AccessToken set to
Variable ApiDomain set to https://www.zohoapis.com
Finished Auth
System.ArgumentException: Unknown function: IIf
at TcxLexicalParser.LexEvaluator.ProcessInt(FunctionElement functionElement, IValueManager valueManager)
at CrmIntegration.EscapedExpressionEvaluator.ParseExpression(String expression, Boolean asExpression, IValueManager customManager)
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)


Thank you

 

[edossantos]

The IIf function is valid. What's the version of your 3CX installation? Please check it from the 3CX Console > Dashboard > License. Also, please check the version of the template (you can see it from the 3CX Console > Settings > CRM Integration > Zoho > Show template).

 

[kbist]

3cx Version: Professional Annual - 16.0.1581

Zoho Template: Name="Zoho" Version="12"

 

[edossantos]

It should work fine with the versions you're using. Maybe somehow the TcxLexicalParser.dll library is an old version. Can you please check the version number of that library? If your 3CX server is Windows, the library is in folder "C:\Program Files\3CX Phone System\Bin", and in Linux you will find it in folder "/usr/lib/3cxpbx/". Copy the library to your machine, right click on it, go to Properties > Details, and tell me the File Version you see there.

 

[kbist]

It is attached.

 

[edossantos]

The library version looks fine, thanks.

Please try deleting the template from the 3CX Console > Settings > CRM Integration > Zoho > Delete. Then you will see an update for Zoho in the 3CX Console > Settings > CRM Integration, download it and reconfigure the template. Let me know if that makes any difference.

 

[kbist]

Problem not solved

 

[edossantos]

Is this happening during the Authorization process? Or when you receive a call?

 

[kbist]

Authorization process successful but does not take action when a call arrives

 

[edossantos]

Can you try removing the following attribute from the Request elements?

SkipIf="[IIf([FoundRecordCount]>0,True,False)]"

You need to remove it from the 3 requests in which this appears.

Then save the template, remove the Zoho template from 3CX, and upload it again from Settings > CRM Integration > Add button.

Let me know if that makes any difference.

 

[kbist]

If contact creation is selected, the IIf problem continues.

 

[edossantos]

Somehow your installation seems to be broken. I would take a backup, uninstall and do a fresh install...

 

[kbist]

Problem is solved, Thanks.

 

[eurotechgr]

it working until now, now i get

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":"Fax"},"message":"invalid query formed","status":"error"}

 

[edossantos]

it working until now, now i get

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":"Fax"},"message":"invalid query formed","status":"error"}

This is because the Fax field is hidden. You need to make it visible.