For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

polyuaf2 avatar image
1 0 1 1

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

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.

34ec1a29f4b0e275b5a8edc75d1619d.png

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.

ce5544660cabf42086dfcff26c2fa47.png

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.

eikoneikon-data-apiema-api
10 |1500

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

1 Answer

jason.ramchandani01 avatar image
7.4k 10 6 8

@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

1653482496312.png

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

1653482600884.png

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


1653482496312.png (151.3 KiB)
1653482600884.png (188.9 KiB)
10 |1500

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