Eikon Scripting API could do this.
# Step 1 : Retrieve all CDS id for RIC list
data, error = ek.get_data(['VOD.L','AAPL.OQ','MSFT.OQ'],'TR.CDSPrimaryCDSRic') Instrument Primary CDS RIC0 VOD.L VOD5YEUAM=R1 AAPL.OQ AAPL5YUSAX=R2 MSFT.OQ MSFT5YUSAX=R
# Step 2 : retrieve CDS prices
cdsIdList = [str(cdsId) for cdsId in data.ix[:,1].values]<br>print('================')<br>result, err = ek.get_data(cdsIdList, ['PRIMACT_1', 'LONGLINK2']) Instrument PRIMACT_1 LONGLINK20 VOD5YEUAM=R 58.57 0#VODEUAMRBMK=1 AAPL5YUSAX=R 27.73 0#AAPLUSAXRBMK=2 MSFT5YUSAX=R 29.05 0#MSFTUSAXRBMK=