Contact Record ID in data sync

Develop, Build & Integrate APIs & Integrations
1

We have some airtable bases where we have some linked tables to hubspot lists. My hope is to have a formula field that uses the Contact record id to have a live link directly to the contact record in hub. Like this:

HubSpot"&{Contact ID}
I cannot seem to retrive the contact ID to sync it to the Contact ID field in my AT base. Is there another way to do this? I want users to be able to easily navigate to, or preview, the contact record in Hub from Airtable.

2

Hey @EGonzales

You should be able to use the V1 Get contacts in a list endpoint to get contacts in a list. Contact record IDs will be labeled as “VID”.

Hope this gets you moving!

3

could be i am out of my depth here. I am trying to use this tool in the integrations section of my settings. When i am trying to configure in the field mapping, there is no contact field for Contact ID =-(

Screenshot 2023-04-18 at 3.00.58 PM.png
Screenshot 2023-04-18 at 3.00.58 PM.png3752×2454 525 KB

4

Did you ever find a solution to this? I’m in the same boat, but with Company Record IDs.

5

Yeah! I ended up creating a new field and a workflow to copy the record ID into it in every record. Then you can access this record ID field in the AT integration. :slightly_smiling_face: Kinda clunky but it works.

6

Hey all - I’m the PM on data sync. It took us some time but we finally got around to this. You can now map the record id in your data syncs without the need of clunky workarounds.