Help with BigQuery API skill and OAuth credential

bclayton1896 — Fri, 30 Oct 2020 16:24:00 GMT

So I have a need to user BigQuery to retrieve some results, operationally I think I can make this happen. My question is how do I set up the OAuth credential that was in the skill package correctly? I received a json key that should be holding all the relevant information, but I keep getting a 403 error and a permission denied.

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 403
HTTP Response Content: {
"error": {
    "code": 403,
    "message": "Request had insufficient authentication scopes.",
    "errors": [
      {
        "message": "Insufficient Permission",
        "domain": "global",
        "reason": "insufficientPermissions"
      }
    ],
    "status": "PERMISSION_DENIED"
}
}

My colleague who is working the BigQuery side of things has assured me that the account has the permissions to run the query, but this looks like it is not the case to me. Any thoughts?

------------------------------
Brian Clayton
Lead Developer - C#/Blue Prism RPA
The Auto Club Group
America/Detroit
------------------------------

RE: Help with BigQuery API skill and OAuth credential

ewilson — Mon, 02 Nov 2020 18:12:00 GMT

Hi @Brian Clayton,

When you say you received a "json key" are you talking about an API key? If so, that's a different authentication credential type than the OAuth JWT type currently configured in the BigQuery skill. You can always change the definition of the underlying Web API Service definition to a different credential type. Blue Prism will display a warning when you try to open the Web API definition, but you can accept it and continue.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

topic Help with BigQuery API skill and OAuth credential in Digital Exchange

Help with BigQuery API skill and OAuth credential

RE: Help with BigQuery API skill and OAuth credential