starting a RTC query from excel - direct update/refresh instead of manual cycle via CSV-export

Hi all,

maybe I'm looking at the wrong buzzwords and it is all easy :)

I'm trying to get RTC data (themes to tasks) into excel to do some further processing / calculation / analysis. 

I know how to create a query, export the csv, load that into excel and go ... but this is all manual.

Excel can directly load data from a http query (webquery), but that would need a URL version similar to https://bt-clmserver01.....com/ccm/web/projects/....#action=com.ibm.team.workitem.runSavedQuery&id=_pmZPwbt7EeGIU7iX9QvgUw that allows to get just the data (ideally in CSV format), without all the navigation around it.

I'm on the user-side of an existing RTC installation, i.e. I do not have access to server-side api's

Any help or tips?

thanks, Andreas