Error During Test CRM Integration within 3CX for Hubspot

[BAH]

Hello,

After successfully setting up and activating the 3CX - Hubspot integration per the 3CX guide, I attempted to test a known-in-Hubspot phone number. I have tried multiple numbers and some fail with same results and others work but don't show contact information (only company name). I have tried the numbers with and without the hyphens--no difference. The test fails with the following information: "CRM Integration is working OK but contact number does not exist. Check log for more info or try a different number."

Call journaling is enabled, but contact creation is disabled.

Here is the log entry:
tarted scenario with empty id
Started Auth
Request text: https://api.hubapi.com/oauth/v1/token
Request form value refresh_token set to c9c0385c-088b-4c36-97f9-c1d23d63d8df
Request form value grant_type set to refresh_token
Request form value client_id set to a0965e23-e3e7-481c-91a8-fcdf0a03a9aa
Request form value client_secret set to 80c7c567-1137-4a4a-b628-3985bd91b3ab
Response text: {"refresh_token":"c9c0385c-088b-4c36-97f9-c1d23d63d8df","access_token":"COiF-8ONLxICQQEYqPmWAyDoubMEKOyHETIZAH_eIA864hlpZa97UFDfeiIjb3Wyr4udTzonAAoCRwAADIADAAgAAAABAAAAAAAAABjAABMAAAAAAAAAAAAAAAAgQhkAf94gD9lG53OhaQSxMhs2BClUsKn6UN4ISgNuYTE","expires_in":21600}
Response finished
Variable AccessToken set to COiF-8ONLxICQQEYqPmWAyDoubMEKOyHETIZAH_eIA864hlpZa97UFDfeiIjb3Wyr4udTzonAAoCRwAADIADAAgAAAABAAAAAAAAABjAABMAAAAAAAAAAAAAAAAgQhkAf94gD9lG53OhaQSxMhs2BClUsKn6UN4ISgNuYTE
Variable ExpiresIn set to 21600
Started GetPortalID
Request text: https://api.hubapi.com/integrations/v1/me
Response text: {"portalId":6667432,"timeZone":"US/Eastern","currency":"USD","utcOffset":"-04:00","utcOffsetMilliseconds":-14400000}
Response finished
Variable PortalID set to 6667432
Finished GetPortalID
Finished Auth
Request text: https://api.hubapi.com/crm/v3/objects/contacts/search
Request message: {"properties":["firstname","lastname","company","email","phone","mobilephone","fax"],"filterGroups":[{"filters":[{"propertyName":"phone","operator":"EQ","value":"9853842840"}]},{"filters":[{"propertyName":"mobilephone","operator":"EQ","value":"9853842840"}]},{"filters":[{"propertyName":"fax","operator":"EQ","value":"9853842840"}]}]}
Response text: {"total":0,"results":[]}
Response finished
Finished scenario with empty id
Started scenario with empty id
Request text: https://api.hubapi.com/crm/v3/objects/companies/search
Request message: {"properties":["name","phone"],"filterGroups":[{"filters":[{"propertyName":"phone","operator":"EQ","value":"9853842840"}]}]}
Response text: {"total":0,"results":[]}
Response finished
Finished scenario with empty id
Started CreateContactRecord
Response finished
Finished CreateContactRecord
Result obtained

 

[edossantos]

Hello Ben,

Please check this part of the guide:
https://www.3cx.com/docs/hubspot-pbx-crm-integration/#h.rqhrtoh952xo

To get a match with Hubspot, the incoming Caller ID must be identical to the CRM entry, including any prefix, as Hubspot performs whole number lookups. Querying Hubspot using a subset of the digits, does not return any data.

So, ensure that the number you're searching is stored in Hubspot exactly as you're entering it in the query.