Chain RIC 0#SIRT- gives incorrect end date (2017-05-06) using 'ResultsBy': 'Entity, however without 'ResultsBy': 'Entity it gives correct end date:
with 'ResultsBy': 'Entity
when sending request
@{'Request': {'@odata.context': 'http://selectapi.datascope.refinitiv.com:83/RestApi.Help/$metadata#DataScope.Select.Api.Search.HistoricalSearchRequest',
'IdentifierType': 'ChainRIC',
'Identifier': '0#SIRT-:',
'Range': {'Start': '1996-01-01T00:00:00.000Z',
'End': '2021-12-31T23:59:59.000Z'},
'ResultsBy': 'Entity'}}
to below
https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalSearch
it returns
@{'@odata.context': 'https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.HistoricalSearchResult)',
'value': [{'Identifier': '0#SIRT-:',
'IdentifierType': 'Ric',
'Source': '',
'Key': 'VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwI1NJUlQtOnw',
'Description': 'Historical Instrument',
'InstrumentType': 'Unknown',
'Status': 'Valid',
'DomainCode': '6',
'ValidFrom': '1996-06-04T04:43:43.200Z',
'ValidTo': '2017-05-06T14:09:09.000Z',
'FirstDate': '1996-06-04T00:00:00.000Z',
'LastDate': '2017-05-06T00:00:00.000Z',
'History': [{'Ric': '0#SI-:',
'ValidFrom': '1996-06-04T04:43:43.200Z',
'ValidTo': '2016-01-23T14:34:11.415Z',
'FirstDate': '1996-06-04T00:00:00.000Z',
'LastDate': '2016-01-23T00:00:00.000Z'},
{'Ric': '0#SIRT-:',
'ValidFrom': '2016-01-23T14:34:11.415Z',
'ValidTo': '2017-05-06T14:09:09.000Z',
'FirstDate': '2016-01-23T00:00:00.000Z',
'LastDate': '2017-05-06T00:00:00.000Z'}]}]}
Without 'ResultsBy': 'Entity : End date shows 2022-07-09
{
"Request": {
"Identifier": "0#SIRT-:",
"IdentifierType": "ChainRIC",
"Range": {
"Start": "1996-01-01T00:00:00.000Z",
"End": "2021-12-31T00:00:00.000Z"
},
"ResultsBy": "Ric"
}
}
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.HistoricalSearchResult)",
"value": [
{
"Identifier": "0#SIRT-:",
"IdentifierType": "ChainRIC",
"Source": "",
"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwI1NJUlQtOnw",
"Description": "Historical Chain",
"InstrumentType": "Unknown",
"Status": "Valid",
"DomainCode": "6",
"FirstDate": "2016-01-23T00:00:00.000Z",
"LastDate": "2022-07-09T00:00:00.000Z",
"History": []
}
]
}
Also, why does the 1st API response shows 0#SIRT-: as RIC
And the chain0#SIRT-: is active till date(why doesnt end date shows as todays date)
