Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Refinitiv Data Platform /
avatar image
REFINITIV
Question by jonathan.legrand · Sep 23, 2021 at 05:44 PM · refinitiv-data-platform

rdp.SearchViews max rows

Consider the following call:

df = rdp.Search.search(

view = rdp.SearchViews.MunicipalInstruments, # a view is a logical partitition of the dataset

top = 10000,

filter = "Country eq 'US'",

select = "IssuerName,CUSIP,Country,MaturityDate,IssueDate,IsActive,Ticker"

)

If I set top to 10k, I get 10k rows. If I set it to a higher value (or not set it at all), I get zero rows. Can you tell me how to set it so I get all rows here. There seem to be more than 10k rows.

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 nick.zincone · Sep 24, 2021 at 12:55 AM

Hi @jonathan.legrand

There are a few ways you can deal with results that exceed the limit. I would encourage you to read some of the suggestions outlined within the Limits Section within that article. I would also recommend you refer to the Limits Notebook for some more complex examples.

When working with Search, it is quite common for the results to contain hits that are not relevant. Because Search offers powerful filtering expressions, you can eliminate a lot of the hits server-side, thus narrowing down results. In the event the hit count exceeds the limit, despite filtering as much of the result server-side, you can utilize Navigators to logically group requests so you can intelligently break them into buckets. This is a more complex use case but the Notebook I linked to above demonstrates this capability.

Comment
jonathan.legrand

People who like this

1 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 jonathan.legrand · Sep 23, 2021 at 05:46 PM

As per Nick's article, the upper call limit for the rdp search api is 10 000:

This is true for rdp.SearchViews.MunicipalInstruments

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
REFINITIV
jonathan.legrand ♦♦ · Sep 23, 2021 at 05:49 PM 0
Share
Apologies if you cannot see the screenshot, but we are having some temporary technical difficulties. Nonetheless, the limit is 10000.

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

Related Questions

RDP API - Tokens

What would be the best endpoint to use to grab all the RIC, ISIN, SEDOL etc. codes for a universe of US stocks. Ideally using RDP.

Session expiry?

How to interpret Cap volatility surface response

How to receive more data from Quotes responses

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges