Allow multiple results (RIC) from the same source from Datascope using Report Template
I need to get all the RICs of an ISIN by extracting the datascope using Report Template.
For example, the ISIN ARARGE3209S6 has 6 RICs from the MAE source and the extraction returns only the Primary RIC from the source.
Best Answer
-
Hello @leaperez ,
The search request type that you request via DSS GUI is GovCorp search, with option "allow multiple results from same source".
From reviewing DSS REST API Reference Tree -> GovCorpSearch spec, I do not find this option or analogous, exposed.
I fully agree with @jirapongse.phuriphanvichai on the approaches to searches available.
Additionally, you may wish to review HistoricalReferenceExtractionRequest:
{{protocol}}{{host}}{{api}}Extractions/ExtractWithNotes
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
"ContentFieldNames": [
"RIC", "Exchange Code"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "ARARGE3209S6", "IdentifierType": "Isin"}
],
"ValidationOptions": {"AllowHistoricalInstruments": "true"},
"UseUserPreferencesForValidationOptions": "false"
},
"Condition": {
"StartDate": "2021-05-01T09:30:00.000Z",
"EndDate": "2021-06-06T17:00:00.000Z"
}
}
}From my testing, the result includes multiple RICs from the same source:
RIC,Exchange Code,User Defined Identifier,User Defined Identifier2,User Defined Identifier3,User Defined Identifier4,User Defined Identifier5,User Defined Identifier6
ARAL30=,,,,,,,ISN|ARARGE3209S6|
ARAL30=BA,,,,,,,ISN|ARARGE3209S6|
ARAL30=FCMX,,,,,,,ISN|ARARGE3209S6|
ARAL30=IAMC,,,,,,,ISN|ARARGE3209S6|
ARAL30=IAMD,,,,,,,ISN|ARARGE3209S6|
ARAL30=ITAU,,,,,,,ISN|ARARGE3209S6|
ARAL30=ME,,,,,,,ISN|ARARGE3209S6|
ARAL30=RC,,,,,,,ISN|ARARGE3209S6|
ARAL30=RRBB,,,,,,,ISN|ARARGE3209S6|
ARAL30=RRPS,,,,,,,ISN|ARARGE3209S6|
ARAL301=BA,,,,,,,ISN|ARARGE3209S6|
ARAL301=ME,,,,,,,ISN|ARARGE3209S6|
ARAL301=RC,,,,,,,ISN|ARARGE3209S6|
ARAL303=BA,,,,,,,ISN|ARARGE3209S6|
ARAL303=DSUR,,,,,,,ISN|ARARGE3209S6|
ARAL303=ME,,,,,,,ISN|ARARGE3209S6|Hope this helps
0
Answers
-
You can refer to the ISIN to RIC conversion with the DSS (DataScope Select) REST API article in the Finding the RIC(s) for one or more exchanges for an ISIN section.
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
- 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 中文论坛