How to add body into Web.Contents()?

[Vankod]

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

[Anonymous]

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.

[v-yuezhe-msft]

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]

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

[Vankod · Accepted solution]

Done!

Solution from here: https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics...

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

	Source = Json.Document(Web.Contents("https://api-sandbox.direct.yandex.com/json/v5/campaigns", [Headers=[Authorization="Bearer AQAAAAANlKwBAAQQn4Wfgbxxxxxxxxxx"], Content=Text.ToBinary(content)]))
in
    Source

[Anonymous]

@VankodLovely, had wasted lot of time in trying to fect something, your reply helped me resolve it 🙂