APIs & Integrations

khookguy
Contributor | Diamond Partner
Contributor | Diamond Partner

Syncing HubDB data with Contacts

SOLVE

I have a client with HubDB data in one portal who want to synchronize that HubDB data with contacts in a different portal. What's the best way to do this?

 

More details:

Portal A has a HubDB table the includes an email address.  Whenever a new row gets aded to the table in Portal A, we would like to use the email address from that row to create a contact in Portal B.

 

0 Upvotes
1 Accepted solution
Willson
Solution
HubSpot Employee
HubSpot Employee

Syncing HubDB data with Contacts

SOLVE

Hi @khookguy 

 

Unfortunately, no. As the values stored in a HubDB table are not something that can be referenced via a Workflow, this is something that would have to be handled via the API as this will give you full control over the value pushed to the Contact Record.

Product Manager @ HubSpot

View solution in original post

0 Upvotes
3 Replies 3
Willson
HubSpot Employee
HubSpot Employee

Syncing HubDB data with Contacts

SOLVE

Hi @khookguy 

 

Have you taken a look at our HubDB Rest API found here:

https://developers.hubspot.com/docs/methods/hubdb/hubdb_overview

 

With this API, you'll be able to interact with the data from one of your tables and have it updated and pushed to the new table. An example process which you could adopt is to query the Table A for new rows using the following:

https://developers.hubspot.com/docs/methods/hubdb/v2/get_table_rows

 

Once you get this data, you can then push it to Table B using:

https://developers.hubspot.com/docs/methods/hubdb/v2/create_row

 

It's worth noting that you will need to be able to handle and query this data externally from HubSpot before pushing it from one table to another. 

 

I hope this helps! 

Product Manager @ HubSpot
khookguy
Contributor | Diamond Partner
Contributor | Diamond Partner

Syncing HubDB data with Contacts

SOLVE

Thanks, but to clarify - we need to push the data from the Table in Portal A to a Contact in Portal B. So, the data is moving across portals.  I understand this can happen using an script that calls the HubDB API to get data from Portal A and the Contacts API to push the data to Portal B.

 

Is there any way that I can kick this off from a workflow running in Portal B?

 

0 Upvotes
Willson
Solution
HubSpot Employee
HubSpot Employee

Syncing HubDB data with Contacts

SOLVE

Hi @khookguy 

 

Unfortunately, no. As the values stored in a HubDB table are not something that can be referenced via a Workflow, this is something that would have to be handled via the API as this will give you full control over the value pushed to the Contact Record.

Product Manager @ HubSpot
0 Upvotes