I have a list containing around 50,000 records. When I try to use filter in rest api an error is thrown for listview threshold. If I remove the filter from rest api top 100 records are returned. What can be the issue?
Hi Nikhil,
We generally require to see your code to assist. A description leaves a lot out in situations like this.
That being said you could try using the listdata.svc endpoint in batches of 5000 or less. You could build your query to keep calling SharePoint in batches until the data is retrieved and then massage it after you have it. I am not stating it is the best solution, but it is a solution.
Just place the call like this:
http://sharepointsite/_vti_bin/listdata.svc/MyList?$skip=0&$top=5000
then
http://sharepointsite/_vti_bin/listdata.svc/MyList?$skip=5000&$top=5000
http://sharepointsite/_vti_bin/listdata.svc/MyList?$skip=10000&$top=5000
See if that works for you.
