Pipedrive CRM integration functions properly, but the contact number is not found. Review the log for details or attempt a different number.

[Excel Telecom]

Hi All,

Wonder if anyone can help with Pipedrive issue, upgraded pbx to version 20 latest version and followed the 3CX Pipedrive documentation but am getting the below error

Started scenario with empty id
Started Auth
Request text: https://oauth.pipedrive.com/oauth/token
Request form value refresh_token set to 13536926:20911375:0e9f2bfe7996e09446974242e50e3f8ca54ecd7a
Request form value grant_type set to refresh_token
Response text: {"access_token":"v1u:AQIBAHj-LzTNK2yuuuaLqifzhWb9crUNKTpk4FlQ9rjnXqp_6AE-mSRsNEc-qt-JZF1QvUyHAAAAfjB8BgkqhkiG9w0BBwagbzBtAgEAMGgGCSqGSIb3DQEHATAeBglghkgBZQMEAS4wEQQMGqcEIUgSSD15bcXPAgEQgDtLA6W-OJ_ytVMrWzkVH7tyBFy3C5ZLb1hgRXukifjFKHrPSN0XT5mLYmrNgQAPNro5MhWeqqjIaVI6zA:yfeuoXKl4xcWZl3unSJcPhR-1yxQ2mu3yZPLPE4DYKk8tNx8oobIArlx99V6WbUwl6g11oMNR8k8KMoLI9ZQs-dbnx402y4F3Iy5xzNH_4L6DYSKMj8_h4iwC5D34sz4aCsdvDTsMQyEMV1cBRb7-hQIPuuQzA6IqRDGdpuF235d7y5LGZPcEl3JAyk_O1UcP1y1I34VQY6uRPm_o1-rQC2HXtIC94CMNhWg0Iam5VVTHXG2-6k80Vzw28B4bz_R_h_PdI6XNH8kDtknoC52enW2AuWgoXoiTA7eSqie_WbK3ZmQkuaqbDyzGNpDcgc6Ei4BLSmEXsaPpbYHeliyWCXLS2O1aUs","token_type":"Bearer","expires_in":3599,"refresh_token":"13536926:20911375:0e9f2bfe7996e09446974242e50e3f8ca54ecd7a","scope":"base,contacts:full,users:read,search:read,phone-integration","api_domain":"https://test3cx-sandbox.pipedrive.com"}
Response finished
Variable AccessToken set to v1u:AQIBAHj-LzTNK2yuuuaLqifzhWb9crUNKTpk4FlQ9rjnXqp_6AE-mSRsNEc-qt-JZF1QvUyHAAAAfjB8BgkqhkiG9w0BBwagbzBtAgEAMGgGCSqGSIb3DQEHATAeBglghkgBZQMEAS4wEQQMGqcEIUgSSD15bcXPAgEQgDtLA6W-OJ_ytVMrWzkVH7tyBFy3C5ZLb1hgRXukifjFKHrPSN0XT5mLYmrNgQAPNro5MhWeqqjIaVI6zA:yfeuoXKl4xcWZl3unSJcPhR-1yxQ2mu3yZPLPE4DYKk8tNx8oobIArlx99V6WbUwl6g11oMNR8k8KMoLI9ZQs-dbnx402y4F3Iy5xzNH_4L6DYSKMj8_h4iwC5D34sz4aCsdvDTsMQyEMV1cBRb7-hQIPuuQzA6IqRDGdpuF235d7y5LGZPcEl3JAyk_O1UcP1y1I34VQY6uRPm_o1-rQC2HXtIC94CMNhWg0Iam5VVTHXG2-6k80Vzw28B4bz_R_h_PdI6XNH8kDtknoC52enW2AuWgoXoiTA7eSqie_WbK3ZmQkuaqbDyzGNpDcgc6Ei4BLSmEXsaPpbYHeliyWCXLS2O1aUs
Variable ApiDomain set to https://test3cx-sandbox.pipedrive.com
Variable ExpiresIn set to 3599
Finished Auth
Request text: https://test3cx.pipedrive.com/v1/persons/search?fields=phone&exact_match=false&term=01613387300
Response text: {"success":true,"data":{"items":[]},"additional_data":{"pagination":{"start":0,"limit":100,"more_items_in_collection":false}}}
Response finished
Finished scenario with empty id

Thanks in advance

 

[Evolute IT]

Are you storing the numbers in E164 in Pipedrive? If so, you need to either change your trunk settings to reformat to E164, or change the matching strategy to less digits. We usually use 9 in the UK/AU/NZ/EU since you have a leading 0 but that's not there in E164.

 

[Excel Telecom]

Thanks for this i have tried all of the above but still getting same , numbers are stored in local format , i have tried with 9 and 6 digits and adjusted one account to e164 to try but still nothing.

 

[edossantos_sipcaller]

You will need to understand why the Pipedrive API is not returning the contact details. You can try invoking the API using Postman and use different formats, until you understand how you need to run this lookup, and this way configure 3CX to format the numbers like that.