Rest connector getting data from a sharepoint list with paging (Pagination)
I want to post information on how to load items from a sharepoint list with paging. I have searched for some time how to get the paging working in a sharepoint list and I eventually find it out. So that is why I wanted to share this with the community on how you can do that.
Let me start with describing the issue:
The issue with sharepoint is that as a default it will load only 100 items even when you have more items in the list. You have actualy 2 solutions one being a temporary workaround if you have less than 5000 items and the other a permanent solution with pagination that will work even over 5000 items.
SOLUTION 1 (Less than 5000 items, workaround):
1. You can add in the request url $top=5000 which will grab 5000 items. However when you have more than 5000 items this will NOT work anymore