jasonrollins / shareplum

Pythonic SharePoint
MIT License
179 stars 96 forks source link

500 Server Error for fetch sharepoint list larger than 5000 items #106

Closed coolzoom closed 4 years ago

coolzoom commented 4 years ago

I can get list item for sharepoint list below 5000 using GetListItems, row_limit is not necessary for these. data = sp_list.GetListItems('All Items', row_limit = 200) sp_data = sp_list.GetListItems(fields=fields, query=query, row_limit = 200)

However if i want to fetch items from Lists over 5000 items, it will always return 500 Server error. also i tried to add row_limit doesnt help.

error below: Shareplum HTTP Post Failed : 500 Server Error: Internal Server Error for url: https://xxx.sharepoint.com/sites/engineer//_vti_bin/lists.asmx

few more things, I know that Sharepoint online only support for 5000 items view, but it can store way more data than that. i think if we just using query or getitem function for items below 5000 it would be fine. https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-list-view-threshold-is-5000/660adfa9-9faf-48c7-bfbb-3cf50742fbfa

another discussion https://office365.uservoice.com/forums/273493-office-365-admin/suggestions/33081415-sharepoint-document-library-limit-of-5000-ridicu

coolzoom commented 4 years ago

found the answer and have to live with it. im going to close this issue for now. https://github.com/jasonrollins/shareplum/issues/63