Forum Discussion
Shellysethi
3 years agoFrequent Visitor
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 t...
v-yanjiang-msft
3 years agoCommunity Support
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.