Forum Discussion

steve1024's avatar
steve1024
Frequent Visitor
3 years ago
Solved

get data from API with POST request and JSON query

Hi, I am trying to connect to the an API with a blank query an am struggeling with the syntax   API instructions:   How do I write this query properly in PBI? I have tested mulitple things ...
Need Help
  • steve1024's avatar
    steve1024
    3 years ago

    thanks Daryl for your help. After some trial and error I found out that the instructions on the API was stated as ...format = ''px" , but this format (not sure what it is even) was not interpretable. Changeing this to format = ''json'' did the trick..

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi steve1024 - it can sometimes help to split M steps up so that you have more visibility.  Here is your original function:

let
    header = [#"Content-Type"="application/json"],
    body = Json.FromValue([query = {}, response = [format = {"px"} ]]),
    Preview = Text.FromBinary( Body , BinaryEncoding.Base64 ),
    Source = Web.Contents(
        "http://blablabla.px",
        [
            Headers = header,
            Content = body
        ]
    ),
    Json = Json.Document( Source )
in
    Json

 
This generate the following Preview of the JSON.

If this is formatted: 

{ 
   "query":[],
   "response": {"format":["px"]}
}

It does not quite match the above.   I have removed the {} around px.  please test and trouble-shoot this way.

let
    header = [#"Content-Type"="application/json"],
    body = Json.FromValue([query = {}, response = [format = "px"]]),
    Preview = Text.FromBinary( Body , BinaryEncoding.Base64 ),
    Source = Web.Contents(
        "http://blablabla.px",
        [
            Headers = header,
            Content = body
        ]
    ),
    Json = Json.Document( Source )
in
    Json