Good afternoon
I updated the Python package of Eikon to 1.1.8.
I have always been running several equity screeners that I built in Excel in Python. Unfortunately, I receive the following error when I run my code (code wasn't changed):
fields=['TR.ISIN','CF_CURR','TR.ExchangeCountryCode'] each_request = "SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,AU), TR.AvgDailyValTraded52W>=500000, IN(TR.InstrumentTypeCode,FULLPAID,ORD,STAPLED), TR.CompanyMarketCap>=0, NOT_IN(TR.TRBCBusinessSectorCode,5550), CURN=EUR)" loop_screen, error =ek.get_data(each_request,fields)
2021-01-07 13:56:24,221 P[23940] [MainThread 17184] Failed to decode response to json: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>Sign In</title><meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7"/><meta http-equiv="content-type" content="text/html; charset=utf-8"/><META page=login><link rel="icon" type="image/vnd.microsoft.icon" href="/favicon.ico"/><link rel="shortcut icon" href="/favicon.ico"/><link rel="stylesheet" type="text/css" href="/auth/css/charcoal_commonstyles_spr.css?v=_3.43.3501.01"/><link rel="stylesheet" type="text/css" href="/auth/css/refinitiv_charcoal_loginstyles_spr.css?v=patchRFCharcoal12-12-20_3.43.3501.01"/><script type="text/javascript" src="/auth/js/signin_spr.js?v=_3.43.3501.01"></script><script type="text/javascript" src="/js/as.js?v=_3.43.3501.01"></script><script src="/auth/js/jquery-1.10.1.min.js"></script><script src="/auth/js/jquery-as.js?v=_3.43.3501.01"></script><script type='text/javascript'>function openHelpLink(){var link="https://my.refinitiv.com/content/mytr/en/productsupport.html";window.open(link)}function initial(){elementFocus("AAA-AS-SI1-SE003");$("#AAA-AS-SI1-SE008_Value").val("FALSE");$("#AAA-AS-SI1-SE008_CheckBox_TRUE").checkbox({"checkedValue":"TRUE"});$("#AAA-AS-SI1-SE009").click(asUtils.forwardClick("#AAA-AS-SI1-SE008_CheckBox_TRUE"))};</script></head><body onload="initial()" style="overflow:hidden;"><div class='main'><div class="space_top"></div><div class="content_center"><div class="header"><div class='header_bar_right'><div class='close_btn'><a class="close_icon" id="AAA-AS-SI-SE023" href="javascript:closeWindow();" tabindex="-1"></a></div><div class="language_bar"><div class="language_box" onclick="onClickLanguageBox('AAA-AS-SI-C005');" onkeydown="return onPressLanguageBox(event, 'AAA-AS-SI-C005');"><div class="language_select" onmouseover='changeHover(this,"language_select",true)' onmouseout='changeHover(this,"language_select",false)' onfocus='changeHover(this,"language_select",true)' onblur='changeHover(this,"language_select",false)' tabIndex="8"><div class="language_text" id='AAA-AS-SI-SE020'>English
</div></div><div id="AAA-AS-SI-C005" class="language_list_box"><a id="en-US" class="language_item" onclick="onSelectLanguage('en-US', '/auth/UI/Login?MinorVersion=0&RequestID=6D90378E0A766562C5AFCD4E16044398F7C725B4996B2994FEE4179F82AF049A&theme=charcoal&ProviderID=https%3A%2F%2Femea1.proxy.cp.thomsonreuters.com%3A443%2Famagent&IssueInstant=2021-01-07T12%3A56%3A24Z&MajorVersion=1&goto=%2Fauth%2Fcdcservlet%3FTARGET%3Dhttps%253A%252F%252Femea1.apps.cp.thomsonreuters.com%252FApps%252FUDF%252FMSF%253Fampostpreserve%253Dd26384eb-5eff-7d4f-9729-ef240798e527%2526srv%253DDTCP-ERPCPRP01%26MinorVersion%3D0%26RequestID%3D6D90378E0A766562C5AFCD4E16044398F7C725B4996B2994FEE4179F82AF049A%26theme%3Dcharcoal%26ProviderID%3Dhttps%253A%252F%252Femea1.proxy.cp.thomsonreuters.com%253A443%252Famagent%26IssueInstant%3D2021-01-07T12%253A56%253A24Z%26MajorVersion%3D1%26locale%3Den-US&locale=en-US' ,'AAA-AS-SI-C005', 'AAA-AS-SI-C004', 'AAA-AS-SI-SE020')" href="#" tabIndex='-1'> English </a><a id="ja-JP" class="language_item" onclick="onSelectLanguage('ja-JP', '/auth/UI/Login?MinorVersion=0&RequestID=6D90378E0A766562C5AFCD4E16044398F7C725B4996B2994FEE4179F82AF049A&theme=charcoal&ProviderID=https%3A%2F%2Femea1.proxy.cp.thomsonreuters.com%3A443%2Famagent&IssueInstant=2021-01-07T12%3A56%3A24Z&MajorVersion=1&goto=%2Fauth%2Fcdcservlet%3FTARGET%3Dhttps%253A%252F%252Femea1.apps.cp.thomsonreuters.com%252FApps%252FUDF%252FMSF%253Fampostpreserve%253Dd26384eb-5eff-7d4f-9729-ef240798e527%2526srv%253DDTCP-ERPCPRP01%26MinorVersion%3D0%26RequestID%3D6D90378E0A766562C5AFCD4E16044398F7C725B4996B2994FEE4179F82AF049A%26theme%3Dcharcoal%26ProviderID%3Dhttps%253A%252F%252Femea1.proxy.cp.thomsonreuters.com%253A443%252Famagent%26IssueInstant%3D2021-01-07T12%253A56%253A24Z%26MajorVersion%3D1%26locale%3Dja-JP&locale=ja-JP' ,'AAA-AS-SI-C005', 'AAA-AS-SI-C004', 'AAA-AS-SI-SE020')" href="#" tabIndex='-1'> 日本語 </a><a id="zh-CN" class="language_item" onclick="onSelectLanguage('zh-CN', '/auth/UI/Login?MinorVersion=0&RequestID=6D90378E0A766562C5AFCD4E16044398F7C725B4996B2994FEE4179F82AF049A&theme=charcoal&ProviderID=https%3A%2F%2Femea1.proxy.cp.thomsonreuters.com%3A443%2Famagent&IssueInstant=2021-01-07T12%3A56%3A24Z&MajorVersion=1&goto=%2Fauth%2Fcdcservlet%3FTARGET%3Dhttps%253A%252F%252Femea1.apps.cp.thomsonreuters.com%252FApps%252FUDF%252FMSF%253Fampostpreserve%253Dd26384eb-5eff-7d4f-9729-ef240798e527%2526srv%253DDTCP-ERPCPRP01%26MinorVersion%3D0%26RequestID%3D6D90378E0A766562C5AFCD4E16044398F7C725B4996B2994FEE4179F82AF049A%26theme%3Dcharcoal%26ProviderID%3Dhttps%253A%252F%252Femea1.proxy.cp.thomsonreuters.com%253A443%252Famagent%26IssueInstant%3D2021-01-07T12%253A56%253A24Z%26MajorVersion%3D1%26locale%3Dzh-CN&locale=zh-CN' ,'AAA-AS-SI-C005', 'AAA-AS-SI-C004', 'AAA-AS-SI-SE020')" href="#" tabIndex='-1'> 中文简体 </a></div><input class='hiddensubmit' type="hidden" id="AAA-AS-SI-C004" name="AAA-AS-SI-C004" value="en-US"/></div></div></div></div><div class="body_main"><div class="signin_body_content"><div class="body_brand"><div id="AAA-AS-SI-SE006" class="product_brand_image"></div></div><div class="body_input"><form name="frmSignIn" action="blank" onSubmit="return defaultSubmit('AAA-AS-SI1-SE014')" method="post"><table width='100%' cellspacing="1" cellpadding="0" border="0"><tr class='signin_input_row'><td width='76px'><label class='topic_txt' id="AAA-AS-SI1-SE002" for='IDToken1'> User ID: </label></td><td><div class="textbox_img textbox_img_big2"><input type="text" id="AAA-AS-SI1-SE003" name="IDToken1" value="" autocomplete="off" tabIndex='1'/></div></td></tr><tr class='signin_userid_hint'><td> </td><td><label class="small_font " id="AAA-AS-SI1-SE004">Hint: This is usually your work email address</label></td></tr><tr class='signin_input_row'><td><label class='topic_txt' id="AAA-AS-SI1-SE005" for="IDToken2"> Password: </label></td><td><div class="textbox_img textbox_img_normal"><input type="password" id="AAA-AS-SI1-SE006" tabIndex="2" name="IDToken2" value="" autocomplete="off"/></div></td></tr><tr><td> </td><td><a id="AAA-AS-SI1-SE007" href="javascript:requestForgottenPassword(document.frmRequestFP,document.getElementById('AAA-AS-SI1-SE003').value,'en-US','charcoal','refinitiv','null');" tabIndex="5"> Forgotten your password? </a></td></tr></table><div class='signin_autoarea'><div id="AAA-AS-SI1-SE008"><a id="AAA-AS-SI1-SE008_CheckBox_TRUE" class="checkbox" href="javascript:void(0)" tabIndex="3" data-value="#AAA-AS-SI1-SE008_Value"></a> <a id="AAA-AS-SI1-SE009" class='checkbox_label' href="javascript:void(0)" tabIndex="-1"> Sign me in automatically </a><input type="hidden" class='hiddensubmit' id="AAA-AS-SI1-SE008_Value" name="IDToken3" value="FALSE"/></div><div class="small_font signin_autohint " id="AAA-AS-SI1-SE010"> Do not use if device is shared. </div><input id="Submit1" type="submit" class="hiddensubmit" hideFocus="true" tabIndex='-1'/></div><div class='buttonarea' id="buttonarea_AAA-AS-SI1"><script type='text/javascript'>createImageButton("AAA-AS-SI1-SE014","Sign In","defaultSubmit(\\'AAA-AS-SI1-SE014\\')",4,"button_75",true);createImageButton("AAA-AS-SI1-SE015","Cancel","closeWindow()",7,"button_75");</script></div><div class="signin_errormsg" id="AAA-AS-SI1-SE012"></div></form></div></div></div><div class="footer"><div id="AAA-AS-SI-SE009" class="footer_sep"></div><div class="footer_content"><a id="AAA-AS-SI-SE015" href="https://my.refinitiv.com/content/mytr/en/signin.html" target="_blank" tabIndex="9"> MyRefinitiv </a><span class="footer_content_sep"></span><a id="AAA-AS-SI-SE016" href="https://www.refinitiv.com/en/policies/privacy-statement" target="_blank" tabIndex="10"> Privacy Statement </a><span class="footer_content_sep"></span><a id="AAA-AS-SI-SE017" href="https://www.refinitiv.com/en/about-us" target="_blank" tabIndex="11"> About Us </a><span class="footer_content_sep"></span><a id="AAA-AS-SI-SE012" href="https://my.refinitiv.com/content/mytr/en/productsupport.html" target="_blank" tabIndex="12"> Help </a></div></div></div></div><form name="frmRequestFP" action="" method="post"><input type="hidden" name="userId" value=""/><input type="hidden" name="locale" value=""/></form><form name="Login" action="/auth/UI/Login" method="post"><input type="hidden" name="goto" value="L2F1dGgvY2Rjc2VydmxldD9UQVJHRVQ9aHR0cHMlM0ElMkYlMkZlbWVhMS5hcHBzLmNwLnRob21zb25yZXV0ZXJzLmNvbSUyRkFwcHMlMkZVREYlMkZNU0YlM0ZhbXBvc3RwcmVzZXJ2ZSUzRGQyNjM4NGViLTVlZmYtN2Q0Zi05NzI5LWVmMjQwNzk4ZTUyNyUyNnNydiUzRERUQ1AtRVJQQ1BSUDAxJk1pbm9yVmVyc2lvbj0wJlJlcXVlc3RJRD02RDkwMzc4RTBBNzY2NTYyQzVBRkNENEUxNjA0NDM5OEY3QzcyNUI0OTk2QjI5OTRGRUU0MTc5RjgyQUYwNDlBJnRoZW1lPWNoYXJjb2FsJlByb3ZpZGVySUQ9aHR0cHMlM0ElMkYlMkZlbWVhMS5wcm94eS5jcC50aG9tc29ucmV1dGVycy5jb20lM0E0NDMlMkZhbWFnZW50Jklzc3VlSW5zdGFudD0yMDIxLTAxLTA3VDEyJTNBNTYlM0EyNFomTWFqb3JWZXJzaW9uPTE="/><input type="hidden" name="encoded" value="true"/><input type="hidden" name="locale" value="en-US"/><input type="hidden" name="product" value=""/><input type="hidden" name="eso" value=""/><input type="hidden" name="username" value=""/><input type="hidden" name="IDButton" value=''/><input type="hidden" name="fs" value=""/><input type="hidden" name="epaid" value=""/><input type="hidden" name="realm" value=""/><input type='hidden' name='IDToken1'/><input type='hidden' name='IDToken2'/><input type='hidden' name='IDToken3'/><input type='hidden' name='IDToken4'/><input type="hidden" name="gx_charset" value="UTF-8"/></form></body></html>
Traceback (most recent call last):
File "<ipython-input-6-80f295b13dac>", line 1, in <module>
loop_screen, error =ek.get_data(each_request,fields)
File "C:\Users\florian\AppData\Local\Continuum\anaconda3\lib\site-packages\eikon\data_grid.py", line 198, in get_data
return get_data_frame(result, field_name)
File "C:\Users\florian\AppData\Local\Continuum\anaconda3\lib\site-packages\eikon\data_grid.py", line 247, in get_data_frame
headers = [header['displayName'] for header in data_dict['headers'][0]]
KeyError: 'headers'
I would be happy for your help!
