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 GI · Feb 21, 2019 at 06:21 AM · pythoneikoneikon api

Python REST API - Processing Failed (Screener request)

Our API request was working yesterday however today it is failing and not returning any instruments. This appears to be the only request which is affected.

Here is the error we get back from Eikon

[{'code': 800, 'col': 1, 'message': 'SCREEN(IN(TR.ExchangeCountryCode,"IT","ES","BE","FR","DE","NL","CH","NO","SE","GB","CA","US","AU","NZ"),TR.CompanyMarketCap(Sdate=0D)/*Market Cap*/>=1000000000,TR.NumberOfAnalysts(Period=FY1)>=2) processing failed.', 'row': 0}]

It shows the screening request as well. I can't find any help with error code 800 or with "processing failed"

What makes this very strange is we have another process that used the Eikon APIs for funds. Getting the data is working fine

ek.get_data(slice_isin_codes, request_fields, request_params)

This request which is a list of ISINs rather than the screener call has no issues.

The screener request (below) is returning processing failed, either code has changes in the last 48 hours and both were running correctly before.

ek.get_data(screener_exp, request_fields)

Any ideas or help?

People who like this

0 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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Feb 21, 2019 at 06:43 AM

@creator remove the quotes around the country codes:

'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,IT, ES, BE, FR, DE, NL, CH, NO, SE, GB, CA, US, AU ,NZ), TR.CompanyMarketCap(SDate=0D)>=1000000000, TR.NumberOfAnalysts(Period=FY1)>=2, CURN=USD)'

this screener query yields ~6.5k instruments.

Comment
GI
raptorsun

People who like this

2 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
raptorsun · Feb 21, 2019 at 08:11 AM 0
Share

Hello Zhenya, is there an online document for the query syntax? at the moment we are relying on excel plugin to build the query.

avatar image
REFINITIV
Alex Putkov. ♦♦ raptorsun · Feb 21, 2019 at 11:40 AM 0
Share

The Screener wizard in Excel is currently the only way to build a Screener expression.

avatar image
Answer by GI · Feb 21, 2019 at 06:48 AM

Changed the line from:

screener_exp = """SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/),IN(TR.ExchangeCountryCode,"IT","ES","BE","FR","DE","NL","CH","NO","SE","GB","CA","US","AU","NZ"),TR.CompanyMarketCap(Sdate=0D)/*Market Cap*/>=1000000000,TR.NumberOfAnalysts(Period=FY1)>=2)"""
to:

screener_exp = """SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,IT, ES, BE, FR, DE, NL, CH, NO, SE, GB, CA, US, AU ,NZ), TR.CompanyMarketCap(SDate=0D)>=1000000000, TR.NumberOfAnalysts(Period=FY1)>=2, CURN=USD)"""
And the process is now successfully running.

I'll need to double check the whole process completed but the process is now downloading data whereas it wasn't before.

This wasn't an issue for us before, what has changed?

The CURN USD is new but that hasn't impacted the total number of stocks returned (as USD is the default anyway for us.)

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.

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 >
9 People are following this question.

Related Questions

Eikon Python API Empty Response for Private Company Financial Data - e.g. TR.Revenue, TR.GrossProfit

List of parameters for a given TR field.

How to find field names in Eikon Python API?

Extracting all historical companies listed on the ASX using the Python API?

What types of streaming features are there?

  • 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