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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
5 1 0 3

Limit search results through API - DSS Rest API

limit-search-results.png
Hello Team,
Is there a way to limit results through API just like we can do in the GUI??
PFA screenshot -

Thank you,

Trisha Gehlot

dss-rest-api#productdss
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
24.4k 62 15 21

Hello @trisha.gehlot,

By default the DSS will limit the resultset. This is defined in the server driven paging mechanism. The user can change the number of results per page by passing in the appropriate header like this -

POST https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FuturesAndOptionsSearch HTTP/1.1

Authorization: Token <your_auth_token_goes_here>
Prefer: odata.maxpagesize=10; respond-async
Content-Type: application/json; odata=minimalmetadata
{
    "SearchRequest": {
        "FileCodes": null,
        "CurrencyCodes": null,
        "ExchangeCodes": [
            "IMM"
        ],
        "StrikePrice": null,
        "ExpirationDate": null,
        "IdentifierType": "Ric",
        "Identifier": "ED*",
        "PreferredIdentifierType": "Ric"
    }
}
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
5 1 0 3

@Gurpreet Thank you for your response!!

In my case, I am sending multiple Ric's and want 100 per underlying Ric.
Is there any way to do the same, by sending multiple Ric's or I will need to send each Ric individually??


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.

The page size limit will apply regardless of a single instrument or a batch. If you want 100/instrument, then maybe sending single instrument request will work. Be careful to not breach the maximum data request throttling limits in the API - i.e. pace out multiple requests in succession.
Upvotes
5 1 0 3

@Gurpreet Thank you for your response!!

The issue is not exactly with pagesize,

For Example,

Currently 1 underlying Ric expands to approx 1700 Rics

We want 1 underlying Ric expands to approx 100 Rics

Could you please guide on this?

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.

@trisha.gehlot,

The API does not have a field to limit the expansion to a certain number. You can see the API request structure here. For more information on any content questions, it is best to reach out to content experts at LSEG MyAccount.

Upvotes
5 1 0 3

Ok, I thought there must be something for API as well, as it is in GUI.
No worries.
Thank you for your guidance!! @Gurpreet

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.