3CX Hubspot Integration - existing contacts are creating new contacts

Status
Not open for further replies.

TMG-Service

Titanium Partner
Basic Certified
Joined
Jan 26, 2021
Messages
2
Reaction score
0
Hello,

TL/DR: If there is anyone who has successfully integrated 3CX with HubSpot and has any advise on how to properly reformat the callerID and how the phone numbers should be saved in HubSpot, it would be greatly appreciated.


We have successfully integrated 3CX with HubSpot. However whenever a call comes in it will create a new contact even when there is an existing contact. We have reviewed the contact matching strategy, but are still having trouble.

By default we had caller ID's coming in as 11-digit numbers (ex. 1##########). In HubSpot we also had the phone numbers saved in a similar fashion (ex. 1##########); at least that's how they are displaying. So there were no parenthesis or dashes. When a call would come in it would create a new contact, which would display a phone number that was exactly matching. We would then call again and it would create a second new contact, again with a matching phone number. I would have though at the very least it should match with the new contact that was generated. This makes me think HubSpot is saving the number in a way that is not how it is displayed.

The contact matching strategy suggested we try using E.164 format, so we attempted that. First we attempted to just add the "+" to the beginning of the string (ex. +1##########). This would also generate a new contact, and repeated calls would also create new contacts. In HubSpot it displayed the phone number with parenthesis and dashes like so +1 (###) ###-####.

So we tried matching the format so I reformatted the CallerID to +1 (###) ###-####, I used the following source: "1(XXX)(XXX)(XXXX)" and replace: "+1 (\1) \2-\3", which did result in the desired Caller ID, which did save properly in HubSpot. However the same results occurred.

Thank you,

Philip
 
The best with HubSpot is to store the phone numbers as E164 or national format, without any special characters. Like "6031115544" or "+16031115544"

Then, configure 3CX to do a match on 10-digits minimum (Advanced > Contacts > Options.)

Unfortunately, there's no way to force the format in HubSpot, but Operations Hub might help to batch process the contacts and companies. Otherwise, we have built a small PHP script to update those for us.
 
  • Like
Reactions: TMG-Service
Resolved. At least for now. We restarted services in order to further to turn on the verbose for packet capture troubleshooting, but that appear to have resolved the issue. During testing we no longer had new contacts created and pop-up on the existing contacts was consistent. We intend to monitor it closely in the meant time for reoccurrence, and intend to restart services if it should reoccur.
 
Status
Not open for further replies.