How to Access Tomcat Server with URL Address Encoding

Goal

Access an Apache Tomcat Application Server and gather via special URLs the from there provided JSON output. 

Learn  

Initial Error message

If I setup an Import Job with a Connection "Custom protocol http/https" and provide the correct URL, I receive the error message

Can not parse input: Server returned HTTP response code: 500 for URL: http://api.<servername>.com:<port>/...

Cause

As Datameer is a Java application it will decode the provided string (E.g., %27MISSISSIPAIN%27 into 'MISSISSIPAIN') instead of leaving it as given.

Solution

It will be necessary to escape the characters within the URL by \, so it looks like \%27MISSISSIPAIN\%27

 

Additional Information

Check Apache Tomcat documentation e.g. for URIEncoding - character encoding used to decode the URI bytes, after %xx decoding the URL.