3. party REST API with header request

[DesrAw]

Hi everyone

I'm not the hardest coder out there, but normally I can youtube my way through. NOT THIS TIME 😞

I'm trying to access some ticker data from a REST API in json format, with the following string in advanced editor.

= Json.Document(Web.Contents("https://api.coinigy.com/api/v1/data",
     [
         Headers = [#"Content-Type"="application/json",#"X-API-KEY"="6b796808aeddf74791fc85ce03aa276a",#"X-API-SECRET"="5de422bc18e0987fa26d8227a7d442d1"]
     ]
 ))

without the header part I get a auth error. With the header part a get a 404 error.

Any suggetions is MUCH appreciated!

[v-ljerr-msft]

Hi @DesrAw,

Your query looks fine. But I keep getting "Invalid API Key" error in my test.

Could you try the query below, then supply an “Api Key” via the credential UI to see if it works? 

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

Regards

[DesrAw]

Hi @v-ljerr-msft

Thank for your answer. Much appreciated!

Yes I altered the API information, because they would give access to sensitive data. 😞

The credential UI will ask for a "username" and "password", correct? The API require "X-API-KEY" and "X-API-SECRET". Will that not be a problem?

[pedrams]

Hi @DesrAw,

have you found a solution to that problem? I am having trouble with the exact same problem.

Best,

Pedram