Forum Discussion

abedkhooli's avatar
abedkhooli
Frequent Visitor
9 years ago

Get data from web error: A web API key can only be specified when a web API key name is provided

I have PBI desktop Version: 2.40.4554.463 64-bit (October, 2016) and I am trying to get web data from opensensors using an API with a key. I tried several combinations in the header (one is shown bel...
Need Help
Show and Tell
mllopis's avatar
mllopis
Community Admin
9 years ago

Hi all,

 

In order to be able to supply an “Api Key” via the credential UI, the user’s M has to look like this:

 

Web.Contents(URL, [ApiKeyName="mykey"])

 

If the user enters a key of SECRET, this will produce a final URL of URL?mykey=SECRET

 

NOTE: this is not supported in cloud refresh.

 

With respect to other messages on the thread,

  1. There’s no way to set arbitrary HTTP request headers through the credential system.
  2. There’s no way to get arbitrary HTTP response headers

 

Hope this helps.

Sokon's avatar
Sokon
Advocate V
9 years ago

Obviously, there was no OData feed-Connector available in earlier versions of PBID, right?

Because now, there is one - which doesn't mean much, because the error stays the same:

I would expect the build-in editor is able to compose correct API-Queries. If so, what do I do wrong? (Not many options here, right)