Error code 408 | Request timeout occured - JSON request

bill39
bill39 Explorer
in Eikon Data APIs

In Terminal I try to run my python file that should download a large quantity of data as a CSV file.

I get the error code 408. Something about a JSON request. How do I fix this?


(base) U:\Castellain\refinitiv>python dailyAPIcode.py

Request timeout occured

Traceback (most recent call last):

File "dailyAPIcode.py", line 25, in <module>

'TR.RNSARPctOSPostTrans'])

File "C:\Users\william\AppData\Local\Continuum\anaconda3\lib\site-packages\eikon\data_grid.py", line 186, in get_data

result = eikon.json_requests.send_json_request(_endpoint, payload, debug=debug)

File "C:\Users\william\AppData\Local\Continuum\anaconda3\lib\site-packages\eikon\json_requests.py", line 118, in send_json_request

_check_server_error(result)

File "C:\Users\william\AppData\Local\Continuum\anaconda3\lib\site-packages\eikon\json_requests.py", line 194, in _check_server_error

raise EikonError(int(server_response['ErrorCode']), error_message)

eikon.eikonError.EikonError: Error code 408 | Request timeout occured



FROM THE .PY FILE:



#import packages
import eikon as ek # the Eikon Python wrapper package
import pandas as pd
import numpy as np
import datetime
from datetime import timedelta, date, datetime
from pandas.tseries.offsets import BDay

#connects to Bill's Eikon terminal
ek.set_app_key('xxxxxxxxxxxxxxxxxxxxx')

#Buyback fields with dynamic date constraints for a list of RICs AND export as CSV to U:Castellain/refinitiv

 df,e = ek.get_data("lists('Inv Trust List')","TR.RIC")
 ric_list = df['Instrument'].tolist()
 df, e = ek.get_data(ric_list,
                    ['TR.RNSFilerName',
                     'TR.RNSAnnouncedDate',
                     'TR.RNSTransactionType',
                     'TR.RNSARNumShrsTransacted',
                     'TR.RNSARPctOSTransacted',
                     'TR.RNSARTransactionPrice',
                     'TR.RNSARMktValTransaction',
                     'TR.RNSARTotShrsPostTrans',
                     'TR.RNSARPctOSPostTrans'])

end_date = date.today()
 start_date = end_date - timedelta(days=365)

 end_date_str = datetime.strftime(end_date, "%Y-%m-%d")
 start_date_str = datetime.strftime(start_date, "%Y-%m-%d")

 df['RNS Announced Date'] = pd.to_datetime(df['RNS Announced Date'])
 mask = (df['RNS Announced Date'] > start_date_str) & (df['RNS Announced Date'] <= end_date_str)
 df = df.loc[mask]

df.rename(columns={'RNS AR Price (at Transaction) - £': 'RNS AR Price (at Transaction) GBP',
                   'RNS AR Market Value of Transaction - £': 'RNS AR Market Value of Transaction - GBP'},
          inplace=True)

#create file name and export
todays_date = date.today()
 todays_date_str = datetime.strftime(todays_date, "%Y%m%d")
 df.to_csv('Daily API Download_' + todays_date_str + '.csv')



Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    Hi @bill39

    Please read the API limitation guide at https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs?content=49692&type=documentation_item

    You are mostly exceeding the limitation (10000 records per API call)


    I do not know what is inside your lists('Inv Trust List').

    Assuming that it is a large list as you mentioned and it may be a culprit.

    So you can split them into a smaller list per API call.

    Here is a modified code to break the list down into multiple smaller groups.

    Please note that I added the time package (import time)

    #import packages
    import eikon as ek # the Eikon Python wrapper package
    import pandas as pd
    import numpy as np
    import datetime
    import time
    from datetime import timedelta, date, datetime
    from pandas.tseries.offsets import BDay
     
    ek.set_app_key('xxxxxxxxxxxxxxxxxxxxx')

    #assuming that these are RIC code in ric_list, in your program, it reads from lists
    ric_list = ['AAL.L','ABF.L','ADML.L','AHT.L','ANTO.L','AV.L','AZN.L','BAES.L']

    #split them into a group of 'ric_per_call' into array_ric_list
    ric_per_call = 3 #change to any number of RIC per API call
    array_ric_list = []
    i = 0
    while i < len(ric_lists)/ric_per_call:
        array_ric_list.append(ric_lists[i*ric_per_call:(i+1)*ric_per_call])
        i += 1


    #loop API call between groups of RIC
    end_date = date.today()
    start_date = end_date - timedelta(days=365)

    end_date_str = datetime.strftime(end_date, "%Y-%m-%d")
    start_date_str = datetime.strftime(start_date, "%Y-%m-%d")

    todays_date = date.today()
    todays_date_str = datetime.strftime(todays_date, "%Y%m%d")

    addHeader = True #this variable to addHeader to csv just one time

    for riccodes in array_ric_list:
        print("API calls for:",riccodes)
        df, e = ek.get_data(riccodes,
                        ['TR.RNSFilerName','TR.RNSAnnouncedDate','TR.RNSTransactionType',
                         'TR.RNSARNumShrsTransacted','TR.RNSARPctOSTransacted',
                         'TR.RNSARTransactionPrice','TR.RNSARMktValTransaction',
                         'TR.RNSARTotShrsPostTrans','TR.RNSARPctOSPostTrans'])

        df['RNS Announced Date'] = pd.to_datetime(df['RNS Announced Date'])
        mask = (df['RNS Announced Date'] > start_date_str) & (df['RNS Announced Date'] <= end_date_str)
        df = df.loc[mask]

        df.rename(columns={'RNS AR Price (at Transaction) - £': 'RNS AR Price (at Transaction) GBP',
                           'RNS AR Market Value of Transaction - £': 'RNS AR Market Value of Transaction - GBP'},
                  inplace=True)

        if addHeader:
            df.to_csv('Daily API Download_' + todays_date_str + '.csv', header=True)
            addHeader=False #Only add header one time
        else:
            df.to_csv('Daily API Download_' + todays_date_str + '.csv', mode='a', header=False)
        
        time.sleep(5) #delay between each API call

    print('Done')

    Here is the result:

    API calls for: ['AAL.L', 'ABF.L', 'ADML.L']
    API calls for: ['AHT.L', 'ANTO.L', 'AV.L']
    API calls for: ['AZN.L', 'BAES.L'] Done

Answers

Categories