PriceHistoryExtraction Request

elvis.fernandez · June 2019

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"
  	}
  }
}

zoya faberov · June 2019

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.

Christiaan Meihsl · June 2019

@elvis.fernandez,

There are different ways to go about this:

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.
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.
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).

PriceHistoryExtraction Request

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories