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 ...
Need Help
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?

    • Vankod's avatar
      Vankod
      Frequent Visitor
      9 years ago

      Done!

       

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

       

      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's avatar
        Anonymous
        Not applicable
        9 years ago

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