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 REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
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.
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
-AHS
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
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.