How to get RIC Maintenance Report on DSS REST API?

Bonel

Hello, could you help me know how to get the RIC Maintenance Report this via DSS Rest API?

We have a client looking to we find a mechanism to identify RIC changes via DSS Rest API. They currently run Composite Extractions

I know how to pull it via GUI but would like to get assistance on how it's done on API. Thank you.

Jirapongse Phuriphanvichai

@Bonel

Thank you for reaching out to us.

I assume that the client is using on-demand extractions.

First, the client needs to extract the "Extraction ID" from the "Notes".

"Notes": [
"Extraction Services Version 20.3.1.840019 (961953e14bb12184adb628589625742bb7db5748), Built Aug 14 2026 15:26:28\r\nUser has overridden estimates broker entitlements.\r\nProcessing started at 10/20/2026 PM 01:55:58.\r\nUser ID: 9008895\r\nExtraction ID: 2000001341254698\r\nCorrelation ID: CiD/0/AAAAAA.0a0caf00b3715267/RA\r\nSchedule: 0x0a0caf00b3a15267 (ID = 0x0000000000000000)\r\nInput List (2 items): (ID = 0x0a0caf00b3a15267) Created: 10/20/2026 PM 01:55:58 Last Modified: 10/20/2026 PM 01:55:58\r\nReport Template (35 fields): _OnD_0x0a0caf00b3a15267 (ID = 0x0a0caf00b3d15267) Created: 10/20/2026 PM 01:55:56 Last Modified: 10/20/2026 PM 01:55:56\r\nSchedule dispatched via message queue (0x0a0caf00b3a15267)\r\nSchedule Time: 10/20/2026 PM 01:55:57\r\nProcessing completed successfully at 10/20/2026 PM 01:56:06, taking 8.448 Secs.\r\nExtraction finished at 10/20/2026 AM 06:56:06 UTC, with servers: xc92jxchq15, QSDHA1 (0.0 secs), QSHC06 (1.3 secs)\r\nUsage Summary for User 9008895, Client 65507, Template Type Ownership Owners\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 1 Corporate N/A N/A\r\n 1 Equities N/A N/A\r\n-------\r\n 2 Total instruments charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 2 Instruments in the input list.\r\nWriting RIC maintenance report.\r\n",
"Identifier,IdentT

For example, the Extraction ID is 2000001341254698.

Then use the Extraction ID (2000001341254698) with the following endpoint to get the ExtractedFileId of the RIC Maintenance File.

GET https://selectapi.datascope.lseg.com/RestApi/v1//Extractions/ReportExtractions('2000001341268240')/RicMaintenanceFile

{

    "@odata.context": "https://selectapi.datascope.lseg.com/RestApi/v1/$metadata#ExtractedFiles/$entity",
    "ExtractedFileId": "VjF8MHgwYTA3OWQ2MGRmYjE0YTNifA",

    "ReportExtractionId": "2000001341268240",

    "ScheduleId": "0x0a0c6f669ee151fc",

    "FileType": "RicMaintenanceNote",

    "ExtractedFileName": "_OnD_0x0a0c6f669ee151fc.ric.csv",

    "LastWriteTimeUtc": "2026-10-20T07:19:18.726Z",

    "ContentsExists": true,

    "Size": 90,

    "ReceivedDateUtc": "2026-10-20T07:19:18.773Z"

}

Finally, use the ExtractedFileId (VjF8MHgwYTA3OWQ2MGRmYjE0YTNifA) with the following endpoint to get a file.

GET https://selectapi.datascope.lseg.com/RestApi/v1//Extractions/ExtractedFiles('VjF8MHgwYTA3OWQ2MGRmYjE0YTNifA')/$value