Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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
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?
Hi @DesrAw,
have you found a solution to that problem? I am having trouble with the exact same problem.
Best,
Pedram
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |