topic Re: Duplicated companies records with API in APIs & Integrations

Duplicated companies records with API

Aliba — Thu, 04 Oct 2018 18:35:54 GMT

Hi,

We imported companies records that were pre-existing in Hubspot having the same domain as the pre-existing one: Hubspot duplicated the records instead of merging the imported records with the existing ones having the same domain name.

Detailed description of what happened:

Company with name A and domain name A exists in Hubspot
Another Company B with domain B is created via API call (B has the same name and domain name as A)
Instead of merging Companies A and B, Hubspot created two separate companies

How to avoid duplication?

Re: Duplicated companies records with API

IsaacTakushi — Thu, 04 Oct 2018 19:03:37 GMT

Hi @Aliba,

I believe I was able to replicate this behavior in my own portal. Could you send me links to two company records where this happened?

Re: Duplicated companies records with API

Aliba — Fri, 05 Oct 2018 12:11:09 GMT

Sure:

Re: Duplicated companies records with API

Aliba — Mon, 08 Oct 2018 16:03:16 GMT

Hi @Isaac_Takushi, any update on this?
Thank you,

Alice

Re: Duplicated companies records with API

IsaacTakushi — Mon, 08 Oct 2018 20:40:14 GMT

Hi @Aliba,

Not yet, but I'm investigating further with my team. I appreciate your patience.

Re: Duplicated companies records with API

IsaacTakushi — Tue, 09 Oct 2018 18:01:07 GMT

Hi @Aliba,

Thanks for your patience.

I've confirmed with the relevant product team that HubSpot only deduplicates imported company records. Companies created via the API are not deduplicated by the Company domain name property at this time. Apologies for the confusion surrounding this distinction. I'll have this article corrected.

This endpoint allows you to check for company records with a specific Company domain name value. You could add it to your app to programmatically deduplicate before creating new records with identical domains.

Re: Duplicated companies records with API

raihaniqbal — Tue, 30 Jul 2019 23:54:41 GMT

@IsaacTakushi where in the request JSON do I provide the domain that I would like to search. The example JSON in the doc just specifies the properties to be returned in the response.

{
  "limit": 2,
  "requestOptions": {
    "properties": [
      "domain",
      "createdate",
      "name",
      "hs_lastmodifieddate"
    ]
  },
  "offset": {
    "isPrimary": true,
    "companyId": 0
  }
}

Re: Duplicated companies records with API

IsaacTakushi — Wed, 31 Jul 2019 15:33:15 GMT

Welcome, @raihaniqbal.

Happy to clarify.

With the Search for companies by domain endpoint, you specify the domain in the request URL itself.

Note where the :domain placeholder is below:

https://api.hubapi.com/companies/v2/domains/:domain/companies

For example, if I were searching for hubspot.com, I would use:

https://api.hubapi.com/companies/v2/domains/hubspot.com/companies

Other search settings like limits and desired properties are included in the payload.

Re: Duplicated companies records with API

LSadowski — Thu, 09 Feb 2023 12:40:05 GMT

This limitation still seems to exist in 2023, can you say if there are any plans to make deduplication for API-generated company records possible?