For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
23 7 11 13

DSS API, RIC lost when request for a Chain RIC

For DSS API , it it support Search Chain RIC to get full RIC list ? If yes, could you provide a JASON Sample ?

Another question: Please help to check if the following request message is correct or not. Client is complaining sometimes CLc1 is missing or CLc2 is missing. The request message is {"SearchRequest":{"PreferredIdentifierType":"Ric","Identifier":"CL","FuturesAndOptionsType":"Futures","AssetStatus":"Active","IdentifierType":"RICRoot"}} The endpoint is https://restapi-us2p.select.datascope.thomsonreuters.com/v1/Search/FuturesAndOptionsSearch

dss-rest-apidssdatascope-select
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
11.3k 25 8 14

Hi @jessie.lin

For DSS product user, you can use TermAndCondition report template to extract constituent RICs. Below is the sample.

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes
{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "0#CL:",
                    "IdentifierType": "ChainRIC"
                }
            ]
        }
    }
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
13.7k 26 8 12

Q1: does DSS support chain constituents search ?

Most search functions do not support ChainRIC as an IdentifierType. But you can use a historical bulk search (I'm not 100% sure if this available to DSS customers though, you need to try it out):

End point: https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/HistoricalBulkSearch

JSON body:

{
    "Request": {
        "Identifiers": [
            { "Identifier": "0#.FTSE", "IdentifierType": "ChainRIC" }
        ],
        "Range": {
            "Start": "2019-07-01T00:00:00.000Z",
            "End": "2019-07-01T00:00:00.000Z"
        }
    }
}

If you have TRTH you can use a historical chain constituents search. See TRTH REST tutorial 15 for the details.

There might be other solutions I am not aware of, I'm an API specialist, not a data specialist. You might want to ask a DSS product specialist, he might have a better idea.

Q2: Futures and Options search for CL RICs

Syntactically your request is correct (otherwise it would return an error), and it should always return the same list of RICs. I just ran it and it returned CLc1, CLc2 (and many other results). Important note: the results are not in alphabetical order, and their order can change.

That said, if you observe data anomalies, I suggest you call the Refinitiv Helpdesk number in your country. They will either have the answer for you right away, or will reach out to the content experts who can provide the answer you're looking for. This forum is aimed at software developers using Refinitiv APIs. The moderators on this forum do not have the required deep expertise in all the content sets available through our products to answer your question.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.