What Token endpoint is provided in Rest linked service for accessing google sheet data having OAuth2 client credential

Prajakta-8530 45

I am trying to create rest linked service to access google sheet data, in that I am using OAuth2 client credential authentication type. I have also generated access token by following this link https://developers.google.com/identity/protocols/oauth2/web-server#httprest

User's image

But connection is failing due to incorrect token endpoint.

Bhargava-MSFT 31,196 Reputation points Microsoft Employee

2023-07-13T17:22:20.4933333+00:00

Hello rajakta-8530,

I am checking to see if you got a chance to look into my above response.
Prajakta-8530 45 Reputation points

2023-07-17T04:28:36.1966667+00:00

Hi @Bhargava-MSFT
Thank you for the response, where shall I pass the generated access token?
Bhargava-MSFT 31,196 Reputation points Microsoft Employee

2023-07-17T23:17:43.7+00:00

Hello

You can add the authorization header on the linked service.

Please see the below screenshot for your reference.
Bhargava-MSFT 31,196 Reputation points Microsoft Employee

2023-07-19T16:51:27.3566667+00:00

Hello rajakta-8530,

I am checking to see if you have any further questions here.
Prajakta-8530 45 Reputation points

2023-07-22T17:57:44.8966667+00:00

Hi @Bhargava-MSFT

I'm still getting error in that even though entered credentials are correct.
Bhargava-MSFT 31,196 Reputation points Microsoft Employee

2023-07-24T19:54:46.9866667+00:00

Hello rajakta-8530,

Can you please follow this video

blog post: https://blog.postman.com/how-to-access-google-apis-using-oauth-in-postman/#:~:text=Access%20Token%20URL%3A%20This%20is,.googleapis.com%2Ftoken
Prajakta-8530 45 Reputation points

2023-07-25T07:02:03.09+00:00

@Bhargava-MSFT Thank you for the help. Can you please tell how can I generate this token in web activity in ADF?(by following oauth2 authentication)
Bhargava-MSFT 31,196 Reputation points Microsoft Employee

2023-07-26T23:10:42.53+00:00

Hello rajakta-8530,

Please follow this blog post:
https://medium.com/analytics-vidhya/azure-data-factory-retrieve-token-from-azure-ad-using-oauth-2-0-9a3ed3f55013

Here you need to use the URL: https://oauth2.googleapis.com/token

1 answer

Bhargava-MSFT 31,196 Reputation points Microsoft Employee

2023-07-12T22:03:02.1733333+00:00

Hello rajakta-8530,

The error message you are encountering while creating a REST linked service to access Google Sheet data is due to an incorrect token endpoint.

The token endpoint URL for Google OAuth 2.0 is https://oauth2.googleapis.com/token

and please make sure the client ID and client secret are correct and match the ones generated in the google cloud.

also, If the access token is expired, you need to generate a new access token.

I hope this helps. Please let me know if you have any further questions.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

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

Share via

What Token endpoint is provided in Rest linked service for accessing google sheet data having OAuth2 client credential

1 answer

Your answer