Share
Report
3Hello,
As title says, I want to use Power Automate to add some data to a table in Big Query. The authentication seems kinda tricky though so I wanted to try and see if anyone has tried something similar or can offer some insights.
To my understanding reading the docs: https://cloud.google.com/bigquery/docs/authorization I need to construct a JWT using information from my service account JSON key, then use the JWT to retrieve an auth token and then I can use another HTTP POST action with my auth token to actually insert the data.
Does the auth part sound right? I haven't been able to find an example of someone constructing a JWT in PA yet which also makes me doubt if I am going about this correctly
Categories:
I have the same question (0)
All responses (
Answers (
