Share via

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

Prajakta-8530 45 Reputation points
2023-07-06T13:07:37.88+00:00

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.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    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.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.