Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by everton.solon · Nov 18, 2020 at 03:19 PM · dss rest api

DSS API DLL - TermsAndConditionsExtractionRequest didn't find RIC but it exists

I'd like to understand why many ISINs that we sent via DSS Rest API dll returned with the message "not found", but doing a new search today in Datascope Select: , were found.


Here are some samples of ISINs but there are many more:

BRBMEFCIVG54 - Not found at 2020-11-10 19:34:51.897

BRBMEFC20XA3 - Not found at 2020-11-11 18:35:09.103

BRBMEFVX2384 - Not found at 2020-11-12 19:05:39.650

BRBMEFC30XC8 - Not found at 2020-11-12 19:35:45.433

BRBMEFV30X36 - Not found at 2020-11-12 19:35:45.433


In the line below, we're using TermsAndConditionsExtractionRequest.

var extractionRequest = new TermsAndConditionsExtractionRequest
{
    IdentifierList = InstrumentIdentifierList.Create(instrumentIdentifierList, null, false),
    ContentFieldNames = new[] { "RIC", "Trading Status" }
};

var extractedRows = ExtractionsContext.Extract(extractionRequest).ToArray();


Best regards.

evidencia-20201118-isins-not-found.png (44.6 KiB)

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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya.farberov · Nov 18, 2020 at 07:41 PM

Hello @everton.solon,

This is a different story. If you are facing an issue that only manifests once, or seldom, and does not reproduce on demand (i.e. currently you are finding all these RICs via API?) when you see this type of issue, you should request with extraction notes, and immediately open a support inquiry with Refinitiv Helpdesk Online including you job ID and extraction notes. Then DSS support can investigate the specific request, result and the issue.

This forum is best suited for general questions and discussions around Refintiiv APIs, it will not be very helpful for time-sensitive issues that require environment-specific investigation or product outage reports. If you happen to have extraction notes and job Ids, for these requests, you will still be able to proceed on the inquiry.

---

Let me mention on a related topic, I think you are referring to "ThomsonReuters.DSS.RestAPI.Client.dll" that is part of DSS .Net SDK, as "DSS API DLL - TermsAndConditionsExtractionRequest " did not come with SDK installation, so potentially it may be a custom DLL that was developed by your organization as ease of use tier on top of DSS .Net SDK.

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.

avatar image
REFINITIV
Answer by zoya.farberov · Nov 18, 2020 at 04:36 PM

Hello @everton.solon,

I have tested TermsAndConditions with a couple of the same ISINs:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                { "Identifier": "BRBMEFCIVG54", "IdentifierType": "Isin" },
                { "Identifier": "BRBMEFC20XA3", "IdentifierType": "Isin" }
            ]
        }
    }
}

They come back as valid for me:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Isin",
            "Identifier": "BRBMEFCIVG54",
            "RIC": "IDI293300J1",
            "CUSIP": null,
            "ISIN": "BRBMEFCIVG54",
            "SEDOL": null,
            "Issuer OrgID": null,
            "Currency Code": "BRL"
        },
        {
            "IdentifierType": "Isin",
            "Identifier": "BRBMEFC20XA3",
            "RIC": "DS25075A1",
            "CUSIP": null,
            "ISIN": "BRBMEFC20XA3",
            "SEDOL": null,
            "Issuer OrgID": null,
            "Currency Code": "BRL"
        }
    ],
...

However, just a thought, if you are using our C# Datascope REST Example GUI, please make sure you remove various conditions from the request that would be included by default, for example:

var extractionRequest = new TermsAndConditionsExtractionReque {
     IdentifierList = InstrumentIdentifierList.Create(
                    new[] { new InstrumentIdentifier { Identifier = "BRBMEFCIVG54", IdentifierType = IdentifierType.Isin} }, null, false),
                ContentFieldNames = new[] {
                    "Conversion Terms End Date", "Index Principal Flag", "Conversion Terms Start Date", "RIC", "Round Lot Size",
                    "Redemption Value", "Original Issue Amount", "Issue Price", "First Coupon Date", "Issue Date", "Par Value",
                    "Accrual Date", "Base Index", "Factor", "Original Issue Discount Flag", "End Of Month Payment Flag", "ISIN",
                    "Index Linked Bond Base Index", "Coupon Frequency Description", "Total Amount Outstanding", "Maturity Date",
                    "Total Amount Issued", "Capitilization Flag", "Currency Code", "Trading Status"},
                Condition = new TermsAndConditionsCondition
                {
                    IssuerAssetClassType = IssuerAssetClassType.AllSupportedAssets,
                    ExcludeWarrants = false/*,
                    //DaysAgo = 3, //Use either DaysAgo or StartDate
                    StartDate = new DateTimeOffset(new DateTime(2015, 1, 1)),
                    FixedIncomeRatingSources = FixedIncomeRatingSource.StandardAndPoors,*/
                }
            };

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.

avatar image
Answer by everton.solon · Nov 18, 2020 at 07:28 PM

Hi @zoya.farberov

I appreciate your quick response.


The sample ISINs for my question were consulted by "DSS API DLL - TermsAndConditionsExtractionRequest" on the dates and times mentioned in each row shown.


For example:

ISIN BRBMEFV30X36, from image, was consulted on November 12 at 7:35 pm. On this day and time, the RIC was not found by "DSS API DLL - TermsAndConditionsExtractionRequest".


Today, using the Datascope Select tool on the "https://hosted.datascope.reuters.com/";, it was found.

I would like to understand the reason. Is there a delay in creating the "RICS"? If so, how long would it be?


I am not using any conditions in the "DSS API DLL - TermsAndConditionsExtractionRequest"

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.

avatar image
Answer by everton.solon · Nov 18, 2020 at 07:54 PM

Hi @zoya.farberov


I will contact the customer support team to try to clarify this question.

"DSS API DLL - TermsAndConditionsExtractionRequest" was a way that I found to say I'm using "ThomsonReuters.DSS.RestAPI.Client.dll".

Thank you very much for your support.
Best regards.

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 >
13 People are following this question.

Related Questions

'Connection aborted.', ConnectionResetError(10054)

Extract SPX members Intraday bars

Missing "Current RIC" Column in Intraday Summaries Response

Could you please advise the reason for sending request failed error ? or is there any DSS rest API down yesterday(24/09/2020) at 4:30 PM EST ?

Thomson Reuters Premium Pricing extract

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • 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
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges