Sharepoint activity - 401-Unauthorized error when trying to upload file to Sharepoint

[Vijay_chandran]

Hi,
I’m trying to use the “Upload file” activity in UiPathTeam.SharePoint.Activities package 1.3 version. The credentials I have given is correct and I’m able to upload a file manually to the sharepoint. But using the “Upload file” activity, unauthorized error is thrown. Could you please check whether the format of Item URL or Local path is fine? I tried multiple combinations of the Item URL, but getting same error.

Error: RemoteException wrapping System.Net.WebException: The remote server returned an error: (401) Unauthorized.

Item URL: “Documents\RPA\New\Sample.xlsx”
Local Path: “C:\Users\vijayakumar.chandran\Desktop\Sample.xlsx”

[Luis261980 (Luis Nunes)]

Hi @ Vijay_chandran,

see this post will help you

SharePoint Upload File Error: (401) Unauthorized

@HareeshMR it was a simple mistake (isn’t it always?? ); the Item URL was missing the Library Name at the beginning of the path. Once I fixed that, I was able to upload a file. At least the post could be useful for anyone encountering this error message.

[Vijay_chandran]

Thanks for the reply @Luis261980. I have gone through this post. In the Item URL I have mentioned the sharepoint library name at the beginning but still facing the same error.
Note: I have used “Create Folder” activity in Sharepoint scope and that is working fine, so the credentials used to connect are correct.

[Vijay_chandran]

@radu_bucur - FYI please.

[Luis261980 (Luis Nunes)]

Try full path on ITEM URL

[Vijay_chandran]

Hi @Luis261980 - I have tried below paths in ITEM URL, getting same unauthorized 401 error for all. But using Create Folder activity, I’m able to create folder in the same sharepoint path.

ITEM URL tried:
“/Documents/RPA/Sample.xlsx”
“Documents/RPA/Sample.xlsx”
“Documents/RPA”
“C&H-Work Meeting Prep/Documents/RPA/Sample.xlsx”
“/C&H-Work Meeting Prep/Documents/RPA/Sample.xlsx”
“Sign in to your account”
“Sign in to your account”
“Sign in to your account”

[Luis261980 (Luis Nunes)]

Wait i will call the cavalery

@aksh1yadav

@ClaytonM

@lakshman

@loginerror

@ sudhasagar

@ Palaniyappan

any help here please, tnhx

[radu_bucur]

Try “/Shared Documents/RPA/” it might work.

If you say Create Folder is working fine and that you indeed have permissions to upload files, this should work too. If it doesn’t, please go through the questions below
Are you trying to overwrite a new file or to upload a new one?
If you want to overwrite, are u sure the file is not checked out or that someone is editing it?
Could you possibly share the code with us? (minus the credentials) This way we could see if there indeed is a problem.

[Vijay_chandran]

Thanks Radu. The file gets uploaded to the sharepoint by using “/Shared Documents/RPA/” Note: I was getting a different error (File not found) even after successful upload with above mentioned URL. Then I changed the Item URL to “/Shared Documents/RPA/Sample.xlsx”, after which I’m not getting error.
Thanks lot for your help.

[radu_bucur]

No problem, its something that’s specified in the documentation of the package. SharePoint has certain exceptions like that (SharePoint be crazy). Glad it worked out!