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 · Sep 26, 2020 at 08:41 PM · dss rest api

How to make DSS API fetch the correct RIC from a list of 3?

I'm using DSS API dlls to fetch a list of Rics from a list of Isins.
However, the DSS API is fetching the first row from the list. But how to know if it is the right one?

My code:

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

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


What DDS API is fetching:


From Datascope Select:

In the list above, there are 3 RICs but the API is fetching only the first one.

Is this the right one?

How to know it?






evidencia-20200926.png (128.0 KiB)
evidencia-20200926-2.png (68.9 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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Sep 28, 2020 at 09:36 AM

@everton.solon

From my checking, BRBMEFBGI5M6 can be mapped to the following RICs: [BGIU20, 1BGIU20, 2BGIU20].

Refer to the ISIN to RIC conversion with the DSS (DataScope Select) REST API article, TermsAndConditionsExtractionRequest can be used to retrieve a primary RIC for an ISIN.

To get all RICs for an ISIN, you need to use other endpoints, such as SearchContext.InstrumentSearch.

For example:

{
  "SearchRequest": {
    "InstrumentTypeGroups": [
      "CollatetizedMortgageObligations", "Commodities", "Equities", "Funds",
      "FuturesAndOptions", "GovCorp", "Money", "MortgageBackedSecurities",
      "Municipals"
    ],
    "IdentifierType": "Isin",
    "Identifier": "BRBMEFBGI5M6",
    "PreferredIdentifierType": "Ric"
  }
}

The above request returns:

 "value": [
        {
            "Identifier": "1BGIU20",
            "IdentifierType": "Ric",
            "Source": "BMF",
            "Key": "VjF8MHgwMDEwMGIwMDFmNTYwNzg3fDB4MDAxMDBiMDAxZjU2MDc4OHxCTUZ8REVSVnxERVJWfEZVVHxEfHwxQkdJVTIwfDUwNTU",
            "Description": "BGI OTFCTPL",
            "InstrumentType": "Derivative",
            "Status": "Valid"
        },
        {
            "Identifier": "2BGIU20",
            "IdentifierType": "Ric",
            "Source": "BMF",
            "Key": "VjF8MHgwMDEwMGIwMDFmNTYwNzg3fDB4MDAxMDBiMDAxZjU2MGVjMHxCTUZ8REVSVnxERVJWfEZVVHxEfHwyQkdJVTIwfDU0MTg",
            "Description": "BGI OTFCTPL",
            "InstrumentType": "Derivative",
            "Status": "Valid"
        },
        {
            "Identifier": "BGIU20",
            "IdentifierType": "Ric",
            "Source": "BMF",
            "Key": "VjF8MHgwMDEwMGIwMDFmNTYwNzg3fDB4MDAxMDBiMDAxZjU2MTA4YnxCTUZ8REVSVnxERVJWfEZVVHxEfHxCR0lVMjB8NTQxOA",
            "Description": "BGI OTFCTPL",
            "InstrumentType": "Derivative",
            "Status": "Valid"
        }
    ]

For more information, please refer to REST API Reference Tree.

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 · Sep 28, 2020 at 03:36 PM

@jirapongse.phuriphanvichai


"Refer to the ISIN to RIC conversion with the DSS (DataScope Select) REST API article, TermsAndConditionsExtractionRequest can be used to retrieve a primary RIC for an ISIN."


Article:

"A TermsAndConditionsExtractionRequest delivers for each input ISIN the primary RIC (except if you specified the source, see next section). It is also possible to retrieve the currency and exchange code.

A single call suffices for multiple ISINs."


My code:

In the line below, I'm using TermsAndConditionsExtractionRequest as mentioned in this post.

var extractionRequest = new TermsAndConditionsExtractionRequest
{
    IdentifierList = InstrumentIdentifierList.Create(instrumentIdentifierList, null, false),//<- instrumentIdentifierList, validationOptions, useUserPreferencesForValidationOptions
    ContentFieldNames = new[] { "RIC", "Trading Status" }
};
 
var extractedRows = ExtractionsContext.Extract(extractionRequest).ToArray();

However, it is not fetching for the primary RIC.


Comment

People who like this

0 Show 1 · 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
everton.solon · Sep 28, 2020 at 05:17 PM 0
Share

@jirapongse.phuriphanvichai

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

Related Questions

Get content for a specific date (or date range)

We are able to extract daily CDOR rates using EndOfDayPricingExtractionRequest . Here I have a question. Will API return only positive rate values or negative rate values also ?

Why DSS returns wrong ISIN code for composite?

I'm getting more rows that requested on bond ratings request over DSS REST API

TickHistoryTimeAndSalesExtractionRequest - Getting last price nearest to a date

  • 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