question

Upvotes
Accepted
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.

Upvote
Accepted
81.1k 264 53 76

@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
81.1k 264 53 76

@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.

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
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
81.1k 264 53 76

@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.