eikon.pngHi, I am looking at a company's page in Eikon (see attached) and there is a function to export the tree structure of the company's parents and subsidiaries to excel file. Is there a way to pull the same using DSS or other APIs?
For a deeper look into our DataScope Select REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
84
●4 ●4 ●8
Finding all parents and subsidiaries
@Alan Kar Lun.Tam - This is a private post
Would you mind if we make this query public ? There is no reason to make it internal, customers could benefit from reading this.
13.7k
●26 ●8 ●12
In the DSS GUI
Search for the instrument, then click on it to see the details. Select Legal Entity in the left menu bar. Then select More Entity Details (again in the left menu bar). Then select Hierarchy. For 0700.HK that will take you here:
In the DSS API
Use a Legal Entity Hierarchy extraction request.
The entire list of available content field names can be retrieved using a GET to this endpoint:
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ReportTemplateTypes'LegalEntityHierarchy')
Here is a call for a subset of those fields:
{
"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 }
}
}
Note on DeltaDays: this allows to choose how far back to look for changes, in days:
- -1 => anytime
- 0 => today
- 1 => since yesterday
- 2 => within 2 days
- etc.
Here is the first element of the result:
{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "OrgId",
"Identifier": "100421204",
"Node/Level": "a",
"Official Name": "UBISOFT ENTERTAINMENT S.A.",
"Relationship Type": "IsAffiliatedWith",
"Derived Parent Official Name": "UBISOFT ENTERTAINMENT S.A.",
"Derived Ultimate Parent Official Name": "UBISOFT ENTERTAINMENT S.A.",
"Immediate Parent Official Name": "UBISOFT ENTERTAINMENT S.A.",
"Ultimate Parent Official Name": "UBISOFT ENTERTAINMENT S.A.",
"Related Official Name": "TENCENT HOLDINGS LIMITED"
},
This is in JSON format, but it is easy to programmatically save that to file in CSV format if that is the aim. Hope this helps.
