Connecting HubSpot from Azure Data Factory

[SHussain]

Hi, I am new to both HubSpot and Azure Data Factory (ADF). I got a task to use HubSpot as Source and SQL DB as Target. I am trying to create a linked service in ADF and one of the fields asking for Access Token. I have the client id and client secret by creating an app but not sure how to create an access token or refresh token using OAuth. Can anybody please help. Thanks.

Saj.

[CarltonBanks]

Any status on this?

[JLaRosaGuzman]

Buenas tardes,

Estoy tratando de conectar Azure Data Factory mediante el conector que ofrece Microsoft con Hubspot, según esta documentación: https://docs.microsoft.com/es-es/azure/data-factory/connector-hubspot?tabs=data-factory He logrado obtener todos los datos incluidos, access y refres token. Lo vengo usando el conector de hubspot en azure para poder obtener los datos y guardalos en un almacenamiento en azure, pero el realizar la prueba de conexión, presiono el boton "Probar conexion" pero obtengo este error el cual no se a qué hace referencia.

Agradecere puedan ayudarme. adjunto las fotos.

Parametros de conexión obtenidas por la aplicacion creada en HubSpot DevelopersError obtenido al realizar la prueba de conexión

[PMarengo]

We are getitng a similiar error trying to connect as you.

I don't see any answers on how to get the proper Access/Refresh tokens. Even using the old docs doesn't work https://legacydocs.hubspot.com/docs/methods/oauth2/get-access-and-refresh-tokens

[johnelmer · Accepted solution]

@SHussain @dennisedson We offer an app in the HubSpot App Marketplace called MS SQL Server for HubSpot . The app pulls your HubSpot data into a SQL data warehouse via prebuilt API connectors. A SQL data warehouse in Azure is included in the cost.

Once your HubSpot data is in the data warehouse, it automatically refreshes on a scheduled basis. You can connect the SQL data warehouse to any other application that has a SQL connector.

[dennisedson]

Hi @SHussain 

Would this documentation help?

[SHussain]

Hi Dennis,

Thanks for the reply. The documentation helps. but still, I am not sure how and from where exactly I can generate the token. Sorry for the silly question, I absolutely new in this field.

Thanks.

[MSelvakumar]

@SHussain This might help! https://www.loom.com/share/5880c34ba1a344998a019460fcbac5f6

[dennisedson]

Hi @SHussain 

Adding @prosa to the conversation to see if he has thoughts 😀