Trying to recreate POST request in PowerQuery

[KoenV3]

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? 

[lbendlin]

Try using Json.FromValue

Web.Contents - PowerQuery M | Microsoft Learn