Forum Discussion
Solved
API Query with two expected date parameter in request body
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-...
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) ]))
ZhangKun
Super User
Super UserDouble 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)
]))
That worked! Thanks a lot
