api end point to retrieve list of connections

This can extend the WebView base class and the sestup/teardown should be ok automatically. 

We do need to make sure that the teardown helper empty_db() deletes all records from the connection tables.