Forum Discussion
Solved
How to make a GET or POST request in Power Query (public data)
Hello friends, I am trying to get info into Power BI from a web service that gives different possibilities for the request, SOAP GET and POST: https://ovc.catastro.meh.es/ovcservweb/OVCSWLocaliza...
GET requests are done by calling Web.Contents without a Content parameter, POST requests are done by calling Web.Contents with the parameter.
GET:
let URL = "http://xxx/tstat", headers = [#"Content-Type"="application/json"], web = Web.Contents(URL, [ Headers = headers, ManualStatusHandling = {404, 400}]), result = Json.Document(web), ...POST:
let URL = "http://xxx/tstat", headers = [#"Content-Type"="application/json"], data = Json.FromValue([tmode = 2,t_cool = Setpoint,hold = 0]), web = Web.Contents(URL, [ Content = data, Headers = headers, ManualStatusHandling = {404, 400}]), result = Json.Document(web), ...
lbendlin
Super User
Super UserGET requests are done by calling Web.Contents without a Content parameter, POST requests are done by calling Web.Contents with the parameter.
GET:
let
URL = "http://xxx/tstat",
headers = [#"Content-Type"="application/json"],
web = Web.Contents(URL, [ Headers = headers, ManualStatusHandling = {404, 400}]),
result = Json.Document(web),
...
POST:
let
URL = "http://xxx/tstat",
headers = [#"Content-Type"="application/json"],
data = Json.FromValue([tmode = 2,t_cool = Setpoint,hold = 0]),
web = Web.Contents(URL, [ Content = data, Headers = headers, ManualStatusHandling = {404, 400}]),
result = Json.Document(web),
...
Also see https://community.fabric.microsoft.com/t5/Desktop/How-to-run-POST-request-in-M/m-p/457138 for another code adding the Content with empty parameter to Web.Contents call to force Power BI top make a POST request
Content=Text.ToBinary("")
This is not working for me. I am trying run a POST API with no paramenters in. Please help if there is nay other solutions.