Hey Bubblers -
I’m having trouble connecting to google via the api connector when using a service user account (aka the same user for every call, since it’s accessing my database, not the user’s)
I’m creating an app that will write/read from google’s cloud hosted SQL database, so I want to use the service account, not the user’s google account.
I’ve enabled the APIs I need, created a service account with appropriate user role, downloaded json credentials, and have the app id and app secret. I’ve also written/ran an API call using this data via a python script in my terminal, used it to connect to the database via my terminal, and successfully called it in the google api playground.
As best I can tell, I need to pass the json file (private key) to google in order to get back the auth token & successfully call the API. Is there any way to add a pre-request script to the API via the API connector? Or to write the code directly?
I’d much rather keep using bubble - but if I can’t get this to work I’ll likely just write the full stack from google’s app engine.