error line 151 data_grid.py

guillaume.lefur

Hi, I have a py script with a while loop. I request price every 120 seconds. After a variable number of loops, I have the following error :

File "CCCIWebReports.py", line 44, in <module>
CCCI_Mono_LastPrice_temp = pd.DataFrame(ek.get_data(CCCI_Mono_LastPrice_temp ,['CF_LAST','PCTCHNG','CF_TIME'])[0])
File "C:\ProgramData\Anaconda3\lib\site-packages\eikon\data_grid.py", line 151, in get_data
result = eikon.json_requests.send_json_request(DataGrid_UDF_endpoint, payload, debug=debug)
File "C:\ProgramData\Anaconda3\lib\site-packages\eikon\json_requests.py", line 87, in send_json_request
check_server_error(result)
File "C:\ProgramData\Anaconda3\lib\site-packages\eikon\json_requests.py", line 135, in check_server_error
raise requests.HTTPError(error_message, response=server_response)
requests.exceptions.HTTPError: An error occurred while sending the request.

pf

Hi,

As the error occurred while sending the request, the proxy could log something.
Could you look at the C:\Users\<username>\AppData\Roaming\Thomson Reuters\Eikon API Proxy\Logs directory and check in the last eikon-api-proxy.2018mmdd.xxxxxx.pxxxx sub-directory. One of browser_xxx files should contains more information.

Otherwise, just a comment : your line of code is confusing.

CCCI_Mono_LastPrice_temp = pd.DataFrame(ek.get_data(CCCI_Mono_LastPrice_temp ,['CF_LAST','PCTCHNG','CF_TIME'])[0])

=> CCCI_Mono_LastPrice_temp should contains a RIC or a list of RICs, but you replace it with an extract of the result.
By the way, I assume that you reinitialize the content before the next request.