Add a body to web.contents

[-jmdaher-]

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"="application/json", #"X-User-Email"="xxxxxx", #"X-User-Token"="xxxxxx"]])),

in
Source

The body in postman is:

{

    "fromDate" : "1/1/2022",

    "toDate" : "12/11/2022"

}

Any suggestions? 

Thanks!

[v-yalanwu-msft]

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.

[-jmdaher-]

I tried with this and I didn´t have a result:

This is the error:

DataSource.Error: Web.Contents failed to get contents from 'https://pos.linisco.com.ar/sale_orders' (404): Not Found
Details:
DataSourceKind=Web
DataSourcePath=https://pos.linisco.com.ar/sale_orders
Url=https://pos.linisco.com.ar/sale_orders

I don´t know how to resolve it.