Stop Web.Contents Query Parameter from Encoding

[Anonymous]

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!

[iBusinessBI]

Same here. Any suggestions?

[amitchandak]

@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/

[Anonymous]

@amitchandak 

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.

[iBusinessBI]

Any solution?

[Greg_Deckler]

@ImkeF @edhans