Send a POST request with -d in Power Query

[Tess]

Hi community,

I am trying to build a request in power query with this POST request

curl https://connect.squareup.com/v2/orders/search \
  -X POST \
  -H 'Square-Version: 2024-10-17' \
  -H 'Authorization: Bearer xxxxxxxxxxxxx' \
  -H 'Content-Type: application/json' \
  -d '{
    "location_ids": [
      "xxxxxxxxxxx"
    ]
  }'

 I am struggling to construct a proper query in ower Query. The following M code returns an error MSG DataSource.Error: Web.Contents failed to get contents from 'https://connect.squareup.com/v2/orders/search ' (400): Bad Request.
------------------------------------

let
url="https://connect.squareup.com/v2/orders/search",
body = "{ ""location_ids"": ""xxxxxxxxxxx""}",
parsed_json = Json.Document(body),
buildQueryString = Uri.BuildQueryString(parsed_json),
headers=[
Authorization="Bearer xxxxxxxxxxxxx",
#"Content-Type"="application/json"],
Source = Json.Document(Web.Contents(url,[Headers = headers, Content = Text.ToBinary(buildQueryString) ] ))
in
Source

-----------------------
Can anyone help me out?

[lbendlin · Accepted solution]

Please follow the documentation. Use Json.FromValue. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2