Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
polyuaf2 avatar image
1 ●1 ●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
34ec1a29f4b0e275b5a8edc75d1619d.png (16.6 KiB)
ce5544660cabf42086dfcff26c2fa47.png (87.5 KiB)
icon clock
10 |1500

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

zoya faberov avatar image   zoya faberov

Hello @polyuaf2 ,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Shadab Hussain avatar image   Shadab Hussain

Hi @polyuaf2,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS


1 Answer

· Write an Answer
Upvote
Accepted
jason.ramchandani01 avatar image
10.2k ●18 ●6 ●9

@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)
icon clock
10 |1500

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

student0113 avatar image 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:

1703779472756.png

Can you help me to understand what I should do?

Thank you!


1703779472756.png (70.0 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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