I am trying to pull data from Hubspot to an Azure Data Factory environment by using the Hubspot Linked Service. I am at a stop due to an error, which I cannot resolve. Steps I've followed: Created a private app through this Hubspot guide I got the right Client ID, Client Secret I got the Access Token & Refresh Secret through Postmen I made a Linked Service with this Microsoft guide I get this error. I am able to pull Contact info through Postmen. I found these posts helpfull but they did not give me a proper answer: https://stackoverflow.com/questions/64591471/error-when-creating-the-linked-service-for-hubspot-in-adf https://www.loom.com/share/5880c34ba1a344998a019460fcbac5f6 https://community.hubspot.com/t5/APIs-Integrations/Connecting-HubSpot-from-Azure-Data-Factory/m-p/414894

I've found that adding all the scopes within the Hubspot Private app resolves my issue. I am not sure which access scope did the job but I can continue for now.

Error when connecting Hubspot to Azure Data Factory

Niek 6

I am trying to pull data from Hubspot to an Azure Data Factory environment by using the Hubspot Linked Service. I am at a stop due to an error, which I cannot resolve.

Steps I've followed:

Created a private app through this Hubspot guide
I got the right Client ID, Client Secret
I got the Access Token & Refresh Secret through Postmen
I made a Linked Service with this Microsoft guide

I get this error.

I am able to pull Contact info through Postmen.

I found these posts helpfull but they did not give me a proper answer:

KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2022-11-08T01:20:57.7+00:00

Hello @Niek ,

Thanks for the question and using MS Q&A platform.

The error message says unauthorized access. I suspect the refresh token might have expired. Could you please confirm you have used the refresh token as soon as it is generated?
Niek 6 Reputation points

2022-11-08T07:32:27.357+00:00

Hi @KranthiPakala-MSFT ,

Thanks for your response, I've tried again to fill in the Client ID, Client Secret, Access Token and Refresh Token and I still get the same message. I am sure that I've filled in the right credentials as I am able to use the same credentials through Postman. The only difference in Postman is that I use the Acces token as a bearer and do not supply the refresh token.
KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2022-11-10T02:34:50.373+00:00

Hello @Niek ,

Thanks for confirming. This issue needs a deeper investigation hence we recommend filing a support ticket if you have a support plan and do share the support ticket number with us here. In case if you don't have a support plan, please let me know here.

Thanks

1 answer

Niek 6 Reputation points

2022-11-18T14:50:02.793+00:00

I've found that adding all the scopes within the Hubspot Private app resolves my issue. I am not sure which access scope did the job but I can continue for now.
Please sign in to rate this answer.

1 person found this answer helpful.
KranthiPakala-MSFT 46,512 Reputation points Microsoft Employee

2022-11-23T02:14:48.36+00:00

Hello @Niek ,

Glad to know that your issue has been resolved and appreciate much for sharing your findings here with community as it would help others reading this thread.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error when connecting Hubspot to Azure Data Factory

1 answer

Your answer