question

Upvotes
Accepted
1 0 0 1

Downloading data for historical ric SHY using REST api

Hi,

I am lookign to get data for identified SHY which is an old version of SHY.O.

I am using the REST api:ThompsonReuters.Dss.Api.Extractins.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest. However, I am getting an identifier not found. If I go to the datascope website and create the report there data returns.

Does anyone know what I am, going wrong?

Thanks,

Sorcha

tick-history-rest-api
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.

Hello @mcdonnso

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


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS


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
Upvote
Accepted
32.2k 40 11 20

Hello @mcdonnso,

If you are looking to request with the old version of RIC, including ValidationOptions clause may be what's missing, for example:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
    "ContentFieldNames": [
          "Trade - Price",
          "Trade - Volume",
          "Trade - Exchange Time"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "ValidationOptions": {
            "AllowHistoricalInstruments": true
            },
            "UseUserPreferencesForValidationOptions": false,
      "InstrumentIdentifiers": [{
        "Identifier": "SHY",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "MessageTimeStampIn": "GmtUtc",
      "ApplyCorrectionsAndCancellations": false,
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2016-04-01T00:00:00.000Z",
      "QueryEndDate": "2016-04-04T12:00:00.000Z",
      "DisplaySourceRIC": true
    }
  }
}

otherwise only currently valid identifiers will be included in the results, which may not be what you are looking for?

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.

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.