question

Upvotes
Accepted
will.kuchinski avatar image
1 ●1 ●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.

zoya faberov avatar image   zoya faberov

Hello @will.kuchinski

It may help to know what fields are you looking to retrieve

warat.boonyanit avatar image   warat.boonyanit

Hi @will.kuchinski

Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

-AHS

moragodkrit.chumsri_1 avatar image   moragodkrit.chumsri_1

@will.kuchinski

Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Nipat Kunvutipongsak avatar image   Nipat Kunvutipongsak

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

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_
zoya faberov avatar image   zoya faberov

Hi @will.kuchinski ,

How are you testing? I quick-test with Postman tool.

Have you been able to run other requests that come back with data, is only this request coming back empty? If you are looking to get started, we have tutorials describing usage that have many popular requests implemented.

Are you getting back status 200 (completed) or 202 (accepted)? If your request is completed, you would get data back. If it's accepted, you need to check the status as described in our tutorials, and retrieve the data once it's ready.

zoya faberov avatar image   zoya faberov

Please note, although the links do not show in comments, unless you hover over them, the previous comment includes links to the described resources

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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