Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |