topic Re: Search companies by phone number returns unexpected results in APIs & Integrations

Search companies by phone number returns unexpected results

LianYiFei — Tue, 10 Dec 2024 01:02:10 GMT

Hi there,

I've encountered an API issue, when search companies by phone number via search API, some of them with specific format are not in the results. For example, when query with "*7207159789", only #1/2/3 are returned, and #4/5 are not

+17207159789
17207159789
7207159789
+1 (720) 7159-789
(720) 7159-789

The API we use is

curl --location 'https://api.hubapi.com/crm/v3/objects/company/search' \ --header 'Content-Type: application/json' \ --header 'Authorization: ••••••' \ --data '{ "query": "*7207159789" }'

By the way, using the same query for contacts, all of the above phone numbers can be identified.

I wonder if this is a known issue, or if we can make it respond the same way as the Contact API.

Thanks.

Re: Search companies by phone number returns unexpected results

HMir — Tue, 10 Dec 2024 14:09:26 GMT

@LianYiFei wrote:
Hi there,

I've encountered an API issue, when search companies by phone number via search API, some of them with specific format are not in the results. For example, when query with "*7207159789", only #1/2/3 are returned, and #4/5 are not
+17207159789
17207159789
7207159789
+1 (720) 7159-789
(720) 7159-789
The API we use is

curl --location 'https://api.hubapi.com/crm/v3/objects/company/search' \ --header 'Content-Type: application/json' \ --header 'Authorization: ••••••' \ --data '{ "query": "*7207159789" }'

By the way, using the same query for contacts, all of the above phone numbers can be identified.

I wonder if this is a known issue, or if we can make it respond the same way as the Contact API.

Thanks.

It could be due to how phone numbers are processed and normalized by the API. The Contacts API seems to handle different phone number formats, such as with or without country codes, parentheses, or spaces, more flexibly. However, the Company Search API may not normalize phone numbers in the same way, leading to inconsistencies in search results. Additionally, the wildcard search query you're using ("*7207159789") might not be interpreted consistently across all formats. As a result, certain phone number formats may not return the expected results. This issue could be resolved by adjusting the search query or ensuring phone numbers are consistently formatted before querying.

Re: Search companies by phone number returns unexpected results

GRajput — Wed, 11 Dec 2024 06:44:44 GMT

Hi @LianYiFei

Here is the curl for company search API

curl --location 'https://api.hubapi.com/crm/v3/objects/contacts/search' \ --header 'Content-Type: application/json' \ --header 'Authorization: Bearer pat-na1-8783b435-676a-4dc0-ad65-7d1a2fbdcb7c' \ --data '{ "filterGroups": [ { "filters": [ { "propertyName": "phone", "operator": "EQ", "value": "" } ] } ] }'

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!

Re: Search companies by phone number returns unexpected results

LianYiFei — Wed, 11 Dec 2024 06:48:57 GMT

Thanks, but it doesn't work, with the "filterGroup", the results respond even less then the "query" search way