Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by STATA · Apr 29, 2019 at 09:54 AM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonapi

MissingSchema: Invalid URL 'None': No schema supplied. Perhaps you meant http://None?


Hi everybody.

first of all thank you so much for that great community!

I still have the same error and have not found any solution yet!
What can I check and what kind of solution do I have?


1. license

Customer support checked license and we do have access to to the Eikon API - (premium account)

2. Version

>> import eikon
>> eikon.__version__
=> I do have version '1.0.0' as a result

3. Could you check response on following url ?

  • http://localhost:9000/api/v1/data
    • => Internal Server Error
  • http://localhost:36036/api/v1/data
    • => No connection at all

3 . API Proxy

  • check folder
    C:\ProgramData\Thomson Reuters\Eikon Data\Logs\TRD
  • File to check in the folder should have format like this:
    SxS.yyyymmdd.hhmmss.txt file
  • Entry to find should look like this:
    [2018-03-08 10:23:23.773|prod] (app) PO: SIDEBYSIDE,APIPROXY.

    => Only entry in the file I scan find is as following:
start node 
Arg: C:\Program Files (x86)\Thomson Reuters\Eikon\Y\Bin\Eikonbox.exe C:\Users\R\AppData\Local\Thomson Reuters\Eikon User\Cache\LibraryCache\Apps\THOMSONREUTERS.EIKON.DESKTOPSXSSVC\1.1.0.69\index.js -TraceLevel=-1 

You should find an entry like this...
[2018-03-08 10:23:23.773|prod]  (app) PO: SIDEBYSIDE,APIPROXY.

What can I do and check to get the API running?
@
@pierre.faurel - any ideas from your side? That would be amazing!
Many thanks to all of you!
It is a great community! Thanks again!


People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

7 Replies

  • Sort: 
avatar image
Best Answer
Answer by STATA · Apr 30, 2019 at 11:20 AM

@chavalit.jintamalit

@Alex Putkov.

Some very very basic mistake! Oh my dear.... I had a typo in my eikon.cfg file using a string in my cfg file!

cfg = cp.ConfigParser() cfg.read('eikon.cfg') # adjust for different file location app_id = cfg.get('eikon','app_id') ek.set_app_key(app_id) 

Everybody →
eikon.cfg file should look like this:

[eikon]
app_id = XXXXXXXXXXXXXXXXXXXXXXXXXXX0

Remember to not use quotes / string
app_id = " XXXXXXXXXXXXXXXXXXXXXXXXXXX0 "

Everything is working as suggested!

Oh my goodness!

Many many thanks again for checking my complete environment!

P.S.

By the way! There is no error handling involved for this mistake!


Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
chavalit-jintamalit ♦♦ · Apr 30, 2019 at 11:33 AM 0
Share

Thanks for letting us know.
Have fun with the API.

avatar image
REFINITIV
Answer by chavalit-jintamalit · Apr 29, 2019 at 11:27 AM

Hi @STATA

2. You can use this command in a command line to upgrade eikon to the latest version

pip install eikon

And you can use tho command to check eikon API version

pip show eikon

This is the current version as of now:

Name: eikon
Version: 0.1.13
Summary: Python package for retrieving Eikon data.

3. You have to go to enable log in debug level.

Please follow these steps:

3.1 Shutdown Eikon Desktop

3.2 Start >> Thomson Reuters >> Configuration Manager

3.3 Go to "Log" tab and enable debug log level.

3.4 Click on Configure

3.5 Launch Eikon Desktop app again

3.6 Try to locate the following output:

[2019-04-29 15:17:59.747|1|api-svc|1|INFO] PO: SIDEBYSIDE,APIPROXY
[2019-04-29 15:17:59.748|1|api-svc|3|DEBUG] create SIDEBYSIDE
[2019-04-29 15:17:59.749|1|api-svc|3|DEBUG] create APIPROXY
...
...
[2019-04-29 15:17:59.888|1|api-svc|1|INFO] Start server...
...
...
[2019-04-29 15:17:59.902|1|api-svc|2|DEBUG] onStarted: 9000
...
...
[2019-04-29 15:17:59.920|1|api-svc|1|INFO] Listening to port=9000

log.jpg (154.1 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Alex Putkov.1 · Apr 29, 2019 at 11:34 AM

It looks like the log file was created with the default trace level. You need to increase the logging trace level. Start Eikon Configuration Manager from All Programs - Thomson Reuters - Thomson Reuters Eikon Tools. In the Configuration Manager select the Logs tab, check Configure Logs on the Workstation box, set Trace Level for Thomson Reuters Desktop to 4 - Debug and click Configure. Now restart Eikon and check SxS log file. It should have a lot more info now. It's probably best if you upload the log file here, so we can analyze it.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by STATA · Apr 29, 2019 at 11:55 AM

1 .
run "netstat -anb" as Administrator from the Command Prompt

Port 9000 is listening.

2. Upload your dump

sxs20190429173737000p11920.txt

@Alex Putkov.

3. Could it be a problem running - for simplicity of system management - a Jupyter environment in a docker container the problem?
It seems a bit like that for me now....

Thanks again everybody!

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
chavalit-jintamalit ♦♦ · Apr 29, 2019 at 12:04 PM 0
Share

Is the Jupyter notebook running on your local machine or on other machine ?

avatar image
REFINITIV
Answer by Alex Putkov.1 · Apr 29, 2019 at 04:27 PM

@STATA
I looked at the log file you provided and couldn't see anything out of the ordinary there. Your Eikon API Proxy appears to be functioning as expected.
I'm not an expert in containers, but my understanding is that if you're running Jupyter in a Docker container, your container by default has a separate network stack from the host's network stack. Even if you've mapped local port 9000 between the container and the host, an HTTP request from Jupyter will appear to Eikon API Proxy as coming from a different machine, not from the localhost. Eikon API Proxy rejects any HTTP requests not originating from the localhost. I've never tried this myself, and again I'm not an expert in containers, but perhaps you can make this setup work by using the host's network stack in your container running Jupyter? Although it also appears that Docker's --network host option is only supported on Linux, so perhaps it won't work after all.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by STATA · Apr 30, 2019 at 07:35 AM

@Alex Putkov.

Thank you so much for looking into the log file!

I installed Anaconda and running my Notebooks/JupiterLab now inside a virtualenv.
It is still not possible to connect to the API - Eikon Desktop 4.0.47!

localhost is listing to port 9000 - but when I do open
http://localhost:9000/api/v1/data
→ Internal Server Error

Why is this? Where does it come from?

Thanks again!

P.S.:

http://localhost:9000/ping?all

{"port":9000,"mode":"eikon4","pid":12588,"hasSecure":true,"startedTime":"Tue Apr 30 2019 13:44:19 GMT+0200 (Mitteleuropäische Sommerzeit)","subApps":[{"path":"/heap"},{"path":"/ping"},{"path":"/sxs","data":{"hasSecure":true,"sxsApps":{}}},{"path":"/api"}]}

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
chavalit-jintamalit ♦♦ · Apr 30, 2019 at 08:37 AM 0
Share

FYI - On my machine with a working API.

If I try to access to http://localhost:9000/api/v1/data

I also receive "Internal Server Error"

avatar image
REFINITIV
Answer by chavalit-jintamalit · Apr 30, 2019 at 09:13 AM

I used rawcap (download from here) to capture network on my localhost interface.

I launched rawcap and use Python code in command line to make a few API calls.

Then I got a pcap file which show me that the connection is ok.

I think it worth to check if the connection to your localhost port 9000 is ok on your virualenv or not.


port9000.jpg (158.2 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Forex on past and futures dates equivalent bloomberg api

Contribute in Python?

R package available for Eikon?

Hourly historical data for 5 years

Carbon time series API (R)

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges