API post data source params

[lbonillab]

I need to import data from API Post method, with body and I can't do it, could you help me?

let
Origen = Json.Document(Web.Contents("https://hst-api.wialon.com/wialon/ajax.html?svc=token/login", [Headers=[#"Content-Type"="application/x-www-form-urlencoded"]], [params={"token":"71406a685ac5fa696c7b3daefb1343b9FE88C2C627E3F9EF6A68E2FD49EA0836304BEA87","operateAs":"PB-Int"}],
#"Convertida en tabla" = Table.FromRecords({Origen}),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Convertida en tabla",{{"error", Int64.Type}, {"reason", type text}})
in
#"Tipo cambiado"

[V-pazhen-msft · Accepted solution]

@lbonillab 
To add data source parameter in your URL, please check the following similar threads.

http://community.powerbi.com/t5/Desktop/Dynamic-connection-to-Web-URL/m-p/346607#M155589
https://community.powerbi.com/t5/Integrations-with-Files-and/Parameters-for-JSON-API-data-Maintain-Q...

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbonillab]

And if I do the same query in "Rest Client", if I have the expected results.

[Ehren]

The M you shared above results in a syntax error (the json-style name/value pairs are not valid M).

[lbonillab]

The body of the query does not give me the expected results.

The error message is: "wrong params"

[Ehren]

Hi there. Can you clarify what isn't working?