Incomplete data on historic download API Datascope

Hi @sanchezTJUK,

There are two things that may be helpful.

"r3 is not defined" is likely related to a python module missing. Please check what is r3 imported as, and if that module is installed.

Another thing to check, I just tested this request on it's own, "naked" and submitting it from Postman tool. It did not go through, the fields do not appear to be valid.

I checked with the list of valid fields for TickHistoryIntradaySummaries, these fields do not appear on the list.

When I replace the fields with valid ones for the request type, the request gest accepted ( status code 202)

{
    "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest",
    "ContentFieldNames": [
         "Close Ask",
         "Close Bid"
        ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "LGOTJ0",
        "IdentifierType": "Ric"
      }],
        "UseUserPreferencesForValidationOptions": "true"
    },      
    "Condition": {
      "MessageTimeStampIn": "GmtUtc",
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2020-01-02T00:00:00.000Z",
      "QueryEndDate": "2020-01-03T00:00:00.000Z",
      "SummaryInterval": "OneMinute",
      "TimebarPersistence":"true",
      "DisplaySourceRIC":"true"
    }
  }
}

Does the above run for you?

You may find useful tutorial REST API Tutorial 6: On Demand intraday bars extraction, it goes over the approach to Intraday in detail, using Postman, and if you use Python, the approach would be consistent. Tutorial Programming without SDK discusses Python, and includes download link to working python examples.

You may wish, as a quicker approach:

1. Use Postman tool to fully test and tune TickHistoryIntradaySummariesExtractionRequest that you require.

2. Download the Python examples ( they are linked from tutorial and also in RTH-> Downloads -> RTH Python Code Samples), and then swap you required request tuned in step 1 into working python code, instead of the included request.

Hope this helps

@sanchezTJUK,

Replacing the request type, I get back

"

"error": {

"message": "Malformed request payload: For the property name \"SummaryInterval\" in the JSON request the value could not be parsed successfully. Please check the casing or spelling of the property."

Without this condition clause, I am able to get results back.

...
#RIC,Alias Underlying RIC,Domain,Date-Time,GMT Offset,Type,Bid Price,Bid Size,Ask Price,Ask Size
LGOTJ0,,Market Price,2020-01-02T07:24:56.596063285Z,+0,Quote,-0.25,10,,
LGOTJ0,,Market Price,2020-01-02T07:25:02.700408234Z,+0,Quote,-0.25,10,0.25,10
LGOTJ0,,Market Price,2020-01-02T10:47:24.335364201Z,+0,Quote,-0.25,90,0.25,10
LGOTJ0,,Market Price,2020-01-02T10:47:25.611314961Z,+0,Quote,-0.25,90,0.25,90
LGOTJ0,,Market Price,2020-01-02T15:44:43.453059247Z,+0,Quote,0,137,0.25,90
LGOTJ0,,Market Price,2020-01-02T15:44:57.936016337Z,+0,Quote,0,137,0.25,105
LGOTJ0,,Market Price,2020-01-02T15:46:25.500950349Z,+0,Quote,0,137,0.25,125
LGOTJ0,,Market Price,2020-01-02T16:08:52.450662974Z,+0,Quote,0,12,0.25,125
LGOTJ0,,Market Price,2020-01-02T16:11:23.754852370Z,+0,Quote,0,12,0.25,105
LGOTJ0,,Market Price,2020-01-02T16:18:44.751242199Z,+0,Quote,0,12,0.25,90
LGOTJ0,,Market Price,2020-01-02T16:18:48.603454951Z,+0,Quote,0,16,0.25,90
LGOTJ0,,Market Price,2020-01-02T16:22:10.061362751Z,+0,Quote,0,16,0.25,10
...

Please confirm the exact request - glad to help test on my side?

Hello @sanchezTJUK,

On my side, this request has resulted in notes

"

"Notes": [

"Extraction Services Version 14.5.42174 (21810bfe19a8), Built Feb 4 2021 20:25:13\nUser ID: 19945\nExtraction ID: 2000000226250284\nSchedule: 0x0771fae45477448a (ID = 0x0000000000000000)\nInput List (1 items): (ID = 0x0771fae45477448a) Created: 02/16/2021 16:41:12 Last Modified: 02/16/2021 16:41:12\nReport Template (4 fields): _OnD_0x0771fae45477448a (ID = 0x0771fae45497448a) Created: 02/16/2021 16:41:07 Last Modified: 02/16/2021 16:41:07\nSchedule dispatched via message queue (0x0771fae45477448a)\nSchedule Time: 02/16/2021 16:41:08\nProcessing started at 02/16/2021 16:41:08\nProcessing completed successfully at 02/16/2021 16:41:12\nExtraction finished at 02/16/2021 16:41:12 UTC, with servers: x03q13\nHistorical Instrument <RIC,LGOTJ9> expanded to 0 RICS.\nReport suppressed because there are no instruments\n"

]"