Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
I need help converting curl into Power Query. Now I have curl expression that works (tested in Postman) but I can't make it work in Power Query. I'm doing auth by ApiKey named x-fireeye-api-key. APIKeyName needs to be passed through header. So far I tried through Web.Contents. Advice pls, need push to right direction. Thanks in advance
curl -k "https://hexsks639-hx-webui-1.hex03.helix.apps.fireeye.com/hx/api/v3/token" -X "http://gate.zrh.XXX.com:8080" -X "GET" -H "Accept: application/json" -H "x-fireeye-api-key:XYZ" -i
What I have so far
let
GetAPIKeyName = "x-fireeye-api-key",
HttpRequest = [#"RelativePath" = "hx/api/v3/token", #"ApiKeyName" = GetAPIKeyName, Headers = [#"Accept" = "application/json"]],
Result = Json.Document(Web.Contents("https://gate.zrh.XXX.com:8080/hexsks639-hx-webui-1.hex03.helix.apps.fireeye.com/", HttpRequest ))
in Result
HttpRequest = [RelativePath = "hx/api/v3/token", ApiKeyName = GetAPIKeyName, Headers = [Accept = "application/json"]],
Yes, I tried that one also but it looks that problem is in passing
"http://gate.zrh.XXX.com:8080"
through Web.Contents function.
Web.Contents does not handle redirects very well. Have a look at Web.BrowserContents.
Yes, that will not work for what I have. Thanks for trying to help
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |