Forum Discussion

-jmdaher-'s avatar
-jmdaher-
Regular Visitor
3 years ago

Add a body to web.contents

Hello! I want to add a body to this code:    let url = "https://pos.linisco.com.ar/sale_orders", Source = Json.Document(Web.Contents(url, [Headers = [#"Content-Type"="application/json", #"Accept"...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, -jmdaher- ;

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

let
	content = "{
		""from date"": ""1/1/2022"",
		   ""to date"": ""12/11/2022"",
	}",

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


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I receive an error:

DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously.