I have a list having approx 10000 items, I am trying to retrieve items filtering by 'UserEmail' column, using REST api.

http://SpServer:1122/sites/Large-List-PORTAL/_api/web/lists/getbytitle('MyList')/items?$select=ID,Title,Category,UserEmail,ProductName&$filter=UserEmail eq '[email protected]'&$top=5000

Even though the expected item count is less only hundreds, i am getting the following error.

Error Image

How do I overcome this?

Thanks in advance. Divakar

  • 1
    UserEmail field needs to be indexed. Sep 6, 2018 at 13:38
  • As bhasker mentioned UserEmail columns need to be indexed. Increasing List view threshold at Web application may be not suggested by sharepoint admin. Sep 6, 2018 at 16:41

1 Answer 1


To solve this you just have to increase the list vie threshold value.

Open Central Administration. Go to Application Management > Manage Web Application and select your web application In the Ribbon, click on General Settings drop-down and choose “Resource Throttling”. In the “List View Threshold”, increase the value Try to replicate the error: If it persists, increase the value again Hope this helps !

Reference here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.