How can I constantly hit a http end point in a remote server to collect useful metrics and then import it to splunk hourly for example and use it for useful visualisations?
Check out the REST API Modular Input app (https://splunkbase.splunk.com/app/1546).
Or write your own script and make a scripted input out of it.