Call Bigquery REST API using Service Account

[Haripriya]

Hi,

Is there a way to call a Bigquery Rest API using service account? I need to push data from my powerapp to bigquery and I find the only way out is to create a custom connector. But due to org policies I am constrained to use a service account for authentication. I could not figure out a way to create a custom connector that authenticates through a service account.  Following is my post on powerapps forum. Any help would be highly appreciated.

Big query connector with Service Account Authentic... - Power Platform Community (microsoft.com)

Thanks,

Haripriya

[cristianrm]

You could authenticate using an account key file as shown in this documentation.

Then you have to authorize your API requests as shown in the following documentation.

This article shows you how to set up authentication using a service account with the BigQuery API.

[Haripriya]

Thanks Christianrm for the suggestions. But I am not sure if these links help my case, because I don't find a way to use client libraries with powerapps custom connectors. Please share if you have any pointers on authenticating using service account for Rest API.

Thanks,

Haripriya