invalid identifiers error if missing ValidationOptions on certain RICs
I tried replicating the THv2 API case 7b (Request EoD Data) in Postman and it's allright if i change dates or use equities RIC, when i try with RIC such as EXA01c (an energy spot) with the following request
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest",
"ContentFieldNames": [
"Instrument ID",
"Benchmark Price",
"Trade Date"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "EXA01c",
"IdentifierType": "Ric"
}
]
},
"Condition": {
"StartDate": "2017-03-24T00:00:00.000-00:00",
"EndDate": "2017-03-26T00:00:00.000-00:00"
}
}
}
i get the "All identifiers were invalid. No extraction performed." message and can't get any data.
This message is misleading because if i perform same request with the GUI i can get valid results.
Then if i add to the request the ValidationOptions i saw in other part of API document i.e. :
"ValidationOptions": {
"AllowHistoricalInstruments": true
},
"UseUserPreferencesForValidationOptions": false,
request is running ok and with step 7d ,results are returned :
Instrument ID,RIC,Benchmark Price,Trade Date
EXA01c,EXA01c,28.96,2017/03/24
EXA01c,EXA01c,23.99,2017/03/25
EXA01c,EXA01c,28.5,2017/03/26
And indeed they're even better than THv1 that was not handling weekend data for such RICs.
EXA01c is a "open access" RIC in DSS only, could this be the reason and we'd use the ValidationOptions for those instruments ? or to be more pragmatic we'd always use the ValidationOptions settings in all requests ?
many thanks in advance
Paolo
Best Answer
-
From REST API Reference Tree, the AllowHistoricalInstruments option allows import of historical instruments that cannot be validated in DataScope Select. Deselect this option to only allow import of instruments that can be validated via DataScope Select. Historical instruments will be ignored during the validation process.
CARR.PA can be validated in DataScope Select. You can find CARR.PA by using Instrument Search.
However, for EXA01c, it returns "No securities found.".
0
Answers
-
EXA01c is a historical instrument.
You can verify this by using HistoricalSearch.
{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Search.HistoricalSearchResult)",
"value": [
{
"Identifier": "EXA01c",
"IdentifierType": "Ric",
"Source": "",
"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxFWEEwMWN8",
"Description": "Historical Instrument",
"InstrumentType": "Unknown",
"Status": "Valid",
"DomainCode": "6",
"FirstDate": "2002-03-19T00:00:00.000Z",
"LastDate": "2017-04-18T00:00:00.000Z",
"History": []
}
]
}This is why you need to set AllowHistoricalInstruments to true when creating ElektronTimeseriesExtractionRequest. Therefore, for historical instruments, you need to use this AllowHistoricalInstruments for all requests.
2 -
Thanks Jirapongse, i think we'll just use by default those ValidationOptions on ElektronTimeseriesExtractionRequest .
Indeed also RIC such as CARR.PA as in the original tutorial step 7b do appear as "Historical Instrument" when running the HistoricalSearch and yet the example in the tutorial works fine also without ValidationOptions
0 -
Thanks Jirapongse, that seems to confirm my initial guess that the AllowHistoricalInstruments option is mandatory for "Open Access" instruments (where the search is not supported in DSS) . However as far as i know programmaticaly discovering such attribute would imply a DSS intraday request and checking result of Asset SubType field, so we'll get back to the plan to set the AllowHistoricalInstruments option by default.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛