Allow multiple results (RIC) from the same source from Datascope using Report Template

leaperez

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.

zoya faberov

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

Jirapongse

@leaperez

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.

leaperez

https://community.developers.refinitiv.com/discussion/comment/80534#Comment_80534

Thanks for the information but all the options return one record per source, that is, only one RIC per contributor. What I need is to get all the RICs from a source with is displayed in the image.

DS.png