Error Retrieving Data through Eikon API

Wei_Wu

Hi Team,

I managed to install the eikon package and set the app key, however, when I tried to run any of the test codes, like

df = ek.get_timeseries(["MSFT.O"],

start_date="2016-01-01",

end_date="2016-01-10")

I ran into error. It would be great it someone could provide some advice. Thanks in advance!!

Here's what I see:

2024-05-08 22:17:29,539 P[5380] [MainThread 16824] Error code 407 | Client Error: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<!-- FileName: index.html

Language: [en]

-->

<head>

<title>McAfee Web Gateway - Notification</title>

</head>

<tr>

<tr>

</td>

</tr>

</table>

<h1>Authentication Required</h1>

<tr>

You must be authenticated to access this URL.

</td>

</tr>

</table>

urlprotocol = "http";

statuscode=407;

if(statuscode==401 && urlprotocol == "ftp"){

document.write("<form name=\"ftpform\" method=\"get\" action=\"\">");

document.write("<table class=\"contentData\">");

document.write("<tr><td class=\"contentData\" colspan=2>Please enter your credentials in the form below and click \"Access FTP\" button if your browser doesn't present authentication prompt for FTP sites.</td></tr>");

document.write("<tr><td class=\"contentData\">Username:</td><td><input type=\"text\" id=\"ftpUsername\" name=\"ftpUsername\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\">Password:</td><td><input type=\"password\" id=\"ftpPassword\" name=\"ftpPassword\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\" colspan=2 align=center><input type=\"button\" onclick=\"redirectToFTP();\" value=\"Access FTP\" /></td></tr>");

document.write("</table>");

document.write("</form>");

}

function redirectToFTP(){

var username=unescape(document.getElementById("ftpUsername").value);

var password=unescape(document.getElementById("ftpPassword").value);

location.href = "ftp://"+username+":"+password+"@127.0.0.1:9060/api/v1/data"

}

</script>

<tr>

<b>URL: </b><script type="text/javascript">break_line("http://127.0.0.1:9060/api/v1/data");</script><br />

</td>

</tr>

</table>

<tr>

<hr>

Company Acceptable Use Policy

</td>

</tr>

<tr>

This is an optional acceptable use disclaimer that appears on every page. You may change the wording or remove this section entirely in index.html.

</td>

</tr>

</table>

<tr>

For assistance, please contact your system administrator.

</td>

</tr>

<tr>

generated <span id="time">2024-05-08 14:17:29</span> by McAfee Web Gateway

<br />

python-httpx/0.27.0

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

2024-05-08 22:17:29,550 P[5380] [MainThread 16824] HTTP request failed: EikonError-Client Error: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<!-- FileName: index.html

Language: [en]

-->

<head>

<title>McAfee Web Gateway - Notification</title>

</head>

<tr>

<tr>

</td>

</tr>

</table>

<h1>Authentication Required</h1>

<tr>

You must be authenticated to access this URL.

</td>

</tr>

</table>

urlprotocol = "http";

statuscode=407;

if(statuscode==401 && urlprotocol == "ftp"){

document.write("<form name=\"ftpform\" method=\"get\" action=\"\">");

document.write("<table class=\"contentData\">");

document.write("<tr><td class=\"contentData\">Username:</td><td><input type=\"text\" id=\"ftpUsername\" name=\"ftpUsername\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\">Password:</td><td><input type=\"password\" id=\"ftpPassword\" name=\"ftpPassword\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\" colspan=2 align=center><input type=\"button\" onclick=\"redirectToFTP();\" value=\"Access FTP\" /></td></tr>");

document.write("</table>");

document.write("</form>");

}

function redirectToFTP(){

var username=unescape(document.getElementById("ftpUsername").value);

var password=unescape(document.getElementById("ftpPassword").value);

location.href = "ftp://"+username+":"+password+"@127.0.0.1:9060/api/v1/data"

}

</script>

<tr>

<b>URL: </b><script type="text/javascript">break_line("http://127.0.0.1:9060/api/v1/data");</script><br />

</td>

</tr>

</table>

<tr>

<hr>

Company Acceptable Use Policy

</td>

</tr>

<tr>

This is an optional acceptable use disclaimer that appears on every page. You may change the wording or remove this section entirely in index.html.

</td>

</tr>

</table>

<tr>

For assistance, please contact your system administrator.

</td>

</tr>

<tr>

generated <span id="time">2024-05-08 14:17:29</span> by McAfee Web Gateway

<br />

python-httpx/0.27.0

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

Traceback (most recent call last):

File C:\ProgramData\anaconda3\lib\site-packages\eikon\json_requests.py:127 in send_json_request

_raise_for_status(response)

File C:\ProgramData\anaconda3\lib\site-packages\eikon\json_requests.py:271 in _raise_for_status

raise EikonError(response.status_code, error_msg)

EikonError: Error code 407 | Client Error: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<!-- FileName: index.html

Language: [en]

-->

<head>

<title>McAfee Web Gateway - Notification</title>

</head>

<tr>

<tr>

</td>

</tr>

</table>

<h1>Authentication Required</h1>

<tr>

You must be authenticated to access this URL.

</td>

</tr>

</table>

urlprotocol = "http";

statuscode=407;

if(statuscode==401 && urlprotocol == "ftp"){

document.write("<form name=\"ftpform\" method=\"get\" action=\"\">");

document.write("<table class=\"contentData\">");

document.write("<tr><td class=\"contentData\">Username:</td><td><input type=\"text\" id=\"ftpUsername\" name=\"ftpUsername\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\">Password:</td><td><input type=\"password\" id=\"ftpPassword\" name=\"ftpPassword\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\" colspan=2 align=center><input type=\"button\" onclick=\"redirectToFTP();\" value=\"Access FTP\" /></td></tr>");

document.write("</table>");

document.write("</form>");

}

function redirectToFTP(){

var username=unescape(document.getElementById("ftpUsername").value);

var password=unescape(document.getElementById("ftpPassword").value);

location.href = "ftp://"+username+":"+password+"@127.0.0.1:9060/api/v1/data"

}

</script>

<tr>

<b>URL: </b><script type="text/javascript">break_line("http://127.0.0.1:9060/api/v1/data");</script><br />

</td>

</tr>

</table>

<tr>

<hr>

Company Acceptable Use Policy

</td>

</tr>

<tr>

This is an optional acceptable use disclaimer that appears on every page. You may change the wording or remove this section entirely in index.html.

</td>

</tr>

</table>

<tr>

For assistance, please contact your system administrator.

</td>

</tr>

<tr>

generated <span id="time">2024-05-08 14:17:29</span> by McAfee Web Gateway

<br />

python-httpx/0.27.0

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File C:\ProgramData\anaconda3\lib\site-packages\spyder_kernels\py3compat.py:356 in compat_exec

exec(code, globals, locals)

File c:\users\w257147\onedrive - cargill inc\documents\frequent\new scripts\untitled0.py:11

df = ek.get_timeseries(["MSFT.O"],

File C:\ProgramData\anaconda3\lib\site-packages\eikon\time_series.py:182 in get_timeseries

ts_result = eikon.json_requests.send_json_request(TimeSeries_UDF_endpoint, payload, debug=debug)

File C:\ProgramData\anaconda3\lib\site-packages\eikon\json_requests.py:134 in send_json_request

raise EikonError(eikon_err.code, eikon_err.message)

EikonError: Error code 407 | Client Error: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<!-- FileName: index.html

Language: [en]

-->

<head>

<title>McAfee Web Gateway - Notification</title>

</head>

<tr>

<tr>

</td>

</tr>

</table>

<h1>Authentication Required</h1>

<tr>

You must be authenticated to access this URL.

</td>

</tr>

</table>

urlprotocol = "http";

statuscode=407;

if(statuscode==401 && urlprotocol == "ftp"){

document.write("<form name=\"ftpform\" method=\"get\" action=\"\">");

document.write("<table class=\"contentData\">");

document.write("<tr><td class=\"contentData\">Username:</td><td><input type=\"text\" id=\"ftpUsername\" name=\"ftpUsername\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\">Password:</td><td><input type=\"password\" id=\"ftpPassword\" name=\"ftpPassword\" size=40 /></td></tr>");

document.write("<tr><td class=\"contentData\" colspan=2 align=center><input type=\"button\" onclick=\"redirectToFTP();\" value=\"Access FTP\" /></td></tr>");

document.write("</table>");

document.write("</form>");

}

function redirectToFTP(){

var username=unescape(document.getElementById("ftpUsername").value);

var password=unescape(document.getElementById("ftpPassword").value);

location.href = "ftp://"+username+":"+password+"@127.0.0.1:9060/api/v1/data"

}

</script>

<tr>

<b>URL: </b><script type="text/javascript">break_line("http://127.0.0.1:9060/api/v1/data");</script><br />

</td>

</tr>

</table>

<tr>

<hr>

Company Acceptable Use Policy

</td>

</tr>

<tr>

This is an optional acceptable use disclaimer that appears on every page. You may change the wording or remove this section entirely in index.html.

</td>

</tr>

</table>

<tr>

For assistance, please contact your system administrator.

</td>

</tr>

<tr>

generated <span id="time">2024-05-08 14:17:29</span> by McAfee Web Gateway

<br />

python-httpx/0.27.0

</td>

</tr>

</table>

</td>

</tr>

</table>

</body>

</html>

Find more posts tagged with

python

error

python api

workspace

eikon-data-api

refinitiv-data-platform-eikon

#technology

Accepted answers

wasin.w

Hello @Wei_Wu

Please be informed that the Eikon Data API needs to connect to the Workspace/Eikon desktop application in the same machine (localhost) because the desktop application acts as a proxy between the API and Workspace platform.

The error messages indicate that the issue relates to the McAfee Web Gateway in your machine. The McAfee software in your machine might intercept this request and reject it. You may need to contact your local IT support team to verify this issue.

However, some users can solve this issue by setting the NO_PROXY environment variable.

import os
os.environ['NO_PROXY'] = '127.0.0.1'

If the setting above does not solve the issue, I highly recommend you contact your local IT support team.

All comments

wasin.w

Hello @Wei_Wu

However, some users can solve this issue by setting the NO_PROXY environment variable.

import os
os.environ['NO_PROXY'] = '127.0.0.1'

If the setting above does not solve the issue, I highly recommend you contact your local IT support team.

EXPLORE OUR SITES