Starting from Monday such request for RICs: LDNXAG= XPTFIXPM= and XPDFIXPM=:
{ "ExtractionRequest": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.SingleHistoricalPriceExtractionRequest", "ContentFieldNames": [ "Trade Date", "Close Price" ], "IdentifierList": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "LDNXAG=", "IdentifierType": "Ric" } ], "ValidationOptions": null, "UseUserPreferencesForValidationOptions": false }, "Condition": { "PriceDate": "2018-09-17" } } }
Returns code 200 OK and:
{ "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)", "value": [ { "IdentifierType": "Ric", "Identifier": "LDNXAG=", "Error": "Not found" } ] }
If instead of code:
"ValidationOptions": null
I use:
"ValidationOptions": { "AllowHistoricalInstruments":true }
then:
{ "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)", "value": [ { "IdentifierType": "Ric", "Identifier": "LDNXAG=", "Trade Date": null, "Close Price": null } ] }
============================================================
The same happend with command EndOfDayPricingExtractionRequest:
{ "ExtractionRequest": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest", "ContentFieldNames": [ "Trade Date", "Close Price", "Universal Close Price Date", "Universal Close Price" ], "IdentifierList": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "LDNXAG=", "IdentifierType": "Ric" } ], "ValidationOptions": { "AllowHistoricalInstruments":true }, "UseUserPreferencesForValidationOptions": false }, "Condition": null } }
==========================================================
At the same moment another strange thing started.
for XAUFIXPM these two requests using SingleHistoricalPriceExtractionRequest and EndOfDayPricingExtractionRequest return Different results:
SingleHistoricalPriceExtractionRequest all fine:
{ "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)", "value": [ { "IdentifierType": "Ric", "Identifier": "XAUFIXPM=", "Trade Date": "2018-09-17", "Close Price": 1201.9 } ] }
But EndOfDayPricingExtractionRequest returns 2018-09-14 date:
{ "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)", "value": [ { "IdentifierType": "Ric", "Identifier": "XAUFIXPM=", "Trade Date": "2018-09-14", "Close Price": 1201.95, "Universal Close Price Date": "2018-09-14", "Universal Close Price": 1201.95 } ] }