question

Upvotes
Accepted
will.kuchinski avatar image
1 ●0 ●0 ●1

grab chainric data through rest api

Hi,

We are trying to pull data associated to a specific chainRic, 0#SPX*.U, using a rest api GET command. We were hoping to pull either the specific identifiers associated to the chain or even better specific fields for each identifier in the chain for a specific date. Can you help us with an example GET command?

We have only been able to get the

https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/HistoricalChainResolution uri to work for the 0#.SPX chainRic, and for some reason the 0#SPX*.U did not work when we swapped it out.

Any help is appreciated!

Thanks,

Will

tick-history-rest-apirest-apichain-ricderivatives
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
zoya faberov avatar image
31.7k ●37 ●11 ●19

To retrieve the constituents of the chain RIC, at specific dates, you may try HistoricalReference request:

 {
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "CUSIP",
            "ISIN",
            "SEDOL",
            "Issuer OrgID",
            "Exchange Code",
            "Currency Code",
            "Change Date"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "0#SPX*.U",
                    "IdentifierType": "ChainRIC"
                }
           ],
            "ValidationOptions": {"AllowHistoricalInstruments": true},
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "StartDate": "2017-09-01T00:00:00.000Z",
            "EndDate": "2017-09-01T23:59:59.999Z"
        }
    }
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

will.kuchinski avatar image will.kuchinski

Thanks for the response @zoya.farberov

I used your example, and the request is accepted but I'm getting an empty file. Here is the request with the headers:

The postsed data is exactly the same as above. Any thoughts as to why the file would return empty?

GET 'https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract'
Content-Type: application/json 
Prefer: respond-async 
Accept-Charset: UTF-8 
Authorization: Token _token_