How to connect Azure (data factory) with hubspot since the update API Key / Private apps ?

[scambron]

Hello,

I am trying to extract some pipelines informations from hubspot and send them to azure for reporting.

This post explains exactly what I was trying to do:

https://www.cathrinewilhelmsen.net/connecting-hubspot-azure-synapse-analytics-azure-data-factory/

But as you can see in the screenshot, azure is proposing Linked service with Hubspot for easy connectivity but azure asks for client ID / Client secret / access token / Refresh token

The only thing we have with the new API Key / Private app is an access token. How am I suppose to fill the fields asked by Azure ?

Thanks for letting me know

[scambron]

Thanks a lot for the update !

[Jaycee_Lewis · Accepted solution]

Hey, @scambron 👋 My hunch is that article has become outdated. I doubled checked all my Private Apps and none show the client secret/client id tab that the article is showing. Additionally, this is not listed in the Private Apps documentation. 

Looking at the Microsoft documentation, they direct you to create a public app which uses OAuth and will have all the needed auth details. 

• Copy data from HubSpot using Azure Data Factory or Synapse Analytics 
  
• Link from screenshot — How do I create an app in HubSpot?
• HubSpot OAuth Quickstart Guide

Have fun building! — Jaycee