ExtractRawResult returns http 500 with Error ID

Hi,

Requested tick data of ESU9 from 2008-06-23 to 2009-09-19. While monitoring using the url

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRawResult(ExtractionId='0x05ca5c08a49b3026')

I receive a 500 http status with this error. The error id changes every time I call the url.

{
    "error": {
        "message": "   Error ID: [45718bab-0bdc-4178-a495-458ada08d771]"
    }
}

Find more posts tagged with

tick-history-rest-api

Accepted answers

zoya faberov

In terms of request syntax, two small issues,

capitalization of True and False in Validation options and comma missing after QueryEndDate:


 "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{"Identifier": "ESU9", "IdentifierType": "Ric"}],
            "ValidationOptions": {
          "AllowHistoricalInstruments": true
   },
   "UseUserPreferencesForValidationOptions": false
        },
    "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ApplyCorrectionsAndCancellations": false,
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2008-06-23T00:00:00.000Z",
            "QueryEndDate": "2009-09-19T00:00:00.000Z",
            "DisplaySourceRIC": true
        }

Note, please consider dividing request into smaller request portions by date, this request generates a very large result, so for me, Postman has trouble handling it

All comments

alvise.susmel

Hi @zoya.farberov

I don't know if it's related to the request. I receive the 500 error when I do the GET request to get the status of the job. By the way, this is the payload of request for the tick data extraction:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
        "ContentFieldNames": [
		    "Quote - Ask Price",
		    "Quote - Ask Size",
		    "Quote - Bid Price",
		    "Quote - Bid Size",
		    "Quote - Price",
		    "Quote - Volume",
		    "Trade - Ask Price",
		    "Trade - Ask Size",
		    "Trade - Bid Price",
		    "Trade - Bid Size",
		    "Trade - Open",
		    "Trade - Price",
		    "Trade - Volume"
		],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{"Identifier": "ESU9", "IdentifierType": "Ric"}],
            "UseUserPreferencesForValidationOptions": False,
            "ValidationOptions": {
                "AllowHistoricalInstruments": True
            }
        },
        "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ApplyCorrectionsAndCancellations": False,
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2008-06-23T00:00:00.000Z",
            "QueryEndDate": "2009-09-19T00:00:00.000Z"
            "DisplaySourceRIC": True
        }
    }
}

zoya faberov

In terms of request syntax, two small issues,

capitalization of True and False in Validation options and comma missing after QueryEndDate:


 "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [{"Identifier": "ESU9", "IdentifierType": "Ric"}],
            "ValidationOptions": {
          "AllowHistoricalInstruments": true
   },
   "UseUserPreferencesForValidationOptions": false
        },
    "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ApplyCorrectionsAndCancellations": false,
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2008-06-23T00:00:00.000Z",
            "QueryEndDate": "2009-09-19T00:00:00.000Z",
            "DisplaySourceRIC": true
        }

Note, please consider dividing request into smaller request portions by date, this request generates a very large result, so for me, Postman has trouble handling it

EXPLORE OUR SITES