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
REFINITIV
Question by Paulo Leite · Jan 28, 2019 at 01:35 PM · dss rest apirest apijson

Why when pulling data using the RIC the values are correct but it is showing Null when using the ISIN?

Please find below an answer from a request using the DSS REST API.

You can notice that when I used the RIC as the identifier the values are correct, but when I use the ISIN as the identifier the values are null. It is also strange the when I use the ISIN for the identifier it returns another RIC instead of the EWZ. Could you please advise?

{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "EWZ",
"RIC": "EWZ",
"ISIN": "US4642864007",
"Security Description": "ISHARES MSCI BRAZIL ETF",
"Ask Price": 43.64,
"Bid Price": 43.63,
"High Price": 43.95,
"Low Price": 43.22,
"Open Price": 43.38,
"Close Price": 43.65,
"Universal Ask Price": 43.64,
"Universal Bid Ask Date": "2019-01-24",
"Universal Bid Price": 43.63,
"Universal Close Price": 43.65,
"Trade Date": "2019-01-24"
},
{
"IdentifierType": "Isin",
"Identifier": "US4642864007",
"RIC": "LP40056869",
"ISIN": null,
"Security Description": null,
"Ask Price": null,
"Bid Price": null,
"High Price": null,
"Low Price": null,
"Open Price": null,
"Close Price": null,
"Universal Ask Price": null,
"Universal Bid Ask Date": null,
"Universal Bid Price": null,
"Universal Close Price": null,
"Trade Date": null
}
],

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.

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by nityanand.koppad · Jan 28, 2019 at 01:41 PM

@Paulo Roberto.Leite

Please include source in your instrument list.

{
  "Identifier": "US4642864007",
  "IdentifierType": "Isin",
  "Source":"PCQ"
}
Comment
Paulo Leite

People who like this

1 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 Paulo Leite · Jan 28, 2019 at 02:39 PM

it worked!! great! Thanks!

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 Paulo Leite · Jan 30, 2019 at 12:49 PM

@nityanand.koppad Client is questioning whether he should always include the "Source: PCQ" when pulling data using the ISIN as the identifier and if the source is the same for all assets? He also argues that he had pulled other 190 assets using ISIN without the "Source" and it has worked fine.

Thanks in advance

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 nityanand.koppad · Jan 30, 2019 at 01:24 PM

@Paulo Roberto.Leite

If client is using ISIN then including source will extract accurate/relevant data for the exchange/asset. Here Source is nothing but Exchange Code, using exchange code is important while using ISIN as instrument input because there could be more chances of ISIN being dual listed, shared with other asset class (Bonds, Fund, Class Share or Preference Share etc). If ISIN is shared with different asset & listed in different exchange then ISIN's last result default will be used to extract data and this is the hierarchy of search functionality. example below


ewz.png (80.5 KiB)
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 dawat1354 · Mar 03, 2020 at 05:43 PM

How do i do the same for EIKON ? I am having similar problem pulling data from EIKOn with ISIN where the values returned are nulls for some instrument but when queried with RIC's the values returned are ok.

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

Related Questions

In DSS REST API, how can I specify the source for a CUSIP?

DNS are not resolving ip behind DDirect name select.datascopeapi.extranet.reuters.biz correct, server will not be able to use internet/*.com.

Calling the API for specific ccy pairs

fx rate extraction

why to say "Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken"

  • 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