Associate HubSpot company to HubSpot deal

  • 352Views
  • Last Post yesterday
0
votes
Carl Bouckaert posted this 04 July 2019

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

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 05 July 2019

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.

0
votes
Johnny Josefsson posted this 02 August 2019

Hi,

The next question would then be; when do you plan to support this as it is an essential functionality to match CompanyID with deals, contacts and so on?

0
votes
Dmitriy Muzurov posted this 05 August 2019

Hi Johnny,

Thank you for contacting our Support Team.

Such scenario could be implemented in the form of expression mapping in the lookup.

A request for this is created for our development team.

To our regret, we don't have any ETA.

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

0
votes
Jan Jansen posted this 19 February 2021

Hi Johnny,
Hi Dmitriy,
has this been solved ever since? I managed to get it working for Contacts and Deals via the DealContacts table, but now I need the same for companies & deals.
Thanks for your answer(s)!

0
votes
Dmitriy Muzurov posted this 23 February 2021

Hi Jan,

Thank you for contacting us.

This has not been solved so far.

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

0
votes
Jan Jansen posted this 24 February 2021

Hi Dmitriy,

is it still on your agenda though or does it make sense to look for another solution?

0
votes
Dmitriy Muzurov posted this 24 February 2021

Hi Jan,

It's on our agenda, however there is no ETA, so we would recommend looking for other options.

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

0
votes
Jan Jansen posted this yesterday

Hi Dmitriy,

any update on the ETA? We still haven't been able to solve this so I though after 4 months it's worth asking once again

Thanks!

Close