Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a REST API that returns JSON formatted data.
Here's what's in Power Query Advanced Editor:
let
bodytext =
"{""StartDate"":""2018-01-01"",
""EndDate"":""2019-12-31""}",
url = "<removed>",
body = Json.FromValue(bodytext),
Source =
Json.Document(
(Web.Contents
(url
, [Headers=
[#"Content-Type"="application/json"
,Authorization="aaaaa"
, Key="1234"
, Value="1234"],
Content = body])))
in
Source
I'm getting a "(405): Method Not Allowed" back. I believe it's at the Content = body line.
Everything is working in PostMan. Authorization, Key, Value all are parameters, and I'm passing StartDate and EndDate in the body.
Appreciate any input, I've got about 5 hours into debugging... first time trying this here!
Solved! Go to Solution.
If you include the content parameter to web.contents, I believe it forces an HTTP POST method. Is this what you are expecting? Also, in my past experience I've always used Text.ToBinary where you are using Json.FromValue
If you include the content parameter to web.contents, I believe it forces an HTTP POST method. Is this what you are expecting? Also, in my past experience I've always used Text.ToBinary where you are using Json.FromValue
I Need To connect an API on power bi with the TOKEN and the Headers, someone can help me?
I think you're right about the post, will keep trying to debug it. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |