Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not 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. 

      • lbendlin's avatar
        lbendlin
        Super User

        Web.Contents does not handle redirects very well. Have a look at Web.BrowserContents.