question

Upvotes
Accepted
50 1 0 3

getting TR.LastObservationDate in results for rd.discovery.search

i am searching for economic indicator via above search and want to get the same fields i would get in the workspace. for example the field TR.LastObservationDate, which seems impossible to get in the result data.


this is my attempt:

search = rd.discovery.search(
    view = rd.discovery.Views.INDICATOR_QUOTES,
    filter = "( SearchAllCategoryv2 eq 'Economic Indicators')",
    select = "DTSubjectName,SourceName ,RIC,RCSCountryOfIndicator ,StartDate,SearchAllCategoryv2 ,Unit ,SearchAllCategory,RCSCountryOfIndicatorLeaf,SourceName,StartDate,RCSIndicatorType,Unit,AdjustmentFactor,RealtimeRIC, TR.LastObservationDate")


some fields work, some dont:

1703648853174.png


i asked via the helpdesk but the sent me in here (which i dont understand, why cant they provide support via ticket?), so i'd appreciate your help.

thank you.

#technologyrefinitiv-data-librariesrdp search
1703648853174.png (95.7 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.

Upvote
Accepted
14.2k 30 5 10

Hi @andreas01 ,

The 'TR.LastObservationDate' is not available as a metadata for the search function, to see all available metadata, the code below can be used

import refinitiv.data as rd
from refinitiv.data.content import search
rd.open_session()

response = search.metadata.Definition(
    view = search.Views.INDICATOR_QUOTES
).get_data()

response.data.df

1703652873756.png

From this, I found the metadata named 'ObservationDate' and the data is returned as below, is this what you're looking for?

search = rd.discovery.search(
    view = rd.discovery.Views.INDICATOR_QUOTES,
    filter = "( SearchAllCategoryv2 eq 'Economic Indicators')",
    select = "DTSubjectName,SourceName ,RIC,RCSCountryOfIndicator ,StartDate,SearchAllCategoryv2 ,Unit ,SearchAllCategory,RCSCountryOfIndicatorLeaf,SourceName,StartDate,RCSIndicatorType,Unit,AdjustmentFactor,RealtimeRIC, ObservationDate")

1703652924952.png

For the detail regarding using search function, you could check these articles: Building Search into your Application Workflow and Build queries easily using Refinitiv's Search API with Python and Jupyter

Hope this helps and please let me know in case you have any further questions.


1703652873756.png (41.8 KiB)
1703652924952.png (94.3 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
50 1 0 3

i think i found it with a suggested post (funnily enough, i searched the hell out of it before posting and didnt come up with anything)


with that said, there seems to be a bug with the NextReleaseDate:

2023-12-27-08-30.png


it shows the wrong date

why?


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
50 1 0 3

doublechecked it with the workstation, it looks correct in there, just not via api

1703652027141.png


1703652027141.png (66.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.

Upvotes
50 1 0 3

Hi @raksina.samasiri , thank you for this. i found the Observation date but your code looks very valuable for any further enquiries.

have you seen the issue with the next release date? maybe you have an idea about this?

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.

Upvote
14.2k 30 5 10

Hi @andreas01 ,

You're welcome. Regarding the next release date issue, as this forum is dedicated to an API usage question, the moderators on this forum do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through Refinitiv Helpdesk, which can be reached via MyRefinitiv. To be of help, ticket number 13181403 was raised on your behalf and the support team is going to contact you directly to clarify this.qna-nextreleasedate.png


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
50 1 0 3

thank you @raksina.samasiri , this is very much appreciated!

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.

You're welcome @andreas01 , I'm happy to help.

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.