Build hierarchy data from Organisation Hierarchy API data

Options
vijay.singh
vijay.singh Explorer
in DSS

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:

image

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    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:

    image

    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

Categories