ExtractRawResult returns http 500 with Error ID

alvise.susmel
alvise.susmel Explorer
in TRTH

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]"
    }
}
Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    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

Answers

  • alvise.susmel
    alvise.susmel Explorer

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


Categories