Forum Discussion
Stop Web.Contents Query Parameter from Encoding
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!
5 Replies
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?
Same here. Any suggestions?
