How to get a list of all levels of a company structure (TREE) in API?

How to get a list of all levels of a company structure (TREE) in API?


Here is the sample code:

df = rd.get_data('HSBA.L', ['TR.RelatedOrgId','TR.RelatedOrgName','TR.RelatedOrgType','TR.UltimateParent','TR.HeadquartersCity'])


In this example i only get the entities directly below HSBA.L and not thier entities also (the full tree). It also does not return the ultimate parent or HQcity for each entity as expected, only HSBA.L

Best Answer

  • Jirapongse
    Answer ✓

    @JoanneCamille.Andes

    Thank you for reaching out to us.

    This forum is dedicated to technical queries on Refinitiv product APIs. You need contact the helpdesk team via MyAccount and ask for the TR fields that can provide the required data. You can also try to retrieve the data through the Eikon Excel or Workspace Excel. Then, apply the same TR fields and paramters to the rd.get_data method.

    Morever, you can use the Data Item Browser tool to search for fields and parameters.