Forum Discussion

Dustin985's avatar
Dustin985
Copper Contributor
Mar 07, 2023

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

 

No RepliesBe the first to reply

Resources