Forum Discussion

TCRUZ_MSFT's avatar
TCRUZ_MSFT
Frequent Visitor
1 year ago
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-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

 

Need Help
  • ZhangKun's avatar
    ZhangKun
    1 year ago

    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)
]))

     

2 Replies

  • ZhangKun's avatar
    ZhangKun
    Icon for Super User rankSuper User
    1 year ago

    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)
]))