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

Options
leaperez
leaperez Newcomer
in DSS

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.

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    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

Answers

Categories