How to find a web URL for news using Eikon story id or URN

vippsworld
vippsworld
in Eikon Data APIs

Hello,

I am trying to find a way if I can get Web URL from a URN or story ID that is available inside EIKON.
For example there was news dated today 18 May 2021 with headline

"Euro zone inadvertently supported zombie firms, ECB finds"

The above news headline has a story id/urn :"urn:newsml:reuters.com:20210518:nlXXXXXXXX:3" & similarly the news is available on its webpage with link as
https://www.reuters.com/article/us-ecb-policy-zombies-idUSKCN2CZ0QP

In the above case what is the way through EIKON API I can get the relevant URL, so that the same news can be read via webpage. Please assist.

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01
    Answer ✓

    @tushar.shetty1 So as far as I am aware there is no such systematic link between our storyId's and reuters.com links. Also please be aware that not all of the Reuters News is available on the free to use public site - so I'm not sure how that would work in any case.

Answers

  • jason.ramchandani01
    jason.ramchandani01

    @vippsworld News story items usually contain some links to the news article source. We can use the BeautifulSoup package to extract any href links for the news story and store those as a column in our original headlines frame. Check the following:

    from bs4 import BeautifulSoup
    df = ek.get_news_headlines('zombie companies',count=10)
    df

    image

    So now we have our headlines frame we can request the story and extract any links we have:

    df['Links']=""
    for idx, story in enumerate(df['storyId']):
        soup = BeautifulSoup(ek.get_news_story(story))
        links=[]
        for a in soup.find_all('a', href=True):
            links.append(a['href'])
        df['Links'][idx] = links

    df

    image

    its important to note not all stories will have source references and other links may be present - but you can do more complex link filtering.

    I hope this can help.

  • Unknown
    Unknown

    @jason.ramchandani: Thanks for that elaborate solution. However @vippsworld is mostly interested in the Reuters Stories for which there seem to be no links available. So is there a way to use what we have ( news code / Pnac ] to get to the Reuters url for them.

Categories