Ways to export hubspot data to AWS Data Lake

[rahil_shah]

Hi Everyone,

I am trying to set up a workflow that creates a data lake in S3 with Hubspot data (Companies, Contacts, Deals, and Tasks) which can be updated overnight.

And also a workflow to update values in Hubspot when there are related changes in the production platform.

I was hoping to get ideas and guidance to implement this in an effective manner.

Thanks

[WendyGoh]

Hey @rahil_shah,

When looking to retrieve HubSpot object data, you can explore the HubSpot CRM v3 object API and use the GET all objects endpoint. 

If you'd like to update object values, you can use the PATCH update objects endpoint. 

[rahil_shah]

Thank you, I am aware of this process, but I was hoping if there was a service or a tool which could make the workflow faster and easier to implement.