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:

     

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi jasonfordx,

 

From the error message, it points that the provided credential is invalid. You may need to check the API key to make sure it have access to source data and you have typed with correct key.

 

Regards,

Yuliana Gu

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

    • Michal_cwiok's avatar
      Michal_cwiok
      Resolver II
      8 years ago

      Perhaps this might work too:

       

      • jasonfordx's avatar
        jasonfordx
        Helper II
        8 years ago

        A new message because I want to clarify something here. IT WORKED Michal!!!. One thing only, its case sensitive. So for some reason, Ive tried x-api-key and DID WORK instead of X-API-KEY. Thank you God and this community.

         

        Ty Michael.

         

        Have a wonderful week everyone :).

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

    • Markus2781's avatar
      Markus2781
      New Member
      4 years ago

      Perfect, thank you!

  • jasonfordx's avatar
    jasonfordx
    Helper II
    8 years ago

    Dear Ms. Gu, good morning, how are you?

     

    My private API key works using curl for Windows. This is why I am comfortable telling you that the private key is working and valid. But I had the same question before. I was trying to reach their data using Excel for the first time and not being able to access. So I was like: Problably I need to talk with them because may be my key. But using Curl worked, so I was like, .... may be a synthax problem hehehehe.

     

    Ty for your time and support.