Forum Discussion
Anonymous
4 years agoNot applicable
Convert Curl to Web.Contents in Power Query
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
4 Replies
- lbendlinSuper User
HttpRequest = [RelativePath = "hx/api/v3/token", ApiKeyName = GetAPIKeyName, Headers = [Accept = "application/json"]],- AnonymousNot applicable
Yes, I tried that one also but it looks that problem is in passing
"http://gate.zrh.XXX.com:8080"
through Web.Contents function.
- lbendlinSuper User
Web.Contents does not handle redirects very well. Have a look at Web.BrowserContents.