Is it possible to retrieve RIC details along with available contract months through API? Please s...

nikolay.lazarov

...ee the attached screenshot for a preview of the desired data.

contract-months.png

veerapath.rungruengrayubkul

Hi @nikolay.lazarov,

You can use DSS REST API with Term and Condition report template to retrieve the desired data. You can find the list of available fields in the Data Content Guide for DataScope Select. There are two types of data extraction method.

- Schedule extraction

Scheduled extractions use instrument lists, report templates and schedules that are stored on the server, and visible in the web GUI. Extracted data will be in the same CSV format as the GUI. For more details, please see REST API Tutorial 10: GUI control calls: immediate extract

- On Demand extraction

On Demand extractions use simplified high level API calls that create extractions on the fly.

Instrument lists and report templates are not stored on the server, cannot be reused later and cannot be seen using the web GUI. Extracted data will be in JSON format. For more details, please see REST API Tutorial 7: On Demand T&C extraction

Below is the sample of REST API On Demand request to retrieve the same data as the preview screenshot.

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes
Body:
{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
            "Instrument ID","Contract Type","Contract Month and Year","Asset Type Description","Asset SubType Description","Security Description"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "LCOF0",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "LCOF1",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "LCOTQ9",
                    "IdentifierType": "Ric"
                }
            ],
            "UseUserPreferencesForValidationOptions": true
        }
    }
}

Response:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "LCOF0",
            "Instrument ID": "LCOF0",
            "Contract Type": "7",
            "Contract Month and Year": "JAN2020",
            "Asset Type Description": "Derivatives",
            "Asset SubType Description": "Derivative - Futures",
            "Security Description": "BRENT CRUDE JAN0"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "LCOF1",
            "Instrument ID": "LCOF1",
            "Contract Type": "7",
            "Contract Month and Year": "JAN2021",
            "Asset Type Description": "Derivatives",
            "Asset SubType Description": "Derivative - Futures",
            "Security Description": "BRENT CRUDE JAN1"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "LCOTQ9",
            "Instrument ID": "LCOTQ9",
            "Contract Type": "120",
            "Contract Month and Year": "AUG2019",
            "Asset Type Description": "Derivatives",
            "Asset SubType Description": "Derivative - Futures",
            "Security Description": "BRT CRD TAS AUG9"
        }
    ],
...