I'm using the eikon API to retrieve the subsidiary data from the refinitiv. I'm able to retrieve subsidiary information for level 1 subsidiaries only. I'm unable to retrieve the level2 or upto level n subsidiaries. I want my results to be in the form of dictionary. In short for a company tree, the result of the function should return dictionary.

For example, the output of retrieve_subsidiaries(['5000065135', '4298158727']) should be ...

{

'5000065135': ['5036778064', '5043368391', '5076086756', '5046707557', '', '5036778506', '5082358234']

'4298158727': []

}.

I have tried this. But unfortunately, the run time is also very high as there are multiple API requests being done.

I have tried this at my end. Is there any other way to address this issue?

def retrieve_subsidiaries(tcodes):
    subs_parameters = {
        'SDate': 0,
        'EDate': -3,
        'Curn': 'JPY',
        'Scale': 6,  
        'ReportType': 'Latest',       # Latest, Prelim, Final, All
        'ReportingState': 'Rsdt',    # Orig, Rsdt, All
        'FRQ': 'FY',
    }

    subs_fields = [
        'TR.OrganizationID',
        'TR.RelatedOrgId',
        'TR.RelatedOrgType',
    ]

    try: # Main part of the code
        display(tcodes)
        subs, err = ek.get_data(tcodes, subs_fields, subs_parameters)
        display(subs)
    except Exception as e:
        display(e)
        sys.exit(1)
        
    result = {}
    
    tcodes = [int(item) for item in tcodes_list]
    for tcode in tcodes:
        subsidiaries = subs[(subs['Instrument'] == tcode) & (subs['Related Org Type'] == 'Subsidiary')]['Related OrgId'].tolist()
        result[tcode] = [sub for sub in subsidiaries if sub]  
        
    return result, subs