Jan 31, 2023 9:59 AM
I'm trying to find some information on the Hubspot connector for Synapse. I've got the connector set up correctly, and can access 123 tables with it. However, I'm specifically looking for things such as website visits, email events and other related activity.
So far, I've only found form submissions in the table Contacts_Forms_Submissions, but nothing on the other events.
Can anyone help?
Jan 31, 2023 10:25 AM
@DuncanP There are several integration options for HubSpot and Azure Synapse. Is that what you are referring to, and if so, which company's connector are you using?
Jan 31, 2023 10:54 AM
I've set up the Hubspot linked service as per the documentation here.
Jan 31, 2023 11:19 AM
The information you need can be found in the developer documentation: https://developers.hubspot.com/docs/api/overview Look at the Engagements API. IIRC the web events API is in beta and may not be included in Microsoft's connector.
Feb 2, 2023 4:40 AM
Yes, I've checked that API, but it doesn't quite correspond to what I'm seeing in the connector. I take it there's no documentation for it that you are aware of? I'm just looking for some idea of how the connector and the API map together really.