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 stas.grinberg · Sep 26, 2019 at 02:15 PM · dss list all instruments api

How to get all instruments by API request for a list created manually in DSS (not a count as mentioned in tutorial for API DSS )

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Sep 26, 2019 at 02:46 PM

@stas.grinberg,

If I understand correctly, you want to use the API to retrieve the list of instruments in an instrument list stored on the server.

For this you need the instrument list ID.

Step 1: get the instrument list ID from the instrument list name

If you only have the list name, you can retrieve the ID using the GetByName call:

GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/InstrumentListGetByName(ListName='MyListName')

This delivers the ListId:

{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#InstrumentLists/$entity",
"ListId": "0x066c72ea4b60201a",
"Name": "MyListName",
"Count": 2,
"Created": "2018-10-03T16:59:07.670Z",
"Modified": "2018-10-03T16:59:29.986Z"
}

Step 2: get all instruments in the instrument list stored on the server

You can use the GetAllInstruments call (replace the InstrumentList Id value by the ID of your own list):

GET https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/InstrumentLists('0x066c72ea4b60201a')/ThomsonReuters.Dss.Api.Extractions.InstrumentListGetAllInstruments

The result will contain a set of records, one per instrument. Each record contains the Identifier, IdentifierType, etc. Here is an extract of a sample output:

{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#InstrumentListItems",
"value": [
{
"ListId": "0x066c72ea4b60201a",
"Identifier": "SARON.S",
"IdentifierType": "Ric",
"Source": "SWX",
"UserDefinedIdentifier": "",
"UserDefinedIdentifier2": "",
"UserDefinedIdentifier3": "",
"UserDefinedIdentifier4": "",
"UserDefinedIdentifier5": "",
"UserDefinedIdentifier6": "",
"Order": 4,
"Description": "SARON Swiss Average Rate ON",
"InstrumentListItemKey": "VjF8MHgwNjZjNzJlYTRiNjAyMDFhfDQ",
"InstrumentKey": "VjF8MHgwMDEwMGIwMDAzN2Y5YjhhfDB4MDAxMDBiMDAwZjVkYWIxMnxTV1h8TU5RVXxNT05ZfE1PTll8WXx8U0FST04uU3wzNjk4"
},
...
]
}

Is this what you were searching for ?

Comment
xds-support

People who like this

1 Show 4 · 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
xds-support · Dec 30, 2020 at 01:37 PM 0
Share

@Christiaan Meihsl Hi, i tried the way you suggested it worked but i am wondering how can i use this API call GetAllInstrumentsListItems. When i hit this urr directly it results in err "message": "InstrumentListItem's must be retrieved in the context of their InstrumentList". It expects instrument list id somehow, how can i pass it, i tried to put that using @odata.context but i din't work.

avatar image
REFINITIV
zoya.farberov ♦♦ xds-support · Jan 04 at 11:32 PM 0
Share

Hello @xds-support,

Questions with accepted correct answers are not actively monitored by this forum's moderators.

It is better to ask a new question as a new question, and to include the link to the related question in the question's body.

Try:

GET {
                     {protocol}}{
                     {host}}{
                     {api}}Extractions/InstrumentLists('{
                     {listId}}')/ThomsonReuters.Dss.Api.Extractions.InstrumentListGetAllInstruments 

Where listId is the Id of your created list.

avatar image
xds-support zoya.farberov ♦♦ · Jan 05 at 05:26 AM 0
Share

Thanks Zoya, As i already stated that the above solution works fine but how can i use rest endpoint in context with instrument list, mentioned in API TREE here

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