Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
let
// POST request to fetch login key
url = "https://bam.htasoftware.eu/pcuitvaart/api/apilogin",
body = "{ ""Username"": ""XXXXXXX"", ""Password"": ""XXXXXXXXX""}",
Parsed_Json = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_Json),
token = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content = Text.ToBinary(BuildQueryString) ] )),
bearer = "bearer ",
key = bearer & token,
// GET request to fetch data
adress = "https://bam.htasoftware.eu/pcuitvaart/api/queryapi/getqueryresult"
in
Web.Contents(adress,[Query=[ #"query" = "Test"], Headers=[ #"Authorization" = key]])
In Power Query I wrote a script to send a POST request to fetch a key and a GET request to fetch data.
If I return the key, copy and paste it in an online API tester, everything works fine. However if I run the query I get an error:
(500): Internal Server Error
Any suggestions?
@JWvanHolst , refer if this solution can help
https://community.powerbi.com/t5/Desktop/GET-Request-o-Power-BI/td-p/935861
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |