Unable to generate access token for Google sheet using Service account authentication

Prajakta-8530 45 Reputation points
2023-07-24T10:45:44.7166667+00:00

I am trying to fetch google sheet data in ADF. For that I have enabled google sheet api for the project I have created and using service account authentication. In that I am taking help from documentation https://developers.google.com/identity/protocols/oauth2/service-account#httprest where I am following Service account authorization without OAuth.

I have created header and payload and trying to get jwt token using postman but unable to generate signed jwt and getting this errror msg

User's image

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,136 questions
0 comments No comments
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 29,601 Reputation points Microsoft Employee
    2023-07-26T07:44:45.53+00:00

    Hi Prajakta-8530 ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

    I understand that you are trying to fetch Google Sheet data in Azure Data Factory (ADF) using service account authentication. But it's throwing an error while generating JWT token using Postman. Please let me know if that is not the correct understanding of your query.

    Instead of generating JWT token from postman , kindly try creating it via GCP console by referring to this document: Generating Access Token for Google Cloud Platform API Access using Service Accounts

    Additionally, the query doesn't relate to ADF end, I would suggest you to check with GCP community for assistance:

    https://cloud.google.com/communities

    https://groups.google.com/g/google-cloud-endpoints

    Hope it helps. Thankyou


0 additional answers

Sort by: Most helpful