API Query with two expected date parameter in request body

[TCRUZ_MSFT]

Hi experts,

I'm quite new with API requests done via power query. I am working on a request call but this one involves a body similar to this:

body =

"{

  "loadDate": [

    {

"start": "2025-01-16T00:00:00.001Z",

"end": "2025-01-16T23:59:59.999Z"

    }

  ],

  "orderBy": "loadDate"

},

webdata = Json.Document(Web.Contents(url,
[
Headers = header,
Content = Text.ToBinary(body)
]))

Can you help me with the right syntax in power query? Many thanks

[ZhangKun · Accepted solution]

Double quotes in the text need to be escaped, using two " instead.

body =
"{
  ""loadDate"": [
    {
""start"": ""2025-01-16T00:00:00.001Z"",
""end"": ""2025-01-16T23:59:59.999Z""
    }
  ],
  ""orderBy"": ""loadDate""
}",
webdata = Json.Document(Web.Contents(url,
[
Headers = header,
Content = Text.ToBinary(body)
]))

[TCRUZ_MSFT]

That worked! Thanks a lot