Can we add matching criteria for HubSpot company object in TIBCO Scribe Online

[Hendrik De Fleurquin]

Deduplication on contacts is easily done by HubSpot on email address, this property is available in the matching criteria for the HubSpot contact object. Conversely there is no automated company deduplication in HubSpot. To differentiate different companies sharing the same domain we usually create a custom property "External ID" on the company where we store a unique key (f.e. the ID of the platform the data is coming from), this field is used as matching criterium to identify the correct HubSpot company.

Is there a way to addmatching criteria to the HubSpot company object, so we can use it in integration mapping, f.e. in an insert/update block Can we add a custom HubSPot property to the matching criteria We are usingTIBCO Scribe Online

Thanks in advance for your help!

Kind regards

[Brendan Peterson 4]

The only way HubSpot allows you to update a Company is by ID - they also only allow you to search based on Created Date, Modified Date or Domain.

https://developers.hubspot.com/docs/methods/companies/companies-overview

In order to do what you are looking to do you would need to use something like a Fetch to pull back ALL HubSpot Companies, then inside that Fetch use an IF block to filter out the noise and find the one that matched your external ID - doable but depending on the number of companies you have could add some overhead.

You could also store the key pair somewhere else and use that as your method of de-duping, so it ifs not in your external key store then cascade down some other logic to get it into HubSpot correctly.

All in all, doable with some creative integration designs but just made harder since HubSpot does not support it natively.

Brendan