Forum Discussion
Error when trying to create folder in SharePoint Online using SSIS KingswaySoft
Hi,
I wanted to migrate MS CRM Attachments to SharePoint Online.
So for that I am creating CRM records folder inside SharePoint Document Library using SSIS KingswaySoft.
But I am getting below error message when trying to create a folder:
"KingswaySoft.IntegrationToolkit.SharePoint.REST.OdataServiceException:
The remote server returned an error: (500) Internal Server Error. (Error Type / Reason: InternalServerError, Detailed Message: {
"error": {
"code": "-2147024860, Microsoft.SharePoint.SPQueryThrottledException",
"message": "The attempted operation is prohibited because it exceeds the list view threshold."
}
})"
It seems the issue is related to the “list view threshold limit in SharePoint”. As my SharePoint Document Library already exceeds the list view threshold limit, which is 5000 items:
So can you please guide us if possible on how to handle the above issue from SSIS? OR is there any configuration needed on SharePoint side.
FYI, I am able to create folder in the above SharePoint Document Library via "Manually" and "Power Automate".
Any help will be appreciated!
Thanks