question

Upvotes
Accepted
philip.user avatar image
1 ●0 ●0 ●2

Fetch news associated with RIC codes using RDP News API on T+1 basis

Hi,

We are currently managing a list of approximately 2000 RIC codes and are looking to streamline the process of retrieving related news for each code, on a T+1 basis. Our goal is to identify and fetch news from the prior day that is related to each RIC code.

We have not been able to find a working solution using the data/news/v1 API. One approach we considered involved fetching all headlines using the headlines endpoint with the available date range filter, then using the storyId of each headline to access the full news content, and finally for each story, we'd filter based on the RIC codes - including the ones that exist in our list and discarding the ones that does not exist. However, this method seems extremely inefficient and unlikely to be the best and only method out there.

Do you have any insights or recommendations on best practices for this or other more efficient ways within the API to fetch news with specific RIC codes for the previous day's coverage?

We appreciate all the help we can get, thank you in advance team.


eikon-data-apirdp-api#productrefinitiv-data-platformricsnews
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.

jonathan.legrand avatar image   jonathan.legrand
Hi @philip.user ,

Thank you for your participation in the Forum. Could you please let us know which answer, below, answers your query, if any, with the 'Accept' button to its left? Kind regards, AHS.

aramyan.h avatar image   aramyan.h

Hi,

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

Thank you,

AHS


2 Answers

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

Hi @philip.user ,

Have you had a look at the Refinitiv Data (RD) Library for Python? It offers functionalities such as the below; let me know if it helps:


import refinitiv.data as rd
rd.open_session()
df = rd.news.get_headlines("LSEG.L", start="2020-01-01", end="2024-01-01", count=3)
display(df)

1712913202837.png


1712913202837.png (47.4 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.

Upvotes
philip.user avatar image
1 ●0 ●0 ●2

Hi Jonathan,

Yes we had a look at the Library for python but our application is 100% Java. That's why we assumed we could not use those endpoints but only the ones in RDP News API. We haven't been able to find an equivalent library or functionalities within the RDP News API for Java.

Do you know if there is a similar library available for Java? Alternatively, is there a recommended method for Java applications to have the same options?

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.

jonathan.legrand avatar image jonathan.legrand

Hi @philip.user , I'm afraid that we do not have a JAVA library; however, in these cases, I investigate the Python Library behavior and try and replicate it. I suggest using the logs, as shown in [this article](https://developers.lseg.com/en/article-catalog/article/troubleshooting-ipa-and-the-data-library-api-in-python) (in the "Switching `Logs` On" section). There you will be able to see the API calls and JSON messages sent and received to replicate it in JAVA.

Let me know if this helps.

philip.user avatar image philip.user jonathan.legrand

Thanks for the suggestion. Just to confirm, we should still follow the same solution design the process of first fetching headlines by RIC codes, then get each storyId to retrieve the full stories from the storyId endpoint? It seems a bit indirect, but it sounds like this is the recommended method? (It would be the same solution design using python as well)

Thank you so much for the guidance.

jonathan.legrand avatar image jonathan.legrand philip.user
Hi @philip.user , yes, this is the advised workflow.

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.