We are working to implement Connect for Sharepoint but are running into an issue where Sharepoint Online will not return lists that contain more than 5,000 items in it. This causes the Sharepoint REST service to return a 500 Internal Server Error when we exceed the 5,000 limit. Everything works great if we stay under the 5,000 limit.
Has anyone come across this limitation and found a workaround?
I know we could break the list up into multiple lists but that isn't ideal. A recommended workaround I have come across is to implement pagination in the REST call but since Connect is provided by EpiServer, we don't have the ability to make that change in the Add-on.