Forum Discussion

KoenV3's avatar
KoenV3
Regular Visitor
2 years ago

Trying to recreate POST request in PowerQuery

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? 



Need Help