Associate HubSpot company to HubSpot deal

  • 6Views
  • Last Post 2 weeks ago
Carl Bouckaert posted this 2 weeks ago

Hi, inserting HubSpot deals we cannot match Company Id fetched with target lookup from HubSpot company with property associatedCompanyIds as the datatypes don't match. The returned Company Id is dti8 while the associatedCompanyIds on deals is dtntext. How to proceed to make the association?

Thanks for your help

Dmitriy Muzurov posted this 2 weeks ago

Hi Carl,

Thank you for submitting a ticket with us.

The field AssociatedCompanyIds stores data in fhe form of array because this field can carry several company IDs separated by comma.

For now it is not possible to lookup this field with the help of Skyvia as it does not parse square brackets.

Unfortunately, there is no workaround for your use case.

Should you have any questions, do not hesitate to contact us back.