Re: Trying to recreate POST request in PowerQuery

KoenV3 · ‎09-25-2023

Hi All,

Hope you can help me with the following. I've got an Endpoint that I'm trying to get data from but the only allowed method is POST on this endpoint. So I'm trying to find a way to get the data in PowerBI.
I've got the post working in Postman:

curl --location '{BaseURL goes here}/Appointments/Get' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {Token goes here}' \
--data '{
  "StartDate": "2020-09-25",
  "EndDate": "2028-09-25",
  "Resources": [
46
  ]
}'

But if I try to rebuild this in power query it fails. I'm using following Query:

let

   URL = Text.Combine({baseURL,"/Appointments/Get"}),
   body = "{
  ""StartDate"": ""2020-09-25"",
  ""EndDate"": ""2028-09-25"",
  ""Resources"": ""[""
     46
     ""]""
}",
   Source=Json.Document(Web.Contents(URL,
   [
       Headers = [#"Authorizaion"="Bearer "&token,
       #"Content-Type"="application/json"],
       Content=Text.ToBinary(body)
]
))
in
Source

I keep getting a (500) Internal Server Error message. Any thoughts?