Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by yiyezhou · Mar 18, 2020 at 07:51 PM · eikon apierror code 1422

API Request: Error code 1422 | Can not process metadata for request: DataGrid_StandardAsync.requests.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?

charleszhou

People who like this

1 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Replies

  • Sort: 
avatar image
Best Answer
Answer by yiyezhou · Mar 20, 2020 at 12:41 AM

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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by chavalit.jintamalit · Mar 19, 2020 at 12:36 AM

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)



ahs.png (74.9 KiB)
Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
yiyezhou · Mar 19, 2020 at 10:54 PM 0
Share

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"]).

avatar image
REFINITIV
chavalit.jintamalit ♦♦ yiyezhou · Mar 19, 2020 at 11:33 PM 0
Share

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.

avatar image
REFINITIV
Answer by wasin.waeosri · Mar 19, 2020 at 03:04 AM

Hello @yiyezhou

Could you please also share the error message/exception that you encountered?

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
yiyezhou · Mar 19, 2020 at 10:57 PM 0
Share

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)

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Using get_data() to get 5min and 1min data.

Eikon API: Retrieving filing date for annual reports

Eikon API .NET communication channel with Eikon

X_CURRENCY field

Eikon Desktop Data API stopped working after changing to a new user on Eikon terminal

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges