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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
43 2 1 7

Build hierarchy data from Organisation Hierarchy API data

I am able to get the data from API.


What is the meaning of below ids for a given company?

"Related OrgID" vs "Immediate Parent OrgID" vs "Derived Parent OrgID"

"Ultimate Parent OrgID" vs "Derived Ultimate Parent OrgID"

You can take the example from attached screenshot (markers : 1,2,3)


For building the hierarchy tree, we need 2 types of ID:

1. ultimate_parent : top node of the tree, which OrgID to be used here?

2. direct parent : immediate owner/parent of a given company/node which OrgID to be used here?


Any general example and one example based on the attached screenshot will help to understand:

dss-rest-apidatascope-selectdss
1621255931537.png (133.7 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
23k 22 9 14

Hello @vijay.singh,

Refinitiv DataScope Select Data Content Guide -> Field Descriptions tab is my go-to reference to identify DSS content (am a developer).

In this case, I suspect that Legal Entity Detail -> Ultimate Parent OrgID and -> Immediate Parent OrgID should be it:


I.e. the request will be:

{
                {protocol}}{
                {host}}{
                {api}}Extractions/ExtractWithNotes 

 "ExtractionRequest": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityDetailExtractionRequest",
    "ContentFieldNames": [
        "Official Name",
        "Entity ID",
        "ID",
        "ID Type",
        "Immediate Parent OrgID",
        "Ultimate Parent OrgID"
    ],
    "IdentifierList": {
      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EntityIdentifierList",
      "EntityIdentifiers": [
          { "Identifier": "111397695", "IdentifierType": "OrgId" }
      ]
    },
    "Condition": {
      "DeltaDays": "5000"
    }
  }
}

Resulting in:

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "OrgId",
            "Identifier": "111397695",
            "Official Name": "Tencent Cloud (Beijing) Co., Ltd.",
            "Entity ID": "0x0003f8059f205918",
            "ID": "111397695",
            "ID Type": "ORG",
            "Immediate Parent OrgID": "106314539",
            "Ultimate Parent OrgID": "100421204"
        }
    ],

In this case, for me, the unobvious part is "DeltaDays", without this caluse the response is empty and in Notes it indicates "no changes".

However, for an authoritative consultation on content, as a customer, the best and most efficient approach is to contact Refinitiv content experts directly at Refinitiv Helpdesk Online -> Content -> DSS


icon clock
10 |1500

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

Click below to post an Idea Post Idea