Custom API sync to Hubdb

[BBecker1]

Hello,

I have a API endpoint with data (Reviews). I want to place these inside a hubdb but is it possible to create an app and sync the data. so it runs like a cronjob. Is this possible with only creating a Private App? or do i need to run the code on Azure/Vercel/Github etc.

 

[evaldas · Accepted solution]

Hi @BBecker1,

As far as I know, doing the automation with just the Private App alone would not be possible. 

If you wanted to keep everything in HubSpot, you could use workflows that run on a schedule and utilize custom coded actions (would require Operations Hub Pro) . Otherwise, you would need to use an external service to set up this kind of scheduled automation - either the ones you mentioned or tools like Zapier, etc.

Hope this helps!

[SteveHTM · Accepted solution]

@BBecker1 - This is a pretty interesting challenge! I've solve this kind of issue in projects using a custom coded workflow that leverages HubDB APIs - including the critical Import API  https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName}/draft/import 

Yes, this requires the use of a API token thats generated by defining a rpivate app - but that's an easy step to be honest.

The data you want to import can be in the form of CSV files - which can be uploaded, or arrive as email attachments, or other mechanisms.

Hope this is helpful,

Steve

[GiantFocal · Accepted solution]

Hi @BBecker1,

You can’t run scheduled syncs (like a cronjob) using just a HubSpot Private App. The Private App gives you API access, but it doesn’t actually run code or handle scheduling on its own.

To automate syncing your API data into HubDB, you’ll need to host your sync script somewhere else—like Azure, Vercel, GitHub Actions, or any server that supports scheduled tasks. Your script would use the Private App’s API token to connect to HubSpot and update HubDB on whatever schedule you want.

If you have Operations Hub Pro, you could use HubSpot workflows with custom code actions, but there are some limits, and it’s not as flexible as running your own script externally.

In short, a private app for API access and an external service for scheduling and running the sync. 

[SteveHTM · Accepted solution]

@BBecker1 - This is a pretty interesting challenge! I've solve this kind of issue in projects using a custom coded workflow that leverages HubDB APIs - including the critical Import API  https://api.hubapi.com/cms/v3/hubdb/tables/{tableIdOrName}/draft/import 

Yes, this requires the use of a API token thats generated by defining a rpivate app - but that's an easy step to be honest.

The data you want to import can be in the form of CSV files - which can be uploaded, or arrive as email attachments, or other mechanisms.

Hope this is helpful,

Steve

[evaldas · Accepted solution]

Hi @BBecker1,

As far as I know, doing the automation with just the Private App alone would not be possible. 

If you wanted to keep everything in HubSpot, you could use workflows that run on a schedule and utilize custom coded actions (would require Operations Hub Pro) . Otherwise, you would need to use an external service to set up this kind of scheduled automation - either the ones you mentioned or tools like Zapier, etc.

Hope this helps!

[DianaGomez]

Hi @BBecker1,

Thanks for reaching out to the Community!

I would like to invite some members of our community who may offer valuable insights.— hey @evaldas, @Teun , @SteveHTM    - Could you share your advice with @BBecker1?

Thanks for taking a look!

Diana