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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
84 3 4 7

Finding all parents and subsidiaries

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?

eikondss-rest-apidssdatascope-select
eikon.png (127.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Forgot to mention we actually have multiple clients asking for this.

1 Answer

Upvotes
Accepted
13.7k 26 8 12

@Alan Kar Lun.Tam,

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.


tencentgui.png (84.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

See also this query, on the same topic.