Forum Discussion

gilbertendaya's avatar
gilbertendaya
Helper IV
6 years ago
Solved

Error in getting POST request in an API

Hi,   Need your help with my issue in Power BI. Here is the M-Script   let url = URL, body = "{""limit"": -1,""sort"": {""option"": ""ASC"",""field"": [""FlightDate""},""parameters"": [{}],""r...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi gilbertendaya 

    You could simply using different code.

    This first example you've posted contained wrong brackets.

    Why is that?

    Could it be that JSON you've been using in Postman has different nesting structure?

    Must your -1 be a text instead of a number?

     

    Honestly, I've been there a couple of times to recognize that a simple typo is throwing things off.
    Very had to believe that Power Query is the issue here.

     

gilbertendaya's avatar
gilbertendaya
Helper IV
6 years ago

Hi ImkeF 

 

Sorry I'm not sure what you mean by final URL? 😞

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi gilbertendaya 

if you're body shall contain the full JSON record that you've built, then you should reference that directly instead of trying to convert it to a string in step "BuildQueryString". (You'd probably have to convert the -1 back to a number then)

 

Something like this:

 

let
url = URL,
body = "{#(cr)#(lf)   ""limit"":-1,#(cr)#(lf)   ""sort"":{#(cr)#(lf)      ""option"":""ASC"",#(cr)#(lf)      ""field"":[#(cr)#(lf)         ""FlightDate""#(cr)#(lf)      ],#(cr)#(lf)      ""parameters"":[#(cr)#(lf)         {#(cr)#(lf)#(cr)#(lf)         }#(cr)#(lf)      ],#(cr)#(lf)      ""range"":[#(cr)#(lf)         {#(cr)#(lf)            ""FlightDate"":{#(cr)#(lf)               ""from"":""02/14/2020 14:02"",#(cr)#(lf)               ""to"":""02/18/2020 00:02""#(cr)#(lf)            }#(cr)#(lf)         }#(cr)#(lf)      ]#(cr)#(lf)   }}",
Parsed_JSON = Json.Document(body),
Source = Json.Document(Web.Contents(url, [Headers=[#"Content-Type"="application/json"],Content = Parsed_JSON]))
in
Source