Query parameter's with special characters

[asherbowden]

Hi there,

I am using dataflows calling a Web API.

I am using Web.Contents with the RelativePath, Query arguments in order to ensure I can schedule a refresh with the query.

My particular URL I am calling has a special character in the Query Parameter.

E.g. www.XXX.com/YYY/?example-parameter=abc

Note the dash in the middle. This translates to Mcode that looks like this.

Web.Contents("www.XXX.com/",

[RelativePath = "YYY",  Query = [example-parameter = "abc"]])

I have seen blog posts on how to address special characters in the argument (in the above case "abc") using the URI functions to encode.

https://docs.microsoft.com/en-us/powerquery-m/uri-functions

HOWEVER, I cannot seem to encode the actual Query parameter.

It is key to note that it must be able to dynamcially refresh in order to schedule a refresh for the dataflow.

Please let me know if someone has found a solution to this!

[asherbowden]

Fantastic, this worked well. Appreciate it Alexis.

[AlexisOlson · Accepted solution]

Try this:

Query = [#"example-parameter" = "abc"]

A hyphen isn't a character that needs to be encoded for a URL, but M needs some help to know that "example" and "parameter" belong together.

[gingercat123]

Hi @AlexisOlson ,

 please could you help me, how do i replace %

date_from="2021-06-01%2012:01:01",
date_to="2021-06-30%2012:01:01",

i get this &date_from=2021-06-01%252012%3A01%3A01&date_to=2021-06-30%252012%3A01%3A01&

[ecalzavara]

Hey mate, did you manage to solve this? I too have special characters "%" in the name I am trying to combine.