How do i integrate my hubspot account in azure synapse to extract the customer details from the data pipeline?

Question

I linked the hubspot account into the azure synapse data but when i click on data preview it has some missing columns which i need to extract.
I want to access the full customer details from hubspot into the data pipeline.

Answer 1

@Abhishek Singh

Thanks for using MS Q&A platform and posting your query.

There are two possible reasons why you might not be seeing all the customer details in your Azure Synapse data preview after connecting it to HubSpot:

1. Limited Columns by Default: HubSpot integrations often only bring in a pre-defined set of standard fields by default to ensure smooth performance. The missing columns might be additional custom properties you have created in HubSpot.

Data Filtering: It's possible your data pipeline might be configured with filters that exclude certain columns from being pulled in.

Here's how you can troubleshoot and access the full customer details:

Check HubSpot Connector Settings: Look for options within the Azure Synapse connector configuration for HubSpot. There might be settings to control which properties are extracted. You might find options like "Include all custom properties" or specific selections for the properties you need.

HubSpot Workflows: Consider using HubSpot workflows to export the specific data you need. HubSpot allows exporting contacts data with all properties to a CSV file. This file can then be loaded into Azure Synapse.

HubSpot API: If you're comfortable with code, you can leverage the HubSpot API to retrieve all the data you need. The API provides access to all your CRM object properties, including custom ones. You can then write scripts to integrate this data into your Azure Synapse pipeline.

Here are some additional resources that you might find helpful:

• HubSpot Knowledge Base on Exporting Data: https://knowledge.hubspot.com/account-management/export-your-content-and-data
• HubSpot Developer Documentation on CRM Objects: https://developers.hubspot.com/docs/api/crm/understanding-the-crm

By exploring these options, you should be able to configure your data pipeline to include all the customer details you require from HubSpot in Azure Synapse.

Hope this helps. Do let us know if you any further queries.