How to add the document type filter condition in News Headline function?

Hi,

I have tried to pull the news headlines by adding some filter conditions. Below is my code:

Instrument = 'AAPL.O';

language = 'L:EN';

SourceCode = 'NS:RTRS';

documentType = 'Story';

C = 100;

query = [Instrument,' and ',language,' and ',SourceCode,' and ',documentType]

Data = get_news_headlines(query,C)

When i not added the 'documentType' in the query variable, get_news_headlines function returns the value. When i added 'documentType', function returns empty result. Do i need to refer the documentType in aother way? Could you please anyone help on this?


Thank You,

Priya

Best Answer

  • chavalit-jintamalit
    Answer ✓

    Hi @priyanka

    I am not familiar with documentType in news query syntax.

    Do you mean you want to get news story?

    So first, you should get the list of news headlines according to your news query.

    image

    Each news headline will have story ID, you can make an API call to get news story from the story id.

    Here is sample code to retrieve 2 news stories.

    image


Answers

  • priyanka
    priyanka Newcomer

    Hi,

    Thank you for the prompt reply. Sorry, i am not fully enter the code. below function format i have used.

    Data = get_news_headlines(query,C,raw_output = true)

    I retrieve the headlines output as json format. then i convert this json format to table. Plesae see the below sample result.

    image

    I need to apply the filter condition based on language, source code and document Type when send the API request to get the news headlines data.

    Thank You,

    Priya

  • Hi @priyanka

    You should use the "News Monitor" app on Eikon Desktop to explore what can be filtered out by the query.

    Or if you want to filter out on the JSON output from the get_news_headlines(), it should be done on your coding.

    This is just an example.

    df = ek.get_news_headlines('R:AAPL.O AND Language:LEN AND Source:RTRS', raw_output=True)

    storyList = []

    for headline in df['headlines']:
            if (headline['documentType']=='Story'):
                storyList.append(headline)
               
    print(storyList)