Google Input service-to-service authentication (for APIs other than BigQuery)

[acowpy]

Hi

Would it be possible to make available a general purpose Google Authenticate tool that allows service-to-service authenticate, the output of which (access token) could then be used for REST calls to Google APIs?

This is currently only available for BigQuery but we also need to access Drive, Google Storage, and other services via a service account. There are other Alteryx tools out there that can be used to access via a named account (using a client_secret & refresh token) but none that I have seen (except the BigQuery Input tool) that allow you to use a JSON private key file to authenticate.

I assume this is easy to achieve as this is already a component of the BigQuery input tool anyway

Cheers

[acowpy]

Effectively it would just need to generate a JSON web token (JWT) according to these docs:

https://cloud.google.com/iot/docs/how-tos/credentials/jwts#iot-core-jwt-python

[fpinchon]

I built one for Google Analytics which can be easily tweaked to accommodate BigQuery:

http://insightsthroughdata.com/connect-to-google-analytics-4-ga4-and-extract-with-alteryx/

Skip to the 'Authentication using a Service Account' part...

[ChaseA]

@fpinchon Have you used the above GCP service account method for Google Drive Input/Output too by chance? 

[fpinchon]

I haven't tried, but used to method successfully on GA4 and G Sheet...

Worth a try...