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 aleksandra.kluczniak_refinitiv · Mar 02 at 08:01 PM · dss rest api

DSS REST API - Entity/Instrument List automated update

Question about DSS REST API for a client, whose universe of Legal Entities is changing on a baily basis. Although it refers to EntityList specifically, but the same applies to InstrumentList.


Client is not happy with the fact that when using REST API, he has to build a new EntityList for every API call. Instead, he would like to insert an EntityList ID into API request/call – this list would be updated on a daily basis. So he would like to use a similar mechanism as with FTP, where the list of instruments/entities is updated on client’s server and linked to DSS schedule.


Is there a way that within the request (API call) the user can point to ‘EntityList’ Id, instead of having to build the standard request (API call) with all the entity Ids enumerated within?


People who like this

0 Show 1
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.

avatar image
REFINITIV
zoya.farberov ♦♦ · Mar 02 at 08:32 PM 0
Share

Hello @aleksandra.kluczniak_refinitiv,

Can we please confirm, which part fails for the client?

They are using scheduled extraction request, not on demand ad-hoc, right?

They have created an EntityList?

They are submitting ListId of their EntityList into Schedule->Create?

They update EntityList?

Please provide any details that are relevant to better understand the issue,

Thanks


1 Reply

  • Sort: 
avatar image
Best Answer
Answer by marc.defilippis · Mar 03 at 05:39 AM

Below an example, the training reference are the 2 links below:

GetByName https://hosted.datascopeapi.reuters.com/RestApi.Help/Context/Operation?ctx=Extractions&ent=EntityList&opn=GetByName

ReplaceAllWithIdentifiersWithOptions https://hosted.datascopeapi.reuters.com/RestApi.Help/Context/Operation?ctx=Extractions&ent=EntityList&opn=ReplaceAllWithIdentifiersWithOptions


Example:


I created an entity list named Aleksandra_Entities:



First get the entity List ID by making a GET on:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/EntityListGetByName(ListName='Aleksandra_Entities')


answer is:

{

"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#EntityLists/$entity",

"ListId": "0x0776a0a40a974ddd",

"Name": "Aleksandra_Entities",

"Count": 1,

"Created": "2021-03-03T05:02:08.903Z",

"Modified": "2021-03-03T05:02:47.973Z"

}


Then to update it [in a FTP like fashion which is a full replace] use the following [I am replacing adidas with puma and Nike in the list]

POST on https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/EntityLists('0x0776a0a40a974ddd')/ThomsonReuters.Dss.Api.Extractions.EntityListReplaceAllWithIdentifiersWithOptions

With the following payload:


{

"Identifiers": [

{

"Identifier": "NKE",

"IdentifierType": "Ric",

"UserDefinedIdentifier": "UserIdentReplace"

},

{

"Identifier": "PUMG.DE",

"IdentifierType": "Ric",

"UserDefinedIdentifier": "UserIdentReplace"

}

],

"Options": {

"AllowDuplicateInstruments": false,

"IncludeParentAndUltimateParent": false,

"AllowUnmanagedOrUnverifiedEntities": true

}

}



Then the list is updated:





1614749974274.png (29.5 KiB)
Comment
aleksandra.kluczniak_refinitiv
zakaria.angelo1

People who like this

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

Related Questions

DSS API ExtractRaw Not able to zip small set of data in csv - Even for single ric request

Stocks "not found" in DSS API Terms and Conditions request answer

DSS REST API error message: «ThomsonReuters.Dss.Api.NotFoundException: ExtractedFile of id 'VjF8fDQxMjQ5NDIxNw' not found».

Pagination issue with Search/EquitySearch

I couldn't connect to DSS with DSS REST API

  • 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
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • 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