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 /

For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

avatar image
Question by Akhmed · Jan 11, 2021 at 07:48 AM · dss-rest-apidatascope-selectdssrest-apipricing

Can't get Close Price from REST API

Hello. We really need your help!

We are trying to switch from the old SOAP API to the new REST API. But we encounter several problems. Here is one of them:

There are two identical requests. In one, we ask for the value of the Universal Close Price, and in the second, simply the Close Price. We get an adequate response to the first request, but the second one returns an error number 400.

Request #1:

{"ExtractionRequest":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest","ContentFieldNames":["Universal Close Price"],"IdentifierList":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers":[{"Identifier":"MSFT.O","IdentifierType":"Ric"}],"ValidationOptions":null,"UseUserPreferencesForValidationOptions":false},"Condition":{"ReportDateRangeType":"Range","QueryStartDate":"2017-08-30T00:00:00.000Z","QueryEndDate":"2017-08-30T23:59:59.000Z"}}}

Response #1:

[{"IdentifierType":"Ric","Identifier":"MSFT.O","Universal Close Price":74.01}]

Request #2:

{"ExtractionRequest":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest","ContentFieldNames":["Close Price"],"IdentifierList":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList","InstrumentIdentifiers":[{"Identifier":"MSFT.O","IdentifierType":"Ric"}],"ValidationOptions":null,"UseUserPreferencesForValidationOptions":false},"Condition":{"ReportDateRangeType":"Range","QueryStartDate":"2017-08-30T00:00:00.000Z","QueryEndDate":"2017-08-30T23:59:59.000Z"}}}

Response #2:

400 Bad Request

In the old SOAP API, we received the values of these fields without problems. No hints were found in the documentation. Tell me what is our mistake?

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 zoya faberov · Jan 11, 2021 at 09:37 PM

Hello @akhmed.turabov,

The template requested, PriceHistoryExtractionRequest, does not support "Close Price" as is, it supports several different Close Prices, such as " Universal Close Price" and "Official Close Price", but not "Close Price".

Different fields are available from different templates.

One way to verify if a field is supported by a template, is to request the complete list of fields that are supported by that template, with brief descriptions, with request:

{
                {protocol}}{
                {host}}{
                {api}}Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'PriceHistory') 

It will come back with the complete list of fields such as:

... 
{
            "Code": "ET2.Official Bid",
            "Name": "Official Bid",
            "Description": "Official Bid price posted at end of pit or ring trading period.",
            "FormatType": "Number",
            "FieldGroup": " "
        },
        {
            "Code": "ET2.Official Close Price",
            "Name": "Official Close Price",
            "Description": "The official closing price from Exchange.",
            "FormatType": "Number",
            "FieldGroup": " "
        },
...

I would suggest using free tool Postman for HTTP REST testing and our collection for Postman already has this request, step-by-step detailed explanation can be found in REST API Tutorial 4: On Demand price history extraction.

Another way is to lookup the available fields in DSS Data Content Guide.

Hope this helps

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 >
14 People are following this question.

Related Questions

Default Pricing Source on DSS

Can't get Mid Price from REST API

Tick history (Time and Sales data) retrieval for US exchanges

Search with DSS REST API for instruments available from a specific source

Historical coupon dates for a Bond in REST API

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges