I need to get all the RICs of an ISIN by extracting the datascope using Report Template.
For example, the ISIN ARARGE3209S6 has 6 RICs from the MAE source and the extraction returns only the Primary RIC from the source.
For a deeper look into our DataScope Select SOAP API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
1
●0 ●0 ●0
Allow multiple results (RIC) from the same source from Datascope using Report Template
23k
●22 ●9 ●14
Hello @leaperez ,
The search request type that you request via DSS GUI is GovCorp search, with option "allow multiple results from same source".
From reviewing DSS REST API Reference Tree -> GovCorpSearch spec, I do not find this option or analogous, exposed.
I fully agree with @jirapongse.phuriphanvichai on the approaches to searches available.
Additionally, you may wish to review HistoricalReferenceExtractionRequest:
{ {protocol}}{ {host}}{ {api}}Extractions/ExtractWithNotes
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
"ContentFieldNames": [
"RIC", "Exchange Code"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "ARARGE3209S6", "IdentifierType": "Isin"}
],
"ValidationOptions": {"AllowHistoricalInstruments": "true"},
"UseUserPreferencesForValidationOptions": "false"
},
"Condition": {
"StartDate": "2021-05-01T09:30:00.000Z",
"EndDate": "2021-06-06T17:00:00.000Z"
}
}
}
From my testing, the result includes multiple RICs from the same source:
RIC,Exchange Code,User Defined Identifier,User Defined Identifier2,User Defined Identifier3,User Defined Identifier4,User Defined Identifier5,User Defined Identifier6 ARAL30=,,,,,,,ISN|ARARGE3209S6| ARAL30=BA,,,,,,,ISN|ARARGE3209S6| ARAL30=FCMX,,,,,,,ISN|ARARGE3209S6| ARAL30=IAMC,,,,,,,ISN|ARARGE3209S6| ARAL30=IAMD,,,,,,,ISN|ARARGE3209S6| ARAL30=ITAU,,,,,,,ISN|ARARGE3209S6| ARAL30=ME,,,,,,,ISN|ARARGE3209S6| ARAL30=RC,,,,,,,ISN|ARARGE3209S6| ARAL30=RRBB,,,,,,,ISN|ARARGE3209S6| ARAL30=RRPS,,,,,,,ISN|ARARGE3209S6| ARAL301=BA,,,,,,,ISN|ARARGE3209S6| ARAL301=ME,,,,,,,ISN|ARARGE3209S6| ARAL301=RC,,,,,,,ISN|ARARGE3209S6| ARAL303=BA,,,,,,,ISN|ARARGE3209S6| ARAL303=DSUR,,,,,,,ISN|ARARGE3209S6| ARAL303=ME,,,,,,,ISN|ARARGE3209S6|
Hope this helps
38.1k
●71 ●35 ●53
You can refer to the ISIN to RIC conversion with the DSS (DataScope Select) REST API article in the Finding the RIC(s) for one or more exchanges for an ISIN section.
