URL safe characters

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

Character	Code
!	%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