1

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 'myemail@domain.com'&$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. – Bhaskar Dhone Sep 6 '18 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. – vinit kumar Sep 6 '18 at 16:41
0

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, privacy policy and cookie policy

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