Parse host from REDCap API URL for URI construction
Add tests for REDCap backends

The MySQL version will be skipped unless a host is provided via the
REDCAP_MYSQL_HOST environment variable.