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=[...
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?
