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
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.
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?
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.
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)!
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.
Hi Dmitriy,
is it still on your agenda though or does it make sense to look for another solution?
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.
