"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
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 280 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 720 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛