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 /

For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

avatar image
Question by BTh · Dec 05, 2018 at 08:20 AM · dss-rest-apidatascope-selectdss

How is the Legal Entity Hierarchy request working ?

What does one input in the request and what is the return containing ?

Does one enter an OrgID and get data about the whole tree structure containing this OrgID? What's the basic idea behind it? What's the "RCP ID" that seems to be an important field in that request?

Thanks for hints and info.

Bernard

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Dec 05, 2018 at 11:19 AM

RCP ID

Description of the RCP ID: "System-generated code used to uniquely identify a legal entity (resolving duplication)".

To get a field description you can either:

A) Create a request template in the GUI and select a field:

B) Run an API query to get the full list of fields and descriptions. In this case do a GET to this endpoint (note it contains the template name as parameter, at the end):

"https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'LegalEntityHierarchy')

Hierarchy positioning

In my response to the other query last November I just displayed the first item in the result set, but note the results are returned in no specific order. If you run that query and look at the Relationship Type field content you will see a list of IsAffiliatedWith entries, followed by a set of IsParentOf entries, which seems to confirm your suggestion that this request returns all entities below the input entity. I think you are right, but honestly, I'm not sure, that is a content query that I cannot answer. For that I suggest you directly contact the TRTH support team via MyRefinitiv. In the product field, select "Thomson Reuters Tick History v2".


rcp.png (40.9 KiB)
Comment

People who like this

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

avatar image
REFINITIV
Answer by Christiaan Meihsl · Dec 05, 2018 at 09:16 AM

@bernard.thouin,

The legal entity hierarchy allows you to see companies, who belong to them (subsidiaries), who they belong to (parents), and affiliates.

Here is an example body of the request using the API, using a RIC as the instrument identifier. I used the instrument 0700.HK which is Tencent Holdings, on the Hong Kong exchange:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.LegalEntityHierarchyExtractionRequest",
    "ContentFieldNames": [
      "Node/Level", "Official Name", "Relationship Type",
      "Derived Parent Official Name", "Derived Ultimate Parent Official Name",
      "Immediate Parent Official Name", "Ultimate Parent Official Name",
      "Related Official Name"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EntityIdentifierList", 
      "EntityIdentifiers": [ { "Identifier": "0700.HK", "IdentifierType": "Ric" } ]
    },
    "Condition": { "DeltaDays": -1 }
  }
}

The "DeltaDays": -1 condition means that we want all the historical data. If you only wanted the changes of the last N days, let us say the last week, you could set "DeltaDays": 7.

You can make the same request in the GUI, by searching for the instrument, then clicking on it. Then click in the left column menu on Legal Entity, then on More Entity Details, and finally on Hierarchy, which will take you here:

I don't see any RCP ID in the request parameters. Can you tell me where you found it ?


tencentgui.png (84.8 KiB)
Comment

People who like this

0 Show 1 · 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
REFINITIV
Christiaan Meihsl ♦♦ · Dec 05, 2018 at 09:19 AM 0
Share

See also this query, on the same topic.

avatar image
Answer by BTh · Dec 05, 2018 at 09:56 AM

The RCP ID is a field mentioned in the DSS.Api.examples app for the LegalEntityHierarchy request:

ContentFieldNames = new[] {

"ID", "ID Type", "Immediate Parent ID", "Immediate Parent Official Name",

"Immediate Parent RCP ID", "Node/Level", "Official Name", "RCP ID",

"Source RCP ID", "Ultimate Parent ID", "Ultimate Parent Official Name", "Ultimate Parent RCP ID",

"User Defined Identifier"}

In your answer to the former query last November, you mention the "first element" of the response. Does that mean that basically this request returns all entities below the input entity, i.e. it should be used for the hierarchy "head" and delivers all the entities linked to this head ?

Bernard

Comment

People who like this

0 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 >
10 People are following this question.

Related Questions

How to download maintenance notes file from DSS

Getting Access to API Family

/Extractions/ExtractWithNotes answer time

Sample C# code that excludes deleted items when pulling data from DSS Corporate Actions table

PriceHistoryExtraction Request

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • 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
  • FX Venues
    • FX Trading – RFQ Maker
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • Yield Book Analytics
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges