You need to sign in to do that
Don't have an account?
dnakoni
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.
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
the query row limit is 10000 for a context.
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.
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.
Perfect, thank you!