topic Re: How to connect Azure (data factory) with hubspot since the update API Key / Private apps ? in APIs & Integrations

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

scambron — Wed, 22 Mar 2023 15:55:50 GMT

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

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

Jaycee_Lewis — Wed, 22 Mar 2023 20:54:07 GMT

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

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

scambron — Mon, 27 Mar 2023 13:26:46 GMT

Thanks a lot for the update !