Forum Discussion

jasonfordx's avatar
jasonfordx
Helper II
8 years ago
Solved

Connect API with Header ApiKeyName not going through

Dear community,   Im trying to connect my Excel/PowerBI and is not working. I read the entire forum and I could not reach the right answer for it.   My provider gave me the following instructions...
Need Help
  • Michal_cwiok's avatar
    Michal_cwiok
    8 years ago

    Perhaps this might work too:

     

Michal_cwiok's avatar
Michal_cwiok
Resolver II
8 years ago

I am not an expert, but my quick research suggests that the header name should be "X-API-KEY" and its value being API-KEY. Now you have header name "Authorization" and value "X-API-KEY:YOUR_KEY".

 

Try something like this

let
 
Http_query = Json.Document(Web.Contents("<Your URL>", 
          [Headers=
                  [X-AP-KEY ="<Your API KEY>"]
           ]
           )),
Data = Http_query{0}
 
in 
 
   Data

Let me know, if it works. I think this is the right direction.

jasonfordx's avatar
jasonfordx
Helper II
8 years ago

Dear Mr. Michal, good morning, how are you?

 

Tried that too. I mean, I think that you suggested to type in the header field: X-API-KEY. Im saying this because reading your code you typed: X-AP-KEY. I ve tried the first one.

 

EDIT: got the same result using your 2nd suggestion.

 

Look what I got: