Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm attempting to submit the following in Power Query:
Web.Contents(
www.myurl.com/stuff.json
, [
Query = [
created = "[Select+Date+Range]&created_custom_gte=[" & EarlierstDate & "T00:00:00.000000+0000]"
]
]
)
However, when it actually makes the web call it's encoding the "created" parameter which is causing the API call to fail.
Expected: www.myurl.com/stuff.json?created=[Select+Date+Range]%26created_custom_gte=[2020-05-01T00:00:00.000000+0000]
Actual: www.myurl.com/stuff.json?%5BSelect%2BDate%2BRange%5D%26created_custom_gte%3D%5B2020-05-01T00%3A00%3A00.000000%2B0000%5D
Thanks!
Same here. Any suggestions?
@Anonymous , Looking at how url should go I think it should be like
Web.Contents(
"www.myurl.com/stuff.json",
, [
Query = [
created = "[Select+Date+Range]&created_custom_gte=[" & EarlierstDate & "T00:00:00.000000+0000]"
]
]
)
There is a good reference on dynamic URL here -https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
Not sure if I'm missing something... That looks like the exact code I put in the original post?
As stated, the query string encodes the value in the key value pair which causes the API request to fail.
Any solution?
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |