How many maximum items can get using SPServices-Lists-GetListItems

Jul 15, 2014 at 11:33 AM
Hello Team.

My list is having 52000 Items in list and I am getting only 10000 Items when call GetListItems. Please help me how to retrieve all items in one call.
Jul 15, 2014 at 6:11 PM
I'm guessing you're using the "GetListItems" call? With that, you can set the "CAMLRowLimit" argument to 0 to override the chosen view's item limit setting. Setting the CAMLRowLimit to 0 instructs the server to return all items, regardless of the view's item limit.
Jul 16, 2014 at 12:22 AM
So even though it's possible (as long as you don't hit thresholds), if you have the need to pull all 52 THOUSAND rows client side, you are doing it wrong. I suggest you re-assess what problem you are trying to address and rethink your approach.

--
Paul T.

-- Sent from Mobile