question

Upvotes
Accepted
gshebert avatar image
1 ●0 ●1 ●1

Refinitiv Data API vs Eikon API for event data

Hi Folks,


Has anyone successfully used the Refinitiv Data API to query for event data?

I'm attempting to do something similar to the examples that I see using the Eikon API below, but get back an empty data frame.


Thanks for any insight!


import eikon as ek
 
ek.set_app_key('YOUR_EIKON_APP_KEY_HERE')
df, err = ek.get_data(['MSFT.O'], ["TR.EventType", "TR.EventStartDate", "TR.EventEndDate",
                                    "TR.EventStartTime", "TR.EventEndTime"]
                      , {'Scale':6,'SDate':'2022-09-01', 'EDate':'2022-12-31'})
df
eikon-data-api#productrefinitiv-data-platform-librariesevents
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.

wasin.w avatar image   wasin.w

Hello @gshebert

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

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

Thanks,


AHS

4 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@gshebert

I got the output when using the RD library.

1693465226488.png

You can enble logging in the RD library via the configuration file (refinitiv-data.config.json) to verify what the problem is. 

{
  ...
  "logs": {
    "level": "debug",
    "transports": {
      "console": {
        "enabled": false
      },
      "file": {
        "enabled": true,
        "name": "refinitiv-data-lib.log"
      }
    }
  },
...

1693465226488.png (64.8 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
Jirapongse avatar image
79.2k ●251 ●52 ●74

@gshebert

Thank you for reaching out to us.

I can run the code properly.

1692844598450.png

You can check the err or enable logging in the API by using the following code.

ek.set_log_level(1)

1692844598450.png (42.0 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.

gshebert avatar image gshebert
This does not answer my question!


I'm not interested in using the Eikon API for this. Rather, as explicitly stated in my OP, I want to use the Refinitiv Data API.

When I attempt to use the Refinitiv Data API to run this query, it returns an empty dataframe.


Clearly, your example uses the Eikon API.

-Greg


Upvotes
gshebert avatar image
1 ●0 ●1 ●1

Here is what our debug output shows:


[2023-08-24T14:40:16.568184-05:00] - [sessions.platform.rdp.0] - [DEBUG] - [35052 - MainThread] - [get_data] - [get_adc_data] - Failure response into content layer: Error code 221 | The access to field(s) denied. Requested universes: ['IBM.N']. Requested fields: ['TR.EventStartDate', 'TR.EventType', 'TR.EventTitle']



I'm not sure why this would be the case, we can see the data in the Eikon application and support has confirmed that we should be able to access the data

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
Jirapongse avatar image
79.2k ●251 ●52 ●74

@gshebert

The RD library can be configured to retrieve data from either a desktop session (an Eikon use via an application key) or a platform session (RDP credentials).

1694483381308.png

According to the log, you are using the platform.rdp session.

An Eikon user and RDP user may have different permission settings.

For example, I can get the data when using the desktop.workspace session but I got the access denied error when using the platform.rdp session. 

RDError: Error code -1 | The access to field(s) denied. Requested universes: ['IBM.N']. Requested fields: ['TR.EVENTTYPE', 'TR.EVENTSTARTDATE', 'TR.EVENTENDDATE', 'TR.EVENTSTARTTIME', 'TR.EVENTENDTIME']

Therefore, you can use the desktop.workspace session to retrieve the data.

Otherwise, you need to contact the helpdesk team to verify the RDP permission settings.


1694483381308.png (39.8 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.

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.