Getting a remote dataset from BigQuery into Xibo via OAuth 2

Get Help
1

Hi!

So I have been trying to pull data from BigQuery into Xibo. I tried setting up a remote dataset in Xibo and including the target data’s googleapi address (e.g. https://bigquery.googleapis.com/bigquery/v2/projects/project1/datasets/dataset1.tablename) as the URI for a GET request. I can’t get the authentication to work. Google gives this error message:

{
“error”: {
“code”: 401,
“message”: "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
“errors”: [
{
“message”: “Login Required.”,
“domain”: “global”,
“reason”: “required”,
“location”: “Authorization”,
“locationType”: “header”
}
],
“status”: “UNAUTHENTICATED”
}
}

I tried setting up a service account with the required permissions to access the table, and having that service account’s key as a password for the Bearer method, but that didn’t work.

Does anyone here have experience getting BigQuery data into Xibo? I guess I’m not using the right authentication style. What should I do to get the authentication working?

2

Anyone?

:tumbleweed:

Still haven’t solved this. Wonder if I should use an alternate approach, e.g. POST via our own infrastructure. This approach would’ve been more convenient, if only I could get the authentication to work.