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 '[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

Improve this question
2
  • 1
    UserEmail field needs to be indexed.
    – Bhaskar Dhone
    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.
    – vinit kumar
    Sep 6, 2018 at 16:41

1 Answer 1

Reset to default
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

Improve this answer

Your Answer

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

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