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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
3 4 2 6

PriceHistoryExtraction Request

Where can I find details for ContentFieldNames supported for PriceHistory Extraction.

Request

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
    "ContentFieldNames": [
      "RIC",
      "Trade Date",
      "Universal Close Price",
      "Volume",
      "Turnover",
      "Accumulated Volume Unscaled"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
        {
          "IdentifierType": "Ric",
          "Identifier": "DWAQ.O"
        }
      ]
    },
    "Condition": {
      "AdjustedPrices": false,
      "QueryStartDate": "2019-05-17",
      "QueryEndDate": "2019-05-28"
  	}
  }
}
dss-rest-apidssdatascope-select
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.

Upvotes
Accepted
29k 33 11 15

Hello @elvis.fernandez,

You can either look up the full details in API Reference Tree

https://hosted.datascopeapi.reuters.com/RestApi.Help/Context/Operation?ctx=Extractions&opn=ExtractRaw&grp=On%20Demand%20Extraction

Choose Extractions -> On Demand extraction -> ExtractRaw

Choose PriceHistoryExtractionRequest and you can see the complete reference, including ContentFieldNames

Or run the request to get the list of available fields

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

This approach is described in detail in REST API Tutorial 4: On Demand price history extraction, you will be able to learn more by following the tutorial.

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.

Upvotes
13.7k 26 8 12

@elvis.fernandez,

There are different ways to go about this:

  1. Go to the GUI, create a report template for Price History, click on Fields on the left, and the list of fields will appear. The field list is searchable by field name. When you click on a field name a description is also displayed.
  2. Download the Data Content Guide. Open tab "Field Descriptions", and use a filter on column C to display only Price History fields. The field names are in column D, the description in column E. Further columns describe formatting, and availability by asset class, etc.
  3. Run an API call, as described in REST API tutorial 4: GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'PriceHistory')

You can proceed in a similar way for any type of data request (REST tutorials 2-8 give several examples of the 3rd method above).

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.