20 Quarters data for Institutional ownership for list of companies
Hi community, I am trying to download the quarterly data for percentage of shares held by Institutional investors.
When I try and download data i get the following error :
EikonError: Error code 408 | HTTP TimeoutException: .
Does anyone know what is going wrong? Please see attached the picture and code.
@Jirapongse Your help would be highly appreciated.
df,err = ek.get_data("List('io-july2023')", [
'TR.SharesHeld.calcdate',
'TR.InvestorFullName',
'TR.SharesHeld',
'TR.PctOfSharesOutHeld',
'TR.InvestorType',
'TR.InvestorTypeId'],parameters={'EDate':'-20', 'Period':'FQ0','Frq':'FQ',"TheInvestorType":"101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412"})
df
#EDate is the number of quaters
#I want to calculate the number of shares held by investors quarterly from 30 june 2023 - 5 years back which is 20 quarters back.
# I want data for the following dates one by one:
#1. from 30 june 2020 -5 years back
#2. from 30 june 2021 -5 years back
#3. from 30 june 2022 -5 years back
#4.from 30 june 2023 -5 years back
Find more posts tagged with
@Jirapongse This is what i recieved on my end when I used the code you referred and then ran my code.
2023-07-25 09:53:02,907 P[19488] [MainThread 15932] entity: DataGrid_StandardAsync
2023-07-25 09:53:02,910 P[19488] [MainThread 15932] payload: {'requests': [{'instruments': ["List('io-july2023')"], 'fields': [{'name': 'TR.SharesHeld.calcdate'}, {'name': 'TR.InvestorFullName'}, {'name': 'TR.SharesHeld'}, {'name': 'TR.PctOfSharesOutHeld'}, {'name': 'TR.InvestorType'}, {'name': 'TR.InvestorTypeId'}], 'parameters': {'EDate': '-20', 'Period': 'FQ0', 'Frq': 'FQ', 'TheInvestorType': '101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412'}}]}
2023-07-25 09:53:02,912 P[19488] [MainThread 15932] Request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'instruments': ["List('io-july2023')"], 'fields': [{'name': 'TR.SharesHeld.calcdate'}, {'name': 'TR.InvestorFullName'}, {'name': 'TR.SharesHeld'}, {'name': 'TR.PctOfSharesOutHeld'}, {'name': 'TR.InvestorType'}, {'name': 'TR.InvestorTypeId'}], 'parameters': {'EDate': '-20', 'Period': 'FQ0', 'Frq': 'FQ', 'TheInvestorType': '101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412'}}]}}}
2023-07-25 09:53:02,914 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:53:12,804 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'501')] and cookies None
2023-07-25 09:53:12,806 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":10000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:12,808 P[19488] [MainThread 15932] HTTP Response code: 200
2023-07-25 09:53:12,810 P[19488] [MainThread 15932] HTTP Response: {"responses":[{"estimatedDuration":10000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:12,811 P[19488] [MainThread 15932] Response size: 534
2023-07-25 09:53:12,812 P[19488] [MainThread 15932] Receive ticket from responses, wait for 10.0 seconds
2023-07-25 09:53:22,818 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:53:22,822 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:53:23,562 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:53:23,565 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":16000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:23,566 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":16000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:23,567 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:53:38,572 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:53:38,573 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:53:39,018 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:53:39,020 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":32000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:39,022 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":32000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:39,024 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:53:54,037 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:53:54,038 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:53:55,011 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:53:55,013 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":32000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:55,015 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":32000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:53:55,017 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:54:10,023 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:54:10,026 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:54:10,753 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:54:10,754 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:10,755 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:10,757 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:54:25,762 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:54:25,764 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:54:26,677 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:54:26,679 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:26,680 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:26,682 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:54:41,694 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:54:41,697 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:54:42,159 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:54:42,161 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:42,164 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:42,165 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:54:57,167 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:54:57,169 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:54:57,621 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:54:57,624 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:57,625 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:54:57,627 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:55:12,642 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:55:12,645 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:55:13,409 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:55:13,411 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:13,413 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:13,414 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:55:28,429 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:55:28,432 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:55:28,902 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:55:28,904 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:28,906 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:28,908 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:55:43,923 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:55:43,926 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:55:44,372 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:55:44,374 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:44,375 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:44,377 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:55:59,387 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:55:59,390 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:55:59,990 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:55:59,992 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:59,993 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:55:59,995 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:56:15,000 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:56:15,003 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:56:15,741 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:56:15,744 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:56:15,747 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:56:15,748 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:56:30,757 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:56:30,760 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:56:31,224 P[19488] [MainThread 15932] Send request with headers [(b'Host', b'127.0.0.1:9060'), (b'Accept-Encoding', b'gzip, deflate, br'), (b'Connection', b'keep-alive'), (b'User-Agent', b'python-httpx/0.23.0'), (b'Accept', b'application/json'), (b'Content-Type', b'application/json'), (b'x-tr-applicationid', b'ce0f060c6eb3446482da792f3bc0e031fa7b0a01'), (b'Authorization', b'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'), (b'Content-Length', b'506')] and cookies None
2023-07-25 09:56:31,226 P[19488] [MainThread 15932] HTTP request response 200: {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:56:31,227 P[19488] [MainThread 15932] HTTP Response: 200 - {"responses":[{"estimatedDuration":60000,"ticket":"7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA"}]}
2023-07-25 09:56:31,228 P[19488] [MainThread 15932] Receive ticket from responses, wait for 15.0 seconds
2023-07-25 09:56:46,237 P[19488] [MainThread 15932] Send ticket request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'ticket': '7CF4C5672B1942F29751AE0F042ED36D_AQAAAA==_H4sIAAAAAAAEALWST0vDMBjGv8t7mUI3mjauM2ctDsRV7U12qG3GIlk6k1Qopd/dJxORHbxIPfzgffP8IQ0dSBnnbXeQxjsSL3SvnL+YqXb+1uk+iZN0dknbiHZK6iYYBtLVq9QkiCIy1UFiKp8Wz/vKSncH06KudN1UXkI/VhYOLy2SptM6Itdaj4RpTdDDVljVWuV7EvEY/dK+Nh/S+dbm6HgIp9NV/1x8wtKi9pvdV/Om8xOXfz9G2R//441D7fov992eRwa6vQl/gaB5EsOe23fM+SPGQiLWnLaglHt59k2CWMwEixOQAg6WIAMrwVgMoDFoDBqDxjKRwp/Cy5HlmDmy/LRfgSXIwApcC44OzuBjCY3jJyheO9EEAwAA'}]}}}
2023-07-25 09:56:46,240 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJBcGlWZXJzaW9uIjoiMSIsIkFwcEtleSI6ImNlMGYwNjBjNmViMzQ0NjQ4MmRhNzkyZjNiYzBlMDMxZmE3YjBhMDEiLCJBcHBTY29wZSI6InRyYXBpIiwiTGlicmFyeU5hbWUiOiJSRFAgUHl0aG9uIExpYnJhcnkiLCJMaWJyYXJ5VmVyc2lvbiI6IjEuMS4xNiIsImlhdCI6MTY5MDI3NTA1NywiZXhwIjoxNjkxNDg0NjU3fQ.-lnmI8hLO_qNCGNEe3BuzGkE4V-XnAU6gFG8yxx9fbg'}
params = None
2023-07-25 09:57:01,257 P[19488] [MainThread 15932] TimeoutException on HTTP request: ReadTimeout('')
2023-07-25 09:57:01,259 P[19488] [MainThread 15932] HTTP TimeoutException: .
---------------------------------------------------------------------------
CancelledError Traceback (most recent call last)
File ~\Anaconda3\lib\site-packages\httpcore\backends\asyncio.py:33, in AsyncIOStream.read(self, max_bytes, timeout)
32 try:
---> 33 return await self._stream.receive(max_bytes=max_bytes)
34 except anyio.EndOfStream: # pragma: nocover
File ~\Anaconda3\lib\site-packages\anyio\_backends\_asyncio.py:1105, in SocketStream.receive(self, max_bytes)
1104 self._transport.resume_reading()
-> 1105 await self._protocol.read_event.wait()
1106 self._transport.pause_reading()
File ~\Anaconda3\lib\asyncio\locks.py:226, in Event.wait(self)
225 try:
--> 226 await fut
227 return True
File ~\Anaconda3\lib\asyncio\futures.py:284, in Future.__await__(self)
283 self._asyncio_future_blocking = True
--> 284 yield self # This tells Task to wait for completion.
285 if not self.done():
File ~\Anaconda3\lib\asyncio\tasks.py:328, in Task.__wakeup(self, future)
327 try:
--> 328 future.result()
329 except BaseException as exc:
330 # This may also be a cancellation.
File ~\Anaconda3\lib\asyncio\futures.py:196, in Future.result(self)
195 exc = self._make_cancelled_error()
--> 196 raise exc
197 if self._state != _FINISHED:
CancelledError:
During handling of the above exception, another exception occurred:
TimeoutError Traceback (most recent call last)
File ~\Anaconda3\lib\site-packages\httpcore\_exceptions.py:8, in map_exceptions(map)
7 try:
----> 8 yield
9 except Exception as exc: # noqa: PIE786
File ~\Anaconda3\lib\site-packages\httpcore\backends\asyncio.py:35, in AsyncIOStream.read(self, max_bytes, timeout)
34 except anyio.EndOfStream: # pragma: nocover
---> 35 return b""
File ~\Anaconda3\lib\site-packages\anyio\_core\_tasks.py:103, in FailAfterContextManager.__exit__(self, exc_type, exc_val, exc_tb)
102 if self._cancel_scope.cancel_called:
--> 103 raise TimeoutError
105 return retval
TimeoutError:
During handling of the above exception, another exception occurred:
ReadTimeout Traceback (most recent call last)
File ~\Anaconda3\lib\site-packages\httpx\_transports\default.py:60, in map_httpcore_exceptions()
59 try:
---> 60 yield
61 except Exception as exc: # noqa: PIE-786
File ~\Anaconda3\lib\site-packages\httpx\_transports\default.py:353, in AsyncHTTPTransport.handle_async_request(self, request)
352 with map_httpcore_exceptions():
--> 353 resp = await self._pool.handle_async_request(req)
355 assert isinstance(resp.stream, typing.AsyncIterable)
File ~\Anaconda3\lib\site-packages\httpcore\_async\connection_pool.py:253, in AsyncConnectionPool.handle_async_request(self, request)
252 await self.response_closed(status)
--> 253 raise exc
254 else:
File ~\Anaconda3\lib\site-packages\httpcore\_async\connection_pool.py:237, in AsyncConnectionPool.handle_async_request(self, request)
236 try:
--> 237 response = await connection.handle_async_request(request)
238 except ConnectionNotAvailable:
239 # The ConnectionNotAvailable exception is a special case, that
240 # indicates we need to retry the request on a new connection.
(...)
244 # might end up as an HTTP/2 connection, but which actually ends
245 # up as HTTP/1.1.
File ~\Anaconda3\lib\site-packages\httpcore\_async\connection.py:90, in AsyncHTTPConnection.handle_async_request(self, request)
88 raise ConnectionNotAvailable()
---> 90 return await self._connection.handle_async_request(request)
File ~\Anaconda3\lib\site-packages\httpcore\_async\http11.py:105, in AsyncHTTP11Connection.handle_async_request(self, request)
104 await self._response_closed()
--> 105 raise exc
File ~\Anaconda3\lib\site-packages\httpcore\_async\http11.py:84, in AsyncHTTP11Connection.handle_async_request(self, request)
76 async with Trace(
77 "http11.receive_response_headers", request, kwargs
78 ) as trace:
79 (
80 http_version,
81 status,
82 reason_phrase,
83 headers,
---> 84 ) = await self._receive_response_headers(**kwargs)
85 trace.return_value = (
86 http_version,
87 status,
88 reason_phrase,
89 headers,
90 )
File ~\Anaconda3\lib\site-packages\httpcore\_async\http11.py:148, in AsyncHTTP11Connection._receive_response_headers(self, request)
147 while True:
--> 148 event = await self._receive_event(timeout=timeout)
149 if isinstance(event, h11.Response):
File ~\Anaconda3\lib\site-packages\httpcore\_async\http11.py:177, in AsyncHTTP11Connection._receive_event(self, timeout)
176 if event is h11.NEED_DATA:
--> 177 data = await self._network_stream.read(
178 self.READ_NUM_BYTES, timeout=timeout
179 )
181 # If we feed this case through h11 we'll raise an exception like:
182 #
183 # httpcore.RemoteProtocolError: can't handle event type
(...)
187 # perspective. Instead we handle this case distinctly and treat
188 # it as a ConnectError.
File ~\Anaconda3\lib\site-packages\httpcore\backends\asyncio.py:35, in AsyncIOStream.read(self, max_bytes, timeout)
34 except anyio.EndOfStream: # pragma: nocover
---> 35 return b""
File ~\Anaconda3\lib\contextlib.py:137, in _GeneratorContextManager.__exit__(self, typ, value, traceback)
136 try:
--> 137 self.gen.throw(typ, value, traceback)
138 except StopIteration as exc:
139 # Suppress StopIteration *unless* it's the same exception that
140 # was passed to throw(). This prevents a StopIteration
141 # raised inside the "with" statement from being suppressed.
File ~\Anaconda3\lib\site-packages\httpcore\_exceptions.py:12, in map_exceptions(map)
11 if isinstance(exc, from_exc):
---> 12 raise to_exc(exc)
13 raise
ReadTimeout:
The above exception was the direct cause of the following exception:
ReadTimeout Traceback (most recent call last)
File ~\Anaconda3\lib\site-packages\eikon\json_requests.py:114, in send_json_request(entity, payload, debug)
113 logger.debug('Send ticket request:{}'.format(ticket_request))
--> 114 response = profile.send_request(json=ticket_request, timeout=(15.0, 15.0))
116 try:
File ~\Anaconda3\lib\site-packages\eikon\Profile.py:348, in Profile.send_request(self, json, timeout)
347 def send_request(self, json, timeout=None):
--> 348 response = self._desktop_session.http_request(url=self.get_url(),
349 method="POST",
350 headers={'Content-Type': 'application/json',
351 'x-tr-applicationid': self.get_app_key()},
352 json=json,
353 timeout=timeout)
354 return response
File ~\Anaconda3\lib\site-packages\eikon\streaming_session\session.py:670, in Session.http_request(self, url, method, headers, data, params, json, auth, loop, **kwargs)
669 loop = self._loop
--> 670 response = loop.run_until_complete(self.http_request_async(url, method, headers, data,
671 params, json, auth, **kwargs))
672 return response
File ~\Anaconda3\lib\site-packages\nest_asyncio.py:89, in _patch_loop.<locals>.run_until_complete(self, future)
87 raise RuntimeError(
88 'Event loop stopped before Future completed.')
---> 89 return f.result()
File ~\Anaconda3\lib\asyncio\futures.py:201, in Future.result(self)
200 if self._exception is not None:
--> 201 raise self._exception
202 return self._result
File ~\Anaconda3\lib\asyncio\tasks.py:256, in Task.__step(***failed resolving arguments***)
253 if exc is None:
254 # We use the `send` method directly, because coroutines
255 # don't have `__iter__` and `__next__` methods.
--> 256 result = coro.send(None)
257 else:
File ~\Anaconda3\lib\site-packages\eikon\streaming_session\session.py:658, in Session.http_request_async(self, url, method, headers, data, params, json, closure, auth, loop, **kwargs)
657 self.log(1, f'TimeoutException on HTTP request: {t!r}')
--> 658 raise t
659 except Exception as e:
File ~\Anaconda3\lib\site-packages\eikon\streaming_session\session.py:637, in Session.http_request_async(self, url, method, headers, data, params, json, closure, auth, loop, **kwargs)
636 try:
--> 637 _request_response = await self._http_session.request(
638 method,
639 url,
640 headers=headers,
641 cookies=cookies,
642 data=data,
643 params=params,
644 json=json,
645 **kwargs
646 )
648 self.log(
649 1,
650 f'Send request with headers '
651 f'{_request_response.request.headers.raw} and cookies {cookies}'
652 )
File ~\Anaconda3\lib\site-packages\httpx\_client.py:1527, in AsyncClient.request(self, method, url, content, data, files, json, params, headers, cookies, auth, follow_redirects, timeout, extensions)
1514 request = self.build_request(
1515 method=method,
1516 url=url,
(...)
1525 extensions=extensions,
1526 )
-> 1527 return await self.send(request, auth=auth, follow_redirects=follow_redirects)
File ~\Anaconda3\lib\site-packages\httpx\_client.py:1614, in AsyncClient.send(self, request, stream, auth, follow_redirects)
1612 auth = self._build_request_auth(request, auth)
-> 1614 response = await self._send_handling_auth(
1615 request,
1616 auth=auth,
1617 follow_redirects=follow_redirects,
1618 history=[],
1619 )
1620 try:
File ~\Anaconda3\lib\site-packages\httpx\_client.py:1642, in AsyncClient._send_handling_auth(self, request, auth, follow_redirects, history)
1641 while True:
-> 1642 response = await self._send_handling_redirects(
1643 request,
1644 follow_redirects=follow_redirects,
1645 history=history,
1646 )
1647 try:
File ~\Anaconda3\lib\site-packages\httpx\_client.py:1679, in AsyncClient._send_handling_redirects(self, request, follow_redirects, history)
1677 await hook(request)
-> 1679 response = await self._send_single_request(request)
1680 try:
File ~\Anaconda3\lib\site-packages\httpx\_client.py:1716, in AsyncClient._send_single_request(self, request)
1715 with request_context(request=request):
-> 1716 response = await transport.handle_async_request(request)
1718 assert isinstance(response.stream, AsyncByteStream)
File ~\Anaconda3\lib\site-packages\httpx\_transports\default.py:353, in AsyncHTTPTransport.handle_async_request(self, request)
352 with map_httpcore_exceptions():
--> 353 resp = await self._pool.handle_async_request(req)
355 assert isinstance(resp.stream, typing.AsyncIterable)
File ~\Anaconda3\lib\contextlib.py:137, in _GeneratorContextManager.__exit__(self, typ, value, traceback)
136 try:
--> 137 self.gen.throw(typ, value, traceback)
138 except StopIteration as exc:
139 # Suppress StopIteration *unless* it's the same exception that
140 # was passed to throw(). This prevents a StopIteration
141 # raised inside the "with" statement from being suppressed.
File ~\Anaconda3\lib\site-packages\httpx\_transports\default.py:77, in map_httpcore_exceptions()
76 message = str(exc)
---> 77 raise mapped_exc(message) from exc
ReadTimeout:
During handling of the above exception, another exception occurred:
EikonError Traceback (most recent call last)
Input In [6], in <cell line: 1>()
----> 1 df,err = ek.get_data("List('io-july2023')", [
2 'TR.SharesHeld.calcdate',
3 'TR.InvestorFullName',
4 'TR.SharesHeld',
5 'TR.PctOfSharesOutHeld',
6 'TR.InvestorType',
7 'TR.InvestorTypeId'],parameters={'EDate':'-20', 'Period':'FQ0','Frq':'FQ',"TheInvestorType":"101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412" })
8 df
File ~\Anaconda3\lib\site-packages\eikon\data_grid.py:190, in get_data(instruments, fields, parameters, field_name, raw_output, debug)
187 if _endpoint == DataGridAsync_UDF_endpoint:
188 payload = {'requests': [payload]}
--> 190 result = eikon.json_requests.send_json_request(_endpoint, payload, debug=debug)
192 if result.get('responses'):
193 result = result['responses'][0]
File ~\Anaconda3\lib\site-packages\eikon\json_requests.py:131, in send_json_request(entity, payload, debug)
129 error_msg = f'HTTP TimeoutException: {timeout_exception}.'
130 logger.error(error_msg)
--> 131 raise EikonError(408, error_msg)
132 except EikonError as eikon_err:
133 logger.error(f"HTTP request failed: {type(eikon_err).__name__}-{eikon_err.message}")
EikonError: Error code 408 | HTTP TimeoutException: .
Really sorry for the big error code but it comes down to the same eikon error :
EikonError: Error code 408 | HTTP TimeoutException: .
Yes, it is HTTP timeout. The default timeout value is 15 seconds which can't be changed.
2023-07-25 09:56:46,240 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1...'}
params = None
2023-07-25 09:57:01,257 P[19488] [MainThread 15932] TimeoutException on HTTP request: ReadTimeout('')
2023-07-25 09:57:01,259 P[19488] [MainThread 15932] HTTP TimeoutException: .
How many items does this list (List('io-july2023')) have?
You can try the Refinitiv Data Library with the desktop session. Please refer to this example.
With the Refinitiv Data Library, you can configure the HTTP timeout in the configuration file (refinitiv-data.config.json).
{
"http": {
"request-timeout": 60
},
...
}
@Jirapongse thank you for the help. There are only 23 companies in the list so it is not huge.
I havent used JSON before so i am not sure where to begin changing the time to 60 seconds.
Do you think I am able to retrieve quarterly data by breaking the code into two pieces and get 2 years of data at a time and then perhaps merge them together in a file?
It seems its taking time because of -20 quarters if i change it to -10 it retrieves it.
Having said that its strange that it is finding it hard to retrieve data for -20 because using DIB i can see it is able to retrieve data for more than 20 quarters.
In terms of the original code what adjustment would you suggest I make to the data if I want to retrieve between the 2 dates.
df,err = ek.get_data("List('io-july2023')", [
'TR.SharesHeld.calcdate',
'TR.InvestorFullName',
'TR.SharesHeld',
'TR.PctOfSharesOutHeld',
'TR.InvestorType',
'TR.InvestorTypeId'],parameters={'Sdate':'2023-06-30','Edate':'2018-06-30', 'Period':'FQ0','Frq':'FQ',"TheInvestorType":"101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412"})
df
Should I want to break down the period of 2023- 2018 am I able to adjust the code? If so please help me with code. You could perhaps generate it for any list you may have for demonstration purpose.
Thanks for your help in advance.
Please share all or some items in the List('io-july2023').
ANTO.L
GCC.L
CCT.L
COSG.L
TUNE.L
GRI.L
GNC.L
GSK.L
HLN.L
HERC.L
IHG.L
ITRK.L
JSE.L
KCT.L
LIAf.TRE
LLOY.L
LXFR.LTS
MAIH.L
MNDI.L
MGNS.L
MUL.L
NWOR.L
NXT.L
OXB.L
RCH.L
REL.L
RTO.L
SFES.L
SRP.L
SN.L
SMIN.L
SCTS.L
SDY.L
STAF.L
0RG4.L
TPK.L
TET.L
VIDV.L
VMUK.L
VLX.L
FAN.L
YOU.L
@Jirapongse a nicer display i hope
You can request four quarters per request.
The code looks like this:
df_list = []
for sdate in range(0, 20, 4):
sdate_str = str(sdate)+"Q" if sdate==0 else "-"+str(sdate)+"Q"
edate_str = "-"+str(sdate+3)+"Q"
print(sdate_str, edate_str)
df_temp,err = ek.get_data(List('io-july2023'), [
'TR.SharesHeld.calcdate',
'TR.InvestorFullName',
'TR.SharesHeld',
'TR.PctOfSharesOutHeld',
'TR.InvestorType',
'TR.InvestorTypeId'],parameters={'Sdate':sdate_str,'Edate':edate_str, 'Period':'FQ0','Frq':'FQ',"TheInvestorType":"101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412"})
df_list.append(df_temp)
print(df_temp["Calc Date"].unique())
df = pd.concat(df_list)
df
@Jirapongse That is super! I am now able to retrieve the data I wanted.
Just one last thing. The code starting point is the '2023-06-30' which is the latest quarter available.
Is it possible to change that to starting from another period eg '2022-06-30' and then go backwards 20 quarters?
Would i change that in the first line of code ?
for sdate in range("2022-06-30", 20, 4):
Would really appreciate this as it will allow me to download data from a specific range rather than starting from 2023 everytime.
Please try the following code:
from datetime import date
from dateutil.relativedelta import relativedelta
import pandas as pd
start_date = date(2022, 6, 30) #Set Start Date 2022-06-30
df_list = []
for i in range(1, 6): ##Loop 5 times (5*4 = 20)
end_date = start_date - relativedelta(months=9) #calculate end_date for 4 quarter
print(str(start_date)+", "+str(end_date))
df_temp,err = ek.get_data(rics, [
'TR.SharesHeld.calcdate',
'TR.InvestorFullName',
'TR.SharesHeld',
'TR.PctOfSharesOutHeld',
'TR.InvestorType',
'TR.InvestorTypeId'],
parameters={
'Sdate':str(start_date),
'Edate':str(end_date),
'Period':'FQ0',
'Frq':'FQ',
"TheInvestorType":"101:102:103:104:106:107:108:110:112:113:114:116:117:302:304:401:402:403:404:405:406:407:408:409:410:411:412"
})
df_list.append(df_temp)
print(df_temp["Calc Date"].unique())
start_date = end_date - relativedelta(months=3) #calculate the next start_date
df = pd.concat(df_list)
df
Yes, it is HTTP timeout. The default timeout value is 15 seconds which can't be changed.
2023-07-25 09:56:46,240 P[19488] [MainThread 15932] Request to http://127.0.0.1:9060/api/v1/data
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'ce0f060c6eb3446482da792f3bc0e031fa7b0a01', 'Authorization': 'Bearer eyJhbGciOiJIUzI1...'}
params = None
2023-07-25 09:57:01,257 P[19488] [MainThread 15932] TimeoutException on HTTP request: ReadTimeout('')
2023-07-25 09:57:01,259 P[19488] [MainThread 15932] HTTP TimeoutException: .
How many items does this list (List('io-july2023')) have?
You can try the Refinitiv Data Library with the desktop session. Please refer to this example.
With the Refinitiv Data Library, you can configure the HTTP timeout in the configuration file (refinitiv-data.config.json).
{
"http": {
"request-timeout": 60
},
...
}
@faiza.zafar
Thank you for reaching out to us.
It could be the HTTP Timeout.
Please enable logging in the API to verify what the problem is by using the following code.