Help with BigQuery API skill and OAuth credential

[bclayton1896]

​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
------------------------------

[ewilson]

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
------------------------------