Get subscription details for a given subscription id