Why I cannot access reference change event.

How could I access reference change event , e.g. isin change or ric change. I see there is field exist in the report template but I did not get any data return.

Find more posts tagged with

tick-history-rest-api

Accepted answers

Christiaan Meihsl

@bin, today we published a new Historical Reference Tutorial. In the downloads tab the Postman collection was updated to include that, and there is also a new Java sample. Hope this helps.

All comments

veerapath.rungruengrayubkul

@bin,

Could
you please share the information about the extraction you use? (i.e.
field, instrument, report template, request message) Did you use the HistoricalReference report template?

bin

Could I have a sample code to access reference change event, in V1 I can access RIC change or ISIN change history, how to do it in v2

bin

{"Request":{"Identifier":"TRIL.L","IdentifierType":"Ric","Range":{"Start":"2006-01-01T00:00:00.000Z","End":"2017-04-26T23:59:59.000Z"},"ResultsBy":"Entity"}}

this is the way I get ric change history but how could I do for a ric list and how to get ISIN?

veerapath.rungruengrayubkul

Hi @bin

I believe that you are using Historical Search. Is this correct?

Could you try the HistoricalReference Report template? The report template can provide historical reference in specific range of time. Below is the example of message for On Demand extraction.

Please note that, in the result, entries will be generated for any change in all fields, even only identifier fields are selected. You may need to manually filter only the entry that has change in the ISIN, RIC field.

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
        "ContentFieldNames": [
           "RIC",
           "ISIN",
           "SEDOL",
           "Change Date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "TRIL.L",
                    "IdentifierType": "Ric"
                }
            ],
            "ValidationOptions": {
                "AllowHistoricalInstruments": true},
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "StartDate": "2006-01-01T00:00:00.000Z",
            "EndDate": "2017-04-26T23:59:59.000Z"
        }
    }
}

bin

What's header for this one?

Is this request from schuduler or on demand?

zoya faberov

Hi @bin,

HistoricalReferenceExtractionRequest is available as on demand->ExtractRaw.

For a complete reference of REST API options, please refer to

REST API Tree

Or reach it through:

Hosted

-> Help -> REST API Help -> Show API Reference Tree

Christiaan Meihsl

@bin, today we published a new Historical Reference Tutorial. In the downloads tab the Postman collection was updated to include that, and there is also a new Java sample. Hope this helps.

EXPLORE OUR SITES