Forum Discussion

asherbowden's avatar
asherbowden
Frequent Visitor
4 years ago
Solved

Query parameter's with special characters

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!

 

 

  • 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.

4 Replies

  • 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's avatar
      gingercat123
      Frequent Visitor

      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's avatar
        ecalzavara
        Advocate II
        Hey mate, did you manage to solve this? I too have special characters "%" in the name I am trying to combine.