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

Question

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

Answer 1

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