I'm sending a time-sales request with the following body:
requestBody={ "ExtractionRequest": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest", "ContentFieldNames": [ "Trade - Price", "Trade - Volume", "Trade - Exchange Time" ], "IdentifierList": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [{ "Identifier": "SXFM7", "IdentifierType": "Ric" }], "ValidationOptions": { "AllowHistoricalInstruments": "true" }, "UseUserPreferencesForValidationOptions": "false", }, "Condition": { "MessageTimeStampIn": "GmtUtc", "ApplyCorrectionsAndCancellations": "false", "ReportDateRangeType": "Range", "QueryStartDate": "2017-05-30T01:00:00.000Z", "QueryEndDate": "2017-06-02T23:59:00.000Z", "DisplaySourceRIC": "true" } } }
In the old TRTH service the response included two columns :
- Date [G] which included a Date (without time component) such as 1/17/2017
- Time [G] which included a Time (without date component) such as 12:00:00 AM
However, in the new service I receive both the date and time back in a single column called :
- Date-Time in a format such as 2017-05-30T10:00:00.03175151277Z
Is there anything I can put in the response header to get the two columns Date and Time back in the same format as in the older TRTH service?