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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
18 2 3 7

API to pull all Futures RIC Root for global exchange?

Is there any API via DSS that can provide the complete list of Futures RIC Root that client can use to pull the details?

Client is after the RIC ROOT and associated description for the future along with exchange code / name for all the exchanges.

DSS GUI limit search to 5000 RIC root only.


1713828511049.png

#technologydss-rest-api#content
1713828511049.png (98.8 KiB)
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.

1 Answer

· Write an Answer
Upvotes
Accepted
83.1k 281 53 77

@Asif Khan

Thank you for reaching out to us.

You can use the DSS REST API to get the same results as Futures and Options Search on DSS Web GUI. Please refer to the REST API Tutorial 13: Search for a Future or Option tutorial.

The endpoint is https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FuturesAndOptionsSearch and the request body is:

{
    "SearchRequest": {
        "FuturesAndOptionsType": "Futures",
        "PreferredIdentifierType": "RICRoot",
        "AssetStatus": "Active"
    }
}

The response will contain the results and the @odata.nextlink.

      {
            "Identifier": "RIBA=FIX",
            "IdentifierType": "RICRoot",
            "Source": "PMI",
            "Key": "VjF8MHgwMDEwMGIwMDM4MjgxYWQ2fDB4MDAxMDBiMDAzODI4MWFkN3xQTUl8RFZRVXxERVJWfEZVVHxEfHxSSUJBWjU9RklYfDUxMTQ",
            "Description": "RIBAZ5 FIX",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid",
            "ExchangeCode": "PMI",
            "CurrencyCode": "SEK",
            "FuturesAndOptionsType": "Futures",
            "PutCallCode": "",
            "ExpirationDate": "2025-12-16T00:00:00.000Z",
            "AssetStatus": "Active"
        }
    ],
    "@odata.nextlink": "https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FuturesAndOptionsSearch?$skiptoken='MjUw'"

The @odata.nextlink can be used to retrieve the next page.

For more information, please refer to this discussion.

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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