For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 0

Unable to connect to Eikon API from Python. Error Code 500.

I’m getting a Error Code 500 for something that used to work w/out issue.

My Eikon Desktop is working well and am able to get live quotes/news.

I’ve rebooted and restarted everything so I’m out of ideas…



eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
1603295644624.png (84.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
4.3k 2 4 5

Before any action, please remove User Detail section (UUID, email, ....) in dump from Help about !

eikon 1.1.7 is available.
Could you upgrade your version ? ("pip install --upgrade eikon")

To Clear Cache, you can start Thomson Reuters \ Thomson Reuters Eikon Tools \ Clear Cache


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
4.3k 2 4 5

Hi,

If something changed in Eikon that causes mismatch, you can run a Clear Cache.

As it that used to work w/out issue, that means you didn't update any python lib (including eikon).
Could you detail following information ?

  • eikon lib version
  • Eikon Desktop version
  • Eikon APPs version (get Copy To Clipboard from Eikon \ Help about window)

To get all detail on the error you Could you add following code snippet before get_data() (it'll activate eikon and http logs) ?

import os
os.environ["HTTPX_LOG_LEVEL"] = "trace"
ek.set_log_level(1)

Then share output response in a text file (remove any reference to application_id value) ?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 1 0

How do I Clear Cache?

Eikon Desktop Verions is 4.0.52

Eikon lib verion: 1.1.2

error.txt

Eikon APPS:

==============================================================================

* * Refinitiv Eikon * *

==============================================================================

* * Version * *

Desktop 4.0.52 (4.0.52055)


==============================================================================

* * Connection Status * *

Connection Mode: INTERNET

Heartbeat: OK

Realtime: OK

----------------------------------

Data Center: Primary - AMERS2

Deployment Mode: Customer Managed over Internet

----------------------------------

Operating System: Microsoft Windows 10 Enterprise


==============================================================================

* * Add-ons * *

- Add-ons

- No Add-Ons Installed


==============================================================================

* * Apps * *

- APPS (ACTIVE)

ABOUTDIALOG (40.27.18.7)

THOMSONREUTERS.EIKON.ABOUTDIALOG (40.27.18.7)

Installed on 2020-07-01 08:49:14.602

ALERTS (1.0.6.0)

TR.ALERTS (1.0.6.0)

Installed on 2020-03-10 11:41:47.268

ALERTSENGINE (1.0.0.23)

THOMSONREUTERS.EIKON.ALERTSENGINE (1.0.0.23)

Installed on 2020-03-10 11:41:52.381

BOB (3.1.1901.17736)

THOMSONREUTERS.EIKON.BOB (3.1.1901.17736)

Installed on 2020-03-10 11:41:21.618

CHARTS (9.50.0.1)

THOMSONREUTERS.EIKON.CHARTS (9.50.0.1)

Installed on 2020-07-10 14:51:08.083

DESKTOPSXSSVC (1.1.0.95)

THOMSONREUTERS.EIKON.DESKTOPSXSSVC (1.1.0.95)

Installed on 2020-07-06 07:40:12.417

FLOATINGTOOLBAR (4.84.0.53)

THOMSONREUTERS.EIKON.FLOATINGTOOLBAR (4.84.0.53)

Installed on 2020-08-24 09:08:49.156

FXALLSERVICE (1.0.0.14)

THOMSONREUTERS.EIKON.FXALLSERVICE (1.0.0.14)

Installed on 2020-03-10 11:41:46.706

LISTSERVICE (10.0.0.17)

LISTSERVICE (10.0.0.17)

Installed on 2020-03-10 11:42:09.076

NEWS (9.52.0.51)

THOMSONREUTERS.EIKON.NEWS (9.52.0.51)

Installed on 2020-08-24 09:02:38.511

OFFICE.CORE (4.0.52.0)

TR.OFFICE.CORE (4.0.52.0)

Installed on 2020-08-24 09:02:38.545

OFFLINEAPP (1.1.0.148)

THOMSONREUTERS.EIKON.OFFLINEAPP (1.1.0.148)

Installed on 2020-07-01 08:49:09.977

OPSCONSOLE (4.0.17.33)

THOMSONREUTERS.EIKON.OPSCONSOLE (4.0.17.33)

Installed on 2020-07-27 12:32:58.486

PROXY (9.52.0.51)

THOMSONREUTERS.EIKON.PROXY (9.52.0.51)

Installed on 2020-08-24 09:02:38.500

PROXYREGISTRY (4.0.33010.0)

THOMSONREUTERS.EIKON.PROXYREGISTRY (4.0.33010.0)

Installed on 2020-03-10 11:41:25.655

QUICKCHARTS (9.31.14.5000)

THOMSONREUTERS.EIKON.QUICKCHARTS (9.31.14.5000)

Installed on 2020-08-21 11:02:36.688

QUOTE (9.52.0.51)

THOMSONREUTERS.EIKON.QUOTE (9.52.0.51)

Installed on 2020-08-24 09:02:38.492

QUOTELIST (9.52.0.51)

THOMSONREUTERS.EIKON.QUOTELIST (9.52.0.51)

Installed on 2020-08-24 09:02:38.411

REALTIME.PIXLALLPROTOCOLS (9.0.4701.56)

THOMSONREUTERS.REALTIME.PIXLALLPROTOCOLS (9.0.4701.56)

Installed on 2020-03-10 11:41:21.796

REFINITIVHOLDINGS.EIKON.DATAAPIPROXY (1.1.0.12)

REFINITIVHOLDINGS.EIKON.DATAAPIPROXY (1.1.0.12)

Installed on 2020-10-19 08:33:01.959

STARTERCORE (0.0.0.41)

THOMSONREUTERS.EIKON.STARTERCORE (0.0.0.41)

Installed on 2020-03-10 11:41:28.822

STARTERNET (0.0.0.120)

THOMSONREUTERS.EIKON.STARTERNET (0.0.0.120)

Installed on 2020-03-10 11:41:21.752

SUPPORTTOOL (9.1.15.153)

THOMSONREUTERS.EIKON.SUPPORTTOOL (9.1.15.153)

Installed on 2020-03-10 11:48:13.496

SYSTEMTEST (9.51.0.10)

THOMSONREUTERS.EIKON.SYSTEMTEST (9.51.0.10)

Installed on 2020-03-10 11:56:35.214

TAS (9.1.4046.97)

THOMSONREUTERS.EIKON.TAS (9.1.4046.97)

Installed on 2020-03-10 11:41:21.630

THINMONITORMIGRATIONSERVICE (9.52.0.51)

THOMSONREUTERS.EIKON.THINMONITORMIGRATIONSERVICE (9.52.0.51)

Installed on 2020-08-24 09:02:38.560

TRANSACTION.TRADEWEBADAPTER (9.0.14.2)

THOMSONREUTERS.TRANSACTION.TRADEWEBADAPTER (9.0.14.2)

Installed on 2020-07-27 12:27:06.406

TRANSACTION.TRADINGVENUELOGIC (9.0.13.1722)

THOMSONREUTERS.TRANSACTION.TRADINGVENUELOGIC (9.0.13.1722)

Installed on 2020-04-08 16:51:28.603

TSI6 (6.4.2013.44564)

THOMSONREUTERS.EIKON.TSI6 (6.4.2013.44564)

Installed on 2020-03-10 11:41:21.763

UDASERVICE (2.10.13.3)

THOMSONREUTERS.EIKON.UDASERVICE (2.10.13.3)

Installed on 2020-03-10 11:41:36.227

WEBAPPS (9.52.0.51)

THOMSONREUTERS.EIKON.WEBAPPS (9.52.0.51)

Installed on 2020-08-24 09:02:38.519

WEBAPPS_DEV (9.52.0.51)

THOMSONREUTERS.EIKON.WEBAPPS_DEV (9.52.0.51)

Installed on 2020-08-24 09:02:38.527

WEBINTEGRATION (9.52.0.51)

THOMSONREUTERS.EIKON.WEBINTEGRATION (9.52.0.51)

Installed on 2020-08-24 09:02:38.536


- APPS (DOWNLOADED)

- No Apps Downloaded


==============================================================================

* * Date Time Settings * *

Time Zone: Eastern Standard Time

Daylight Saving Time (DST): Eastern Daylight Time

Changeover Date:


==============================================================================

* * Real-Time Sources * *

- Data Feeds

- No Data Feeds

- Information

- No Information


==============================================================================

* * Active Document * *

==============================================================================

* * Workspace Size * *

Width and Height Parameters:


Screen Resolution:


Grid Size:


Unit Size:


==============================================================================

* * ActiveX Controls * *

* There are no ActiveX Objects in the active document.

==============================================================================

* * Design Information * *



1603307689549.png (163.6 KiB)
error.txt (1.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 1 0

Cleared Cache and upgraded but still get same error, but more message. Also checked status of proxy (suggested in another thread) w/ http://localhost:9060/api/status and that gives me it's version number (below). Also attaching new error files w/out removed ids. Need this fixed SOON!!

{"statusCode":"ST_PROXY_READY","version":"2.6.3"}

error2.txt


error2.txt (4.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
4.3k 2 4 5

Hi,

the error code 500 "self signed certificate in certificate chain" means requests need a corporate certificate.

If your IT can provide this certificate in 'pem' format, could you try following test ?

  • Start a console window,
  • set environment variable NODE_EXTRA_CA_CERTS to <path to your company certificate file>
    ( ex: c:\>set NODE_EXTRA_CA_CERTS=C:\tmp\cacert.pem )
  • start jupyter notebook (or Eikon if you're using Codebook) from this console and run your code


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 0 0

It doesn't appear that you are doing anything incorrectly from an API perspective. Instead, the intermittent issues may be a result of server overload. The immediate workaround is to try the request with a smaller date range to see if this helps. If you continually encounter this error, the best and most efficient approach is to open a support case with Refinitiv Helpdesk and include the complete details. Your inquiry will be assigned immediately and investigated in a timely manner. These forums do not specialize in server issues.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 0 0

@geome trydash:

wohh, i totally agree! A useful share

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea