Hi! I am using the Sharepoint List API from Digital Exchange. It works fine, but when i interact with a list that has more than 5000 items it returns with an error message saying it exceeds the limit for sharepoint list view threshold. I have tried using filter to index the search but it wont work. The exact same code works fine with smaller list. I have checked the list and the number of items to be returned should be about 20 rows. I have also tried using top but that only affect the number of items returned, i think the problem is that it wont search through a list of that size regardless of how mana rows its returning.
I had this problem with another list earlier where i switched the order of the filtered items to resolve the issue. (Put test2 before test1) But that didn't work with this one.
All answers will be greatly appreciated!