How to Access Tomcat Server with URL Address Encoding


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


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


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


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.