I’m not seeing any error code on my side, but I don’t see the data for api 1 it loads around 76k rows and says data load is completed. Just fyi I’m using python and I shared you the api call which I’m making.
I don’t see RIC GOOGQ152627000.U coming in below. If I short the date range in api call for this option expiry date, then I can see it.
Issue API call:
{'SearchRequest':
{'@odata.context': 'http://selectapi.datascope.lseg.com/RestApi/v1/$metadata#DataScope.Select.Api.Search.FuturesAndOptionsSearchRequest',
'ExchangeCodes': ['OPQ'],
'FuturesAndOptionsType': 'Options',
'AssetStatus': 'Active',
'ExpirationDate':
{'@odata.type': '#DataScope.Select.Api.Search.DateRangeComparison',
'From': '2026-03-20T00:00:00.000Z', 'To': '2028-08-15T00:00:00.000Z'},
'FileCodes': ['7167'],
'IdentifierType': 'Ric',
'PreferredIdentifierType': 'Ric'}}
Python code to fetch api results:
results = []
stop = False
next_link = self.urlFutureSearch
while not stop:
resp = requests.post(next_link, json=data, headers=headers, proxies=self.proxies)
if resp.status_code != 200:
log.exception("Future Search Request Error: " + str(resp.status_code))
stop = True
else:
json_result = resp.json()
if self.odata_nextlink in json_result:
next_link = json_result[self.odata_nextlink]
else:
stop = True
products = json_result['value']
log.info("Loaded " + str(len(products)) + " products")
results += products
return results
I’m exporting the data into CSV, and I see multiple details missed not sure why I’m getting different results from same api and same logic just for changing the dates.
