grab chainric data through rest api

Question

Question by will.kuchinski · Sep 18, 2017 at 04:38 PM · rest api options chain ric

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

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2017-09-18T17:00:34Z

REFINITIV

Best Answer

Answer by zoya.farberov · Sep 18, 2017 at 05:00 PM

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"
        }
    }
}

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

will.kuchinski · Sep 19, 2017 at 11:02 AM 0

Share

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_

grab chainric data through rest api

1 Reply

Watch this question

Related Questions