API Request: Error code 1422 | Can not process metadata for request: DataGrid_StandardAsync.reque...

...sts.instruments - non-empty is required
I reran the following code I had successfully run before, but the error appeared this time.
Code:
Complete_Data, err = ek.get_data(List_RIC_Arr,
['TR.RetireDate','TR.ClosePrice.date','TR.ClosePrice','TR.CompanyMarketCap',
'TR.Volume','TR.TtlCmnSharesOut','TR.NumberOfAnalysts','TR.EPSNumberofEstimates',
'TR.EPSNumIncEstimates'],
{'Scale': 6, 'SDate': '2016-01-01', 'EDate': '2016-01-31', 'FRQ': 'D', 'Curn': 'AUD'})
List_RIC_Arr is a list of all RIC for ASX-listed companies.
I am wondering what is going on, and how should I handle this?
Best Answer
-
Yeah. I think I figured out what is going on. EQSRCH updated the screening output, which includes three empty cells in between, and this cause the data pull issue.
0
Answers
-
Hi @yiyezhou
Please restart your pc and Eikon Desktop application.
Then try again.
I can successfully retrieve the data (I repeated it for 10 times)
0 -
I did restarted everything today, but the problem still exists. My list is all of the ever listed ASX- listed companies, so there are 2612 companies in the list. I am wondering is it because Eikon updated the screen in EQSRCH function, which somehow cause the data pulling issue. I pulled the list by using the code List, err = ek.get_data("lists('ASX-Listed Company List')",["TR.RIC","TR.RetireDate"]).
0 -
Yes. Below is the major piece of the error message:
~\AppData\Local\Continuum\miniconda3\lib\site-packages\eikon\data_grid.py in get_data(instruments, fields, parameters, field_name, raw_output, debug)
187 payload = {'requests': [payload]}
188 --> 189 result = eikon.json_requests.send_json_request(_endpoint, payload, debug=debug)
190 191 if result.get('responses'):
~\AppData\Local\Continuum\miniconda3\lib\site-packages\eikon\json_requests.py in send_json_request(entity, payload, debug)
125 ticket = _check_ticket_async(result)
126 --> 127 _check_server_error(result)
128 return result
129 else:
~\AppData\Local\Continuum\miniconda3\lib\site-packages\eikon\json_requests.py in _check_server_error(server_response)
201 status, reason_phrase, version, content, headers = error_message.split(',')[:5]
202 logger.error(error_message)
--> 203 raise EikonError(int(server_response['ErrorCode']), error_message)
204 205 # check DataGrid response (server response is JSON and it can contain error + transactionId keys)0 -
Hi @yiyezhou
I do not have the same list as you.
Anyway, please try to reduce the number of RIC lists in a single API call.
Please refer to https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs?content=49692&type=documentation_item
The return datapoint should not exceed 10000 datapoints.
small_list = List_RIC_Arr[0:200]
Please split the list into a smaller list and try again.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 630 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛