How can I get supply chain data of a company list using Eikon Data API

polyuaf2

Hi. How can I get supply chain information of a company list from EIKON API? I have a company list including Identifier and Company Name, as Fig.1 shows.

I want to search for the supply chain information like what I can get from the EIKON desktop, as Fig.2 shows, including Company, Type, Relationship, Country, Industry, Confidence Scores, Last UPdate, Freshness, Snipped Count, Revenues, EQ Scores, and Implied Rating.

Since I have thousands of companies, it is difficult to download one by one, so I think API may work. But didn't find a way to solve it.

jason.ramchandani01

@polyuaf2 thanks for your question. This can best be done using the RD library as follows:

import refinitiv.data as rd
from refinitiv.data.content import symbol_conversion

rd.open_session()

df = rd.get_data(
    universe=['ADSK.O'], 
    fields=['TR.SCRelationship','TR.SCRelationship.ScorgIDOut',
            'TR.SCRelationship.instrument','TR.SCRelationshipConfidenceScore','TR.SCRelationshipFreshnessScore','TR.SCRelationshipUpdateDate']
)

df.sort_values(by=['Value Chains Relationship Confidence Score'],ascending=False, inplace=True)
df

ricList = df['Related OrganizationID'].astype(str).tolist()

response = symbol_conversion.Definition(
    symbols=ricList,
    from_symbol_type=symbol_conversion.SymbolTypes.OA_PERM_ID,
    to_symbol_types=[
        symbol_conversion.SymbolTypes.RIC,
        symbol_conversion.SymbolTypes.ISIN
    ],
).get_data()

response.data.df

This should match the VCHAINS app output. I hope this can help.

student0113

Hello @jason.ramchandani01,

Thank you very much for your comment.

I have run exactly the code you suggested but I encounter the following error:

Can you help me to understand what I should do?

Thank you!