topic Re: Connecting Hub Spot with Datawarehouse in Sales Integrations

Connecting Hub Spot with Datawarehouse

GrowSimplee — Tue, 20 Dec 2022 12:06:10 GMT

Hey,
I was trying to connect hubspot with Data warehouse. Wanted all Information about any deal but unable to get all the information from there around Company and Contact.I am connecting Zapier with Hubspot further Zapier is hitting our api which is further saving the deal data both created and updated. I am not getting any link with Contact and Company from the same also I am unable to get deal details linked with Contact or Company. Please can any help me with it.

Re: Connecting Hub Spot with Datawarehouse

franksteiner79 — Tue, 20 Dec 2022 12:33:12 GMT

Hi @GrowSimplee

What data warehouse application are you connecting with?

Do these objects - contacts, companies, deals arelady exist in HubSpot or are you trying to enrich existing HubSpot objects?

Could you describe in a bit more detail what deal information you are pulling in and what contact and company information is missing? What is the overall process you are trying to build?

When you say "I am not getting any link with Contact and Company" do you mean you are not getting the association between those objects?

Thanks

Frank

Re: Connecting Hub Spot with Datawarehouse

GrowSimplee — Tue, 20 Dec 2022 17:46:35 GMT

Hey @franksteiner79 ,
I am syncing it with Postgres DB using Lambda,I have a trigger through zapier which whenever a deal is created in hubspot, push deal's data into our api, but in that data I am not getting any information about deal's association with contact and Company, who's the contact for this deal and from which company, I wanted that data to build dashboards for Grow Simplee.