how to link rest api in azure synapse for hubspot with OAuth 2.0 authentication

Abhishek Singh 5

User's image

Screenshot 2024-05-14 100358

When I use the same Api endpoint in postman I get the access token, refresh token and the authentication is successful. I can see the data which I'm trying to extract.

phemanth 6,810 Reputation points Microsoft Vendor

2024-05-14T06:05:13.19+00:00
@Abhishek Singh

Welcome to Microsoft Q&A forum and thanks for reaching out here.

To link a REST API in Azure Synapse for HubSpot with OAuth 2.0 authentication, you need to follow these steps:

Create an App in HubSpot:

Go to your HubSpot developer account and create an app.

Obtain the Client ID and Client Secret from the Auth page of your app settings.

Build the Authorization URL:

Use the Client ID and Client Secret to construct the authorization URL with the required scopes.

Direct users to this URL to grant access to your integration.

Handle the Redirect:

After granting access, users will be redirected to your specified redirect_uri with a code query parameter.

Exchange this code for an access_token and refresh_token from HubSpot.

Authenticate API Calls:

Use the access_token to authenticate API calls for the HubSpot account.

When the access_token expires, use the refresh_token to obtain a new access_token.

And regarding error message

For the “BAD_GRANT_TYPE” error you’re encountering, ensure that the grant type in Azure Synapse matches the one expected by HubSpot. The grant type should be set to authorization_code when exchanging the code for an access token.

Here’s a quick example of how the authorization URL might look:

https://app.hubspot.com/oauth/authorize?client_id=your_client_id&scope=contacts%20automation&redirect_uri=https://www.yourapp.com/

And the exchange for an access token using the code received:

POST https://api.hubapi.com/oauth/v1/token Content-Type: application/x-www-form-urlencoded client_id=your_client_id &client_secret=your_client_secret &redirect_uri=https://www.yourapp.com/ &grant_type=authorization_code &code=the_code_you_received

Make sure to replace your_client_id, your_client_secret, and the_code_you_received with your actual details.

For more detailed guidance, you can refer to HubSpot’s OAuth Quickstart Guide and Working with OAuth documentation

Here are some steps you can take to troubleshoot the issue:

Verify Grant Type: Double-check the grant type you're using in Azure Synapse for OAuth 2.0 authentication with HubSpot. HubSpot's documentation on OAuth should specify the grant type required for their API (https://developers.hubspot.com/docs/api/working-with-oauth).

Ensure Correct Configuration: Make sure Azure Synapse is configured correctly for OAuth 2.0 with HubSpot. This might involve specifying the authorization server endpoint, client ID, client secret, and scope. Refer to Microsoft's documentation for details on configuring OAuth 2.0 in Azure Synapse for REST APIs (https://learn.microsoft.com/en-us/entra/identity-platform/v2-oauth2-auth-code-flow).

Check Postman Configuration: Compare the OAuth 2.0 configuration between Azure Synapse and Postman. If there are any discrepancies, update the configuration in Azure Synapse to match Postman's settings.

Hope this helps. Do let us know if you any further queries.
phemanth 6,810 Reputation points Microsoft Vendor

2024-05-15T05:23:36.73+00:00

@Abhishek Singh We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Abhishek Singh 5 Reputation points

2024-05-15T05:31:18.85+00:00

@phemanth I did try to follow your answer but was not successful. Also, I did the OAuth 2.0 authentication from postman to get all the access tokens and install my private developer app into the HubSpot account (saw this method on google) but still, I can't link the HubSpot API with azure synapse. Not sure what will be the correct Base URL and Token endpoint for the connection.
phemanth 6,810 Reputation points Microsoft Vendor

2024-05-16T11:19:30.3666667+00:00

@Abhishek Singh We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Share via

how to link rest api in azure synapse for hubspot with OAuth 2.0 authentication