Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
REFINITIV
Question by Patrick.Trierweiler · Dec 19, 2017 at 11:14 AM · dssdss rest apitimeseriesdss apihistory

What is the best way select the entire history of an instrument in DSS rest API

I am interested in getting the entire history of an instrument.

What is the best way to do that outside of using startDate and EndDate?

Is there a condition clause available to select entire history?

Also is there an easy to view all the relevant search conditions?

requestBody={
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TimeSeriesExtractionRequest",
    "ContentFieldNames": [
      "File Code",
      "RIC",
      "Trade Date",
      "Close Price",
      "High Price",
      "Low Price",
      "Open Price",
      "Volume",
      "Bid Price",      
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "CZ8",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "LastPriceOnly": False,
      "StartDate": "2017-05-24T00:00:00.000Z",
      "EndDate": "2017-05-31T00:00:00.000Z"
    }
  }
}

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Dec 20, 2017 at 05:37 AM

@Patrick.Trierweiler,

What is the best way to do that outside of using startDate and EndDate?

There is no other way. But it is easy to hard code a start date of 1 Jan 1996 (the database does not contain data before that date), and programmatically set the end date to today.

Is there a condition clause available to select entire history?

No, there is no such condition.

Also is there an easy to view all the relevant search conditions?

I'm not sure I understand this query. The above request is not a search but a data extraction request. Its conditions (like those of all API requests) are listed in the API Reference tree. Search requests are different, and several are available (instrumentSearch, EquitySearch, etc.). You can find their list, description and search criteria in this section of the API Reference tree.

If this does not answer your query, then please add details so we can deliver a better answer.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
12 People are following this question.

Related Questions

DSS API for automation manual config

DSS API issue - response has no data although client is getting 200 OK

Looking for Webservice link from Refinitiv

Does the DSS rest api endpoint "/Search/EquitySearch" have any limits? Are there any non production environments that we can connect to in order to test this DSS rest api?

Details about Chain RIC constituents

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges