Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
1603295644624.png (84.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.

@nick.steinbach

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the appropriate reply.


This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.


Thanks,

AHS


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

Thanks,


AHS

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 512.0 KiB each and 1.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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 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 512.0 KiB each and 1.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 512.0 KiB each and 1.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 512.0 KiB each and 1.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 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.