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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
lei.cheng avatar image
1 ●3 ●4 ●6

why the FuturesAndOptionsSearchRequest search result less than the web ui

i hope to query all the instruments which underlying is ".KS200" by use the 

FuturesAndOptionsSearchRequest,but the query result only 250 records. but in fact is 860 records or so in the web ui .
dss-rest-apidatascope-selectdss
icon clock
10 |1500

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

lei.cheng avatar image lei.cheng

in the web ui,the query result is 862. what differ ?

1992264358.jpg (137.5 KiB)
lei.cheng avatar image lei.cheng 
"SearchRequest": {
                   
       "@odata.type": "#ThomsonReuters.Dss.Api.Search.FuturesAndOptionsSearchRequest",
       "FuturesAndOptionsType": "Options",
       "UnderlyingRic": ".KS200"
   }

1 Answer

Upvotes
Accepted
veerapath.rungruengrayubkul avatar image
11.3k ●25 ●8 ●13

@lei.cheng

FuturesAndOptionsSearchRequest supports "Server-Driven Paging". The request returns only 250 rows of result on the initial request. The server response will include a nextlink (URI) that, when called, will return the next 250 rows for that result set as well as another nextlink. If there are no more rows, the nextlink will not be returned.

At the end of the response, you will see the nextlink.

...
    "@odata.nextlink": "https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/FuturesAndOptionsSearch?$skiptoken='MjUw'"
}

To retrieve next 250 rows of result, you need to send HTTP Post request with the same payload to the nextlink URI: https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/FuturesAndOptionsSearch?$skiptoken='MjUw' instead.

icon clock
10 |1500

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

Click below to post an Idea Post Idea