How can I use the Refinitiv API to get all the fields for a bond
Hi,
I am trying to get all the information for a bond such as identifiers, issue date, Subtype, effective date for a bond. I have the ISIN.
How do I do this using the Refinitiv API (either DSS or Eikon)?
Best Answer
-
Hello @Ratnakar ,
Would like to suggest reviewing the following DSS REST approach.
Please refer to DSS REST API Reference for Terms & Conditions request and response. Does this information satisfy your requirement? If yes, then REST API Tutorial 7: On Demand T&C extraction and .Net SDK Tutorial 8: On Demand: Terms & Conditions show how to implement this request programmatically, with and without DSS .Net SDK.
In tutorial, please also note call Tuto-7a: List available fields for Terms & Conditions
{{protocol}}{{host}}{{api}}Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'TermsAndConditions')
this is another way to reference all available fields for the request and cross-check them against your requirements, via DSS REST.
ISIN is one of the identifiers that can be used to request T&C via DSS REST, for example:
{{protocol}}{{host}}{{api}}Extractions/ExtractWithNotes
{
"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": "00209tab1", "IdentifierType": "Cusip" },
{ "Identifier": "IBM.N", "IdentifierType": "Ric" },
{ "Identifier": "US4592001014", "IdentifierType": "Isin" },
{ "Identifier": "B1YW440", "IdentifierType": "Sedol" }
]
}
}
}0
Answers
-
Hello @Ratnakar ,
Using Eikon Data API you have an option of using Data Item Browser tool in Eikon desktop or Refinitiv Workspace desktop to select an instrument, in your case, select bond by ISIN, and to explore all the fields that are available for the instrument via Eikon Data API.
For example:
Using DIB to select a bond and examining all the available fields. These fields will be available to you for retrieval using Eikon Data API.
For example:
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
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 651 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
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛