function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
dnakonidnakoni 

API limits

Does anyone know the limits of API SOQL calls? I have an aggregate query that, when run inside a VF controller, gives out a Too many query rows (16,125) error. However, the same query ran from SOQLXplorer returns no error and shows me the data.

Best Answer chosen by Admin (Salesforce Developers) 
SuperfellSuperfell

There are no row limits for queries executed by the web services API. Apex has limits on the number of rows you can process in a single request, the type of request dictates the limits.

All Answers

krishnagkrishnag

the query row limit is 10000 for a context.

dnakonidnakoni

But if the limit is 10,000, and i'm getting that limit error in the controller, why am I not getting it through SOQLXplorer, which is using the API? In SOQLXplorer I get all the results back.

SuperfellSuperfell

There are no row limits for queries executed by the web services API. Apex has limits on the number of rows you can process in a single request, the type of request dictates the limits.

This was selected as the best answer
dnakonidnakoni

Perfect, thank you!