Hi all - I’m struggling to get the API connector to work with Google Big Query API so am hoping one of you has done this before and can tell me what i’m messing up!
I want to set up a server to server connection as will be using my own google GCP project rather than asking users of my app to login to theirs. I’ve therefore setup a service account in GCP and am using the JSON Web token authentication mechanism.
Each time i try to initialise the API, i get the following message returned:
Images of how i’ve tried to set this up are below:
POST Method to run a query:
Any guidance on how to set this up properly?