Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

acowpy
8 - Asteroid

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

4 REPLIES 4
acowpy
8 - Asteroid

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
8 - Asteroid

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
Alteryx
Alteryx

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

fpinchon
8 - Asteroid

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

Worth a try...

Labels