SharePoint files error: The server cannot process the request due to a high load.

[robertditonno]

Hi All,

I am getting the following error for the Sharepoint Files Input tool:  SharePoint Files Input (19) The server cannot process the request due to a high load.

I am on the most up-to-date designer and the issue is coming from my local machine. Is there any suggestions on what could be done? All I am trying to do is grab the file paths of a particular folder.

Thanks!

[ssjl]

I have this issue from a macro reading SPO file content from 119 files. I just introduced the throttle tool in an attempt to not slam the server.

[niklas_greilinger]

Did you ever find a solution for this? Facing the same issue in 2024.1 with the 2.7.0 Sharepoint Input. Anybody?

[ssjl]

Solution was to use SPO tool to download file locally for later processing then pass the path into a dynamic input tool to read from the local file. In another version I used PowerShell to pull all the files to a network directory in stage 1, and then the usual read multiple files using standard input tool.