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?
