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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
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.

Hello @Asif Khan

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

1 Answer

· Write an Answer
Upvotes
79.4k 253 52 74

@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.