URL Safe Characters
    • Dark
      Light

    URL Safe Characters

    • Dark
      Light

    Article Summary

    Overview

    In certain Matillion ETL components, a property may require a URL to direct toward a resource. In many cases, it is possible to include a username and password in the URL that contain special characters not suitable for use in a URL, resulting in errors when running the component.

    It is advised to use the Username and Password fields in such cases. However if this is undesirable, it is still possible to use the URL property so long as special characters are converted to URL-safe codes (also known as 'Percent encoding' or 'URL encoding').

    It is also required that you use URL encoded strings for resource names (such as Jobs or Projects with spaces in their names) when using the Matillion API.

     

    List URL-Safe Codes

    CharacterCode
    !%21
    "%22
    #%23
    $%24
    %%25
    &%26
    '%27
    (%28
    )%29
    *%2A
    +%2B
    ,%2C
    -%2D
    .%2E
    /%2F
    :%3A
    ;%3B
    <%3C
    =%3D
    >%3E
    ?%3F
    @%40
    [%5B
    \\\\%5C
    ]%5D
    ^%5E
    _%5F
    `%60
    {%7B
    |%7C
    }%7D
    ~%7E
     

    Example

    The string:

    Use * for wildcard!

    Becomes:

    Use %2A for wildcard %21

    And similarly, a URL with logins such as:

    http://admin:pass!w\\\\symbols@amazonservice.com/index

    Should be input as:

    http://admin:pass%21w%5Csymbols@amazonservice.com/index