I am trying to create a service account Big Query connection in an OEM solution for all sub-tenants using Qlik Platform Operations and the path 'data-connections'. However the api-call doesn't work, instead it gives me the error that 'Unable to connect to database: [Qlik][BigQuery] (8706) Unable to open keyfile'.
What can be done to solve this? My post request looks like this:
{
"dataSourceId": "gbq",
"qName": "Google_BigQuery",
"space": "<space_name>",
"connectionProperties": {
"OAuthMechanism":"0",
"KeyFilePath": [
{
"name": "keyfile.json",
"value": "<base64-encoded-json-file>"
}
],
"Email": "<service account email, same as in Json-file>",
