function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
tssupporttssupport 

Maximum number of items returned in a query call

Hello,

What is the maximum number of items returned in a query call? If the query returns more than that, will I get an exception?

Regards

Daniel

DevAngelDevAngel

Hi tssuport,

There is no maximum.  You can specify a max, but, this does not work for "paging" through data.  Here is the bit from the documentation that defines the behavior.

maxRows An optional parameter that indicates the maximum number of records to return. If �maxRows� is specified, the response is limited to that size. The subset of records returned with the �maxRows� parameter is indeterminate, and may change on subsequent requests with the same query. You should only use the �maxRows� parameter if you want a random sampling of records.

 

I believe that you can set maxRows to -1 to indicate all rows.