I have a parametric search dashboard where users are able to select a handful of KPI's on European football teams, like kit colour, # Championships won, # times relegated. This part is working really well, however I now would like to use the teams ID's in the set (for Barcelona, Liverpool, Crystal Palace etc) to make a call to my football stats web service (API) and load lots of data into an HTML frame or new browser. There are a couple of reason I'd like to do this,
1. My web service returns lots of player photos and I think it's simpler to display these in HTML than try and link them a shapes in Tableau
2. My web service will return lots of data on any team, I want to keep the Tableau dashboard as small and fast as possible so I don't want to store all my data in an extract.
Each team I've given a unique ID (bizarrely called 'Class id') I need some way to combine them all into a string (parameter? Calculated field?) to be added the the URL action.
The pseudo call above will show data for the 2 teams the user drilled down to.