# HS \<\> Salesforce API

**URL:** <https://community.hubspot.com/t/hs-salesforce-api/90769>\
**Category:** APIs & Integrations\
**Tags:** companies\
**Created:** [September 29, 2023, 10:24am UTC](https://community.hubspot.com/t/hs-salesforce-api/90769 "2023-09-29T10:24:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![KMaguire](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@KMaguire](https://community.hubspot.com/u/KMaguire)\
**Post date:** [September 29, 2023, 10:24am UTC](https://community.hubspot.com/t/hs-salesforce-api/90769/1 "2023-09-29T10:24:27Z")

</div>

Hi,

We are currently testing in our Sandbox the Salesforce API - we potentially have a number of dupulicate companies that will sync from Salesforce to HubSpot which we are trying to avoid, the current salesforce set up does not have all the domain names populated - is there a way of choosing another ‘unique identifier’ to deduplicate any potential companies when the sync is turned on in our live production site.

---

<div class="post-metadata">

**Author:** ![zachh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zachh/32/87065_2.png) [@zachh](https://community.hubspot.com/u/zachh)\
**Post date:** [September 29, 2023, 2:25pm UTC](https://community.hubspot.com/t/hs-salesforce-api/90769/2 "2023-09-29T14:25:39Z")

</div>

Hi @KMaguire,

For clarification, when you say there are **duplicate companies** , do you mean there are multiple instances of the same company in Salesforce? Or do you mean that the same company lives in Salesforce and Hubspot?

In the first case, it would largely depend on what you’re using to distinguish them in Salesforce. Hubspot’s [Knowledge Base article on deduplication](https://knowledge.hubspot.com/crm-setup/deduplication-of-contacts-companies-deals-tickets) might be useful here - [particularly this section.](https://knowledge.hubspot.com/crm-setup/deduplication-of-contacts-companies-deals-tickets#unique-value-properties:~:text=create%20new%20records.-,Deduplicate%20records%20by%20custom%20unique%20value%20properties,-For%20contacts%2C%20companies)

For the second, if the company exists in Hubspot and has the same name (or other value you can use to make sure they’re the same), you could create a Custom Report listing all the company records that have those values, and export it as a CSV. You can then compare the companies in something like Google Sheets and perform a manual upload.

- Zach