Retrieve a connection by ID

Returns the details of a specific connection identified by its ID.