DSS Rest API returns None for content fields

The DSS Rest API returns no values for some ISINs even though there are values present in the composite template accessible through the DSS Web UI.
For example, for US46647PBW59:
Request:
@{'ExtractionRequest': {'@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest', 'ContentFieldNames': ['Fitch Rating', 'Moodys Rating', 'S&P Rating', 'Option Adjusted Duration', 'Option Adjusted Spread Duration', 'Econometric Corp Macaulay Duration', 'Econometric Corp Modified Duration', 'EOM OAS Duration', 'EOM Worst Corp Modified Duration', 'Maturity Corp Macaulay Duration', 'Maturity Corp Modified Duration', 'Maturity ISMA Macaulay Duration', 'Maturity
ISMA Modified Duration', 'Maturity Standard Macaulay Duration', 'Maturity Standard Modified Duration', 'Worst Corp Mac Duration', 'Worst Corp Modified Duration', 'Worst ISMA Macaulay Duration', 'Worst ISMA Modified Duration', 'Worst Standard Macaulay Duration', 'Worst Standard Modified Duration', 'Maturity Corp DV01', 'Maturity Standard DV01', 'Option Adjusted DV01', 'Worst Corp DV01', 'Worst ISMA Dv01', 'Worst Standard Dv01', 'Maturity Corp OTR Term', 'Maturity ISMA Dv01', 'Accrual Date', 'Accrued Interest', 'Ask Clean Price', 'Ask Dirty Price', 'Ask Price', 'Ask Yield', 'Bid Clean Price', 'Bid Dirty Price', 'Bid Price', 'Bid Yield', 'Current Yield', 'Current Yield To Maturity', 'Universal Close Price', 'Universal Close Price Date', 'Currency Code'], 'IdentifierList': {'@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList', 'InstrumentIdentifiers': [{'IdentifierType': 'Isin', 'Identifier': 'US46647PBW59'}]}, 'Condition': None}}
Response:
@{'@odata.context': 'https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult', 'Contents': [{'IdentifierType': 'Isin', 'Identifier': 'US46647PBW59', 'Fitch Rating': None, 'Moodys Rating': None, 'S&P Rating': None, 'Option Adjusted Duration': None, 'Option Adjusted Spread Duration': None, 'Econometric Corp Macaulay Duration': None, 'Econometric Corp Modified Duration': None, 'EOM OAS Duration': None, 'EOM Worst Corp Modified Duration': None, 'Maturity Corp Macaulay Duration': None, 'Maturity Corp Modified Duration': None, 'Maturity ISMA Macaulay Duration': None, 'Maturity ISMA Modified Duration': None, 'Maturity Standard Macaulay Duration': None, 'Maturity Standard Modified Duration': None, 'Worst Corp Mac Duration': None, 'Worst Corp Modified Duration': None, 'Worst ISMA Macaulay Duration': None, 'Worst ISMA Modified Duration': None, 'Worst Standard Macaulay Duration': None, 'Worst Standard Modified Duration': None, 'Maturity Corp DV01': None, 'Maturity Standard DV01': None, 'Option Adjusted DV01': None, 'Worst Corp DV01': None, 'Worst ISMA Dv01': None, 'Worst Standard Dv01': None, 'Maturity Corp OTR Term': None, 'Maturity ISMA Dv01': None, 'Accrual Date':
None, 'Accrued Interest': None, 'Ask Clean Price': None, 'Ask Dirty Price': None, 'Ask Price': None, 'Ask Yield': None, 'Bid Clean Price': None, 'Bid Dirty Price': None, 'Bid Price': None, 'Bid Yield': None, 'Current Yield': None, 'Current Yield To Maturity': None, 'Universal Close Price': None, 'Universal Close Price Date': '2023-10-18', 'Currency Code': 'USD'}], 'Notes': ['Extraction Services Version 17.3.46133 (6b8726ab2c9a), Built Aug 1 2023 18:07:45\r\nHoliday Rollover of Universal Close Price waived.\r\nProcessing started at 10/19/2023 14:54:03.\r\nUser ID: 9022998\r\nExtraction ID: 2000000628594701\r\nCorrelation ID: CiD/9022998/AAAAAA.08abac4540d930b6/RA\r\nSchedule: 0x08abac4540e930b6 (ID = 0x0000000000000000)\r\nInput List (1 items): (ID = 0x08abac4540e930b6) Created: 10/19/2023 14:54:03 Last Modified: 10/19/2023 14:54:03\r\nReport Template (50 fields): _OnD_0x08abac4540e930b6 (ID = 0x08abac45410930b6) Created: 10/19/2023 14:54:02 Last Modified: 10/19/2023 14:54:02\r\nSchedule dispatched via message queue (0x08abac4540e930b6)\r\nSchedule Time: 10/19/2023 14:54:03\r\nProcessing completed successfully at 10/19/2023 14:54:04, taking 0.436 Secs.\r\nExtraction finished at 10/19/2023 12:54:04 UTC, with servers: x05q22, QSDHA1 (0.0 secs), QSHC14 (0.0 secs)\r\nUsage Summary for User 9022998, Client 109974, Template Type Composite\r\nBase Usage\r\n Instrument Instrument Terms Price\r\n Count Type
Subtype Source Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n 1 Equities
N/A N/A\r\n-------\r\n 1 Total instrument charged.\r\n 0 Instruments with no reported data.\r\n=======\r\n 1 Instrument in the input list.\r\nNo Evaluated Pricing Service complex usage to report -- 1 Instrument in the input list had no reported data.\r\n']}
However, when we tried accessing data through the web client, we were able to get values for some of the fields like Fitch and Moodys Rating (see attached file).
How can we use the API to access this data?
Best Answer
-
Thank you for reaching to us.
You can try this one:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest",
"ContentFieldNames": [
"Fitch Rating",
"Moodys Rating",
"S&P Rating",
"Option Adjusted Duration",
"Option Adjusted Spread Duration",
"Econometric Corp Macaulay Duration",
"Econometric Corp Modified Duration",
"EOM OAS Duration",
"EOM Worst Corp Modified Duration",
"Maturity Corp Macaulay Duration",
"Maturity Corp Modified Duration",
"Maturity ISMA Macaulay Duration",
"Maturity ISMA Modified Duration",
"Maturity Standard Macaulay Duration",
"Maturity Standard Modified Duration",
"Worst Corp Mac Duration",
"Worst Corp Modified Duration",
"Worst ISMA Macaulay Duration",
"Worst ISMA Modified Duration",
"Worst Standard Macaulay Duration",
"Worst Standard Modified Duration",
"Maturity Corp DV01",
"Maturity Standard DV01",
"Option Adjusted DV01",
"Worst Corp DV01",
"Worst ISMA Dv01",
"Worst Standard Dv01",
"Maturity Corp OTR Term",
"Maturity ISMA Dv01",
"Accrual Date",
"Accrued Interest",
"Ask Clean Price",
"Ask Dirty Price",
"Ask Price",
"Ask Yield",
"Bid Clean Price",
"Bid Dirty Price",
"Bid Price",
"Bid Yield",
"Current Yield",
"Current Yield To Maturity",
"Universal Close Price",
"Universal Close Price Date",
"Currency Code",
"RIC"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"IdentifierType": "Isin",
"Identifier": "US46647PBW59",
"Source":"*"
}
]
},
"Condition": {}
}
}I will return several instruments for this ISIN.
0
Answers
-
@Jirapongse thank you for your response!
Is there a way to identify what source each instrument refers to? When I tried with the modified request dictionary, the response['Contents'] list contains 44 elements. Is there a way to map this to their respective sources and retrieve it?
0 -
Do you mean the "Exchange Code" content field?
"RIC": "US46647PBW59=TE",
"Exchange Code": "TWE"0 -
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
- 616 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
- 652 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 中文论坛