Freshwork - Freshsale and E164 lookup

[Daniele!]

Hello,

I'm using current "Freshworks CRM" extension but I've found out a problem. It cannot find contacts when the "+" of E164 format is used. This is a problem as I've just converted all my CRM phone number to that standard format. It is the same format used also by Whatsapp chat integration on freshsale.

Below you can find the standard query of the 3CX extension. It is working as expected.

Started scenario with empty id
Request text: https://XXX.myfreshworks.com/crm/sales/api/lookup?q=+39xxxxxxx&f=work_number&entities=contact&include=sales_account
Response text: {"contacts":{"contacts":[]}}
Response finished
Finished scenario with empty id
Started scenario with empty id
Request text: https://XXX.myfreshworks.com/crm/sales/api/lookup?q=+39xxxxxxxxxx1&f=mobile_number&entities=contact&include=sales_account
Response text: {"contacts":{"contacts":[]}}
Response finished
Finished scenario with empty id
Started scenario with empty id
Request text: https://XXX.myfreshworks.com/crm/sales/api/lookup?q=+39xxxxxxxxx&f=phone&entities=sales_account
Response text: {"sales_accounts":{"sales_accounts":[]}}
Response finished
Finished scenario with empty id

I had a chat with Freshwork support and we find out that the query works if "%2b" is used instead of "+".

You can test using this query:
curl --location 'https://xxx.myfreshworks.com/crm/sa...number&entities=contact&include=sales_account' \
--header 'Authorization: Token token=XXXXXXXXXX' \
--data ''

Someone can help me change the behaviour of the 3CX extension query to encode "+" in ASCII "%2b" ??

Also I wanted to post this info as I didn't find anything about this problem on google.

 

[edossantos_sipcaller]

Try with:
[[Number].Replace("+","%2B")]

 

[Daniele!]

Wonderful!
Thanks!

Try with:
[[Number].Replace("+","%2B")]