Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TRTH /
avatar image
Question by sanchezTJUK · Apr 28, 2021 at 10:55 AM · tick-history-rest-apiextraction

"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"
        }
    }
    }

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya faberov · Apr 28, 2021 at 03:43 PM

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:

  1. 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.
  2. 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.
  3. 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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

Data Extraction issue with Reuters DSS C# API

ThomsonReuters Request Examples

AWS File Extraction not working properly

Working R examples for Eikon with Lipper data

Error pulling data using extractionsContext.ExtractRaw

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges