Missing properties at data retrieval for HubSpot connector

Question

Hi, noticed that when you using the HubSpot connector for a simple copy ingestion, the result is a HubSpot dataset version 1 , so all the customer properties for the version 3 (fields and values) are missing.

Is there any chance to set version 3 at connector dataset?

Official HubSpot contact, didn't produce more help for this circunstance.

Trying to avoid Api programming, for "low code" integration.

any help will be appreciate.

regards.

Oriol.

Answer 1

Hi AnnuKumari,

Thanks for your response, I will follow the REST API way as you mentioned, I was triyng to avoid it due HubSpot pagination rules and limitations for bulk data extractions.

So, let me know if you have any news with your internal team.

thks and regards,

Oriol.

Answer 2

Hi Oriol Morral ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you want to know if there is any way to modify the version when you use hubspot connector in ADF.

Right now , the recommended solution is to use the REST API to extract data from HubSpot version 3 and use the copy activity to load the data into your data store. To do that, you need to obtain an API key from HubSpot. You can then use the API key to make API calls to extract data from HubSpot .

Resources: Copy data from HubSpot using Azure Data Factory or Synapse Analytics

For more information , I am checking on this with internal team . I will keep you posted once I hear back from them . Thankyou for your patience.