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

 

 

  • NateDogg's avatar
    NateDogg
    New Member
    4 years ago

    I wanted to post a more complete/cleaner version of the above solution that contains multiple headers and shows how to convert the body to binary data for POST operations: 

     

    let
    url = "https://api.somevendor.com/api/",
    headers = [#"Content-Type" = "application/x-www-form-urlencoded", #"Accept" = "application/json"],
    postData = "Any sort of text data you want to post to the API",
    response = Web.Contents(
        url,
        [
            Headers = headers,
            Content = Text.ToBinary(postData)
        ]
    ),
    jsonResponse = Json.Document(response)
in
    jsonResponse

     

  • Markzolotoy's avatar
    Markzolotoy
    Impactful Individual
    5 years ago

    What  body = "The POST method body here", is for?

     

    Thanks

  • 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