Forum Discussion

DataProcessor's avatar
DataProcessor
Regular Visitor
11 months ago
Solved

Missing data when connecting Azure Data Factory to Hubspot

I am trying to get data from the contacts table into a microsoft fabric lakehouse. I first created a public app with all the scopes it would need to access I got the credentials and successfully crea...
pipelines
  • tayloramy's avatar
    tayloramy
    11 months ago

    Hi DataProcessor,

     

    You’re hitting a known gap: the native ADF “HubSpot” connector doesn’t expose a UI field to pass the properties= list that HubSpot’s v3 CRM APIs require. As a result, you only get the default contact properties (e.g., firstname, lastname, email) and everything else comes back null.


    Use the ADF REST connector (not the HubSpot connector) and call HubSpot’s Contacts API directly, adding your desired fields via the properties query parameter. Example endpoint:
    /crm/v3/objects/contacts?properties=firstname,lastname,email,jobtitle,company,phone&limit=100&archived=false
    Configure REST pagination using the $.paging.next.link cursor and map the results to your Fabric Lakehouse.

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi DataProcessor,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to tayloramy and anilgavhane  for prompt and helpful responses.

 

Just following up to see if the Response provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar