search

vgrem / Office365-REST-Python-Client

Microsoft 365 & Microsoft Graph Library for Python
MIT License
1.34k stars 336 forks source link

Error on query large lists with calmquery #427

Open nchasomeri opened 3 years ago

nchasomeri commented 3 years ago

I'm trying to update a SharePoint list on our site by using calm_query for finding the rows to update but I am getting the error "office365.runtime.client_request_exception.ClientRequestException: ('-2147467259, Microsoft.SharePoint.SPException', 'Cannot complete this action.\n\nPlease try again.', "500 Server Error: Internal Server Error for url: https:///sites/ipm/_api/Web/lists/GetByTitle(listname)/GetItems") "

My code is similar with this example https://github.com/vgrem/Office365-REST-Python-Client/blob/master/examples/sharepoint/lists_and_items/read_list_via_query.py

and the error raised on items = target_list.get_items(list_qry).execute_query()

My list on SharePoint is large enough (~ 56000 rows) and in query i use the rowlimit option.

Can someone help me with this? Thank you

mekhlakapoor commented 1 year ago

Was this resolved? I'm currently having the same issue