Forum Discussion

Tess's avatar
Tess
Frequent Visitor
1 year ago
Solved

Send a POST request with -d in Power Query

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?