Forum Discussion

Vankod's avatar
Vankod
Frequent Visitor
9 years ago
Solved

How to add body into Web.Contents()?

I need to add Body

{
   "method": "get",
   "params": {
      "SelectionCriteria": {},
      "FieldNames": ["Id", "Name"]
   }
}

in Web.Contents() query.

 

I can not understand how to do it.
Is this even possible in Web.Contents()?

_________________________________________

 

Current code:

let
    Source = Json.Document(Web.Contents("https://api-sandbox.direct.yandex.com/json/v5/campaigns", [Headers=[Authorization="Bearer AQAAAAANlKwBAAQQn4WfgbuD9xxxx"]]))
in
    Source
Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Vankod,

    What requirement do you want to achieve by adding the body?


    Add another blank query in Query Editor, then paste the following code in Advanced Editor, does it return your expected result?

    let
Source = Json.Document("[
{
   ""method"": ""get"",
   ""params"": {
      ""SelectionCriteria"": {},
      ""FieldNames"": [""Id"", ""Name""]
   }
}]")
in
    Source

     

     

    Thanks,
    Lydia Zhang

    • Vankod's avatar
      Vankod
      Frequent Visitor
      9 years ago

      Thanks, Anonymous!
      It's return JSON body content. This is useful step
      But how to use it in Web.Contents() query?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your post .

    I am trying to do a similar connection to an url, however I don’t see the table with the information that I need.
    This is the code I am using:

    let
    url = “https://urladdress”,
    body = “{ “”statisticType””: “”[“”CMD_Stock””]””, “”startDate””: “”2020-04-07″” , “”endDate””: “”2020-04-07″” }”,
    Source = Json.Document(Web.Contents(url,[Headers = [#”Content-Type”=”application/json”], Content = Text.ToBinary(body) ] ))
    in
    Source

    I need to obtain the following structure in Power BI (a table with three columns):

    statisticType startDate endDate
    CMD_Stock 07/04/2020 07/04/2020
    CMD_Stock 07/04/2020 07/04/2020
    CMD_Stock 07/04/2020 07/04/2020

     

    Can you help me? Thanks mdsr.