"Historical reference request" is not returning any data
I do this extraction every day and there tends to be difficulties often. I'm not sure what I'm doing wrong. I put the extraction in a try/catch loop and it normally takes a few go's for it to return the data I want but today it's just stuck returning nothing. I'm the only one running the extraction, so it's not because there's more than one request being made at a time. My request code is below. The product RIC is LGOTJ1
HistRefUrl = 'https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes'
requestBody={
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
"ContentFieldNames": [
"RIC",
"Start date",
"Change Date",
"Expiration Date"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": ProductRIC,
"IdentifierType": "Ric"
}
],
"ValidationOptions": {
"AllowHistoricalInstruments": 'true'
},
"UseUserPreferencesForValidationOptions": 'false'
},
"Condition": {
"StartDate": "2012-01-01T00:00:00.000Z",
"EndDate": todaysDate + "T" + "00:00:00.000Z"
}
}
}
Best Answer
-
Hello @sanchezTJUK,
As a quick sanity check, to eliminate the possibilities of the RIC or code being mistyped or mis-pasted, I have just tested the same request with Postman tool :
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
"ContentFieldNames": [
"RIC",
"Start date",
"Change Date",
"Expiration Date"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "LGOTJ1",
"IdentifierType": "Ric"
}
],
"ValidationOptions": {
"AllowHistoricalInstruments": true
},
"UseUserPreferencesForValidationOptions": false
},
"Condition": {
"StartDate": "2012-01-01T00:00:00.000Z",
"EndDate": "2021-04-28T00:00:00.000Z"
}
}
}I have valid result:
{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "LGOTJ1",
"RIC": "LGOTJ1",
"Start date": null,
"Change Date": "2020-04-08",
"Expiration Date": "2021-04-12"
},
{
...This aligns with your understanding of the issue you face being intermittent. However, to me this does not clarify if it is due to potential connectivity interrupts, bandwidth or service outages. Especially as you report this as a common happening, this does not add up, for me.
The way I see it, it would be most useful, exactly when you face the issue, and it is reproducible, at least on your side, to:
- To review any potential service outages in progress via My Refinitiv Service Alerts. I personally always "Include resolved" as I wish to know if my issue has been resolved recently.
- If negative, investigate with your local network team if there are any outages in progress that they are aware of that are related to your network and internet connectivity.
- If negative, open a support ticket via Refinitiv Helpdesk Online to investigate the issue on our side while it is still happening.
If you post on the dev forums, we are glad to help verify the validity of the request, the API usage, but that will likely not be the most effective way to get to the cause of an intermittent issue.
I hope this helps
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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛