Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowI am trying to get data forma an API with <post method from Power query but I cannot do it, and I don't find the error...here is my code:
There is some parts commented because I think the problem is how I send parameters...
La descripción de la API es la siguiente:
I hope someone can help me!!
THANK YOU
Yes. You should try running the following two examples (check the "json" fields in the result to see if your program is correct). I believe you will truly understand how to post data.
let
resp = Web.Contents(
"https://httpbin.org",
[
RelativePath = "post",
Content = Json.FromValue([A = 1, B = "2025/01/02"])
]
),
data = Json.Document(resp)
in
data
let
resp = Web.Contents(
"https://httpbin.org",
[
RelativePath = "post",
Content = Text.ToBinary("{""A"": 1, ""B"": ""2025/01/02""}", TextEncoding.Utf8)
]
),
data = Json.Document(resp)
in
data
Please follow the documentation. Use a body payload. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
30 | |
23 | |
16 | |
15 | |
11 |