Forum Discussion

TuanPham1999's avatar
TuanPham1999
Frequent Visitor
7 years ago
Solved

Pull data from API using POST method in Power BI

Hi all, I'm a fresher in Power BI Desktop. my mission is extract data from given credentials include: ClientID, Password and Url. The credentials must be Base64 encoded for use in the POST /oauth2/to...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I found it not so easy to get data via POST so I am pasting here what I did in case this helps someone else in the future.

 

I created the following blank query:

 

= let
   body = "The POST method body here",
   Data= Web.Contents("https://yourusrlhere",[Content=Text.ToBinary(body),Headers=[#"Content- 
   Type"="application/json"]]),
   DataRecord = Json.Document(Data),
   Source=DataRecord 
in
   Source

 

 

i4's avatar
i4
Frequent Visitor
2 years ago

How can I insert a variable (dateTo) instead of the date, i.e. 2024-12-31, into parameter5?

 

let
   dateTo= DateTime.LocalNow(),
   body = "{""parameter1"":""xxx"",""parameter2"":""xxx"",""parameter3"":""xxx"",""parameter4"":""xxx"",""parameter5"":""2024-12-31""}",
   Data= Web.Contents("https://xxx",[Content=Text.ToBinary(body),Headers=[#"Content-Type"="application/json"]]),
   DataRecord = Json.Document(Data),
   Source=DataRecord
in
   Source