How to use API with data post in Power bi

[Shellysethi]

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

[v-yanjiang-msft]

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

[v-yanjiang-msft]

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.