Forum Discussion

Shellysethi's avatar
Shellysethi
Frequent Visitor
3 years ago

How to use API with data post in Power bi

Hello,

 

I have an API with POST menthod and want to extract json in BI.Can anybody help as I am new to M code.

 

There is no authorization username and password on the link.Just need to access the link and get the data.

 

Tried below but did not work.

 

let
url = "https://XXXXXX",

Source = Json.Document(Web.Contents(url,[
Headers =[#"Content-Type"="application/json", #"Authorization" = "basic "]
]
))

in
"Source"

 

TIA

Shelly

Need Help

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi Shellysethi ,

    Please try like this:

    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

     

    Or refer to the following post.

    Connect to a Web Service sending parameters - Microsoft Power BI Community

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi Shellysethi ,

    Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

     

    Best Regards,
    Community Support Team _ kalyj