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@example.com'&$top=5000
Even though the expected item count is less only hundreds, i am getting the following error.
How do I overcome this?
Thanks in advance. Divakar