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.
