It appears that you are unable to use PowerQuery in a Scenario where you need:
- GET HTTP Method
- Header API Key
- Content Body
let
Url="url",
header = [#"x-api-key"="xxxx",#"Content-Type"= "application/json"],
Query="querystring",
body=[encoded_query=Query],
response = Web.Contents(Url, [Headers=header, Content=Json.FromValue(body)]),
Source = Json.Document(response)
in Source
^This design with Anonymous credential returns an "Expression.Error: Access to the resource is forbidden." indicating it does not read the header.
let
Url="url",
header = [#"x-api-key"="xxxx",#"Content-Type"= "application/json"],
Query="querystring",
apiKeyName="x-api-key",
body=[encoded_query=Query],
response = Web.Contents(Url, [Headers=header, ApiKeyName=apiKeyName, Content=Json.FromValue(body)]),
Source = Json.Document(response)
in Source
^This design with Web API credential returns an "DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously. Details: DataSourceKind=Web, DataSourcePath=url" indicating I cannot supply a Web API Credential with a Content body.
let
Url="url",
header = [#"x-api-key"="xxxx", #"Content-Type"= "application/json"],
Query="querystring",
body=[encoded_query=Query],
response = WebAction.Request(WebMethod.Get, Url, [Headers=header, Content=Json.FromValue(body)]),
Source = Json.Document(response)
in Source
^This design with any credential returns an "Expression.Error: We haven't been given permission to perform actions against this resource." indicating WebAction.Request does not force the method to GET.
This combination is the only valid scenario to request this API.
Any thoughts?
