Unanswered

HTTP Request to Delete Sharepoint file

(0) Share

Report

Posted on by Community Power Pla...

Howdy!

I am trying to delete a specific file on Sharepoint using the "Send HTTP Request" in order to force delete a file that is checked out or locked. I found a method at this link but I am unable to get it to work (error message below). I even went down through the comments to try the DELETE method and still was not successful.

I also found a similar thread on this forum, but it looks like the OP never responded back.

Error Message: The expression "web/GetFileByServerRelativeUrl(‘/sites/TexasRegion/Shared Documents/General/General/Projects/AXONOpenOrders.CSV’)" is not valid.
clientRequestId: aca349fc-7dca-4816-8f43-9843a19fcc20
serviceRequestId: 24b820a0-4084-c000-bd5a-350d5e055e85

Current flow:

Any help would be more than appreciated, thanks!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

mhemphill-wiley 48 on at

Like (10)

Report

This took me FOREVER to figure out but here it is!

The URI is: _api/web/GetFolderByServerRelativeUrl('Folder Name')/Files('DisplayName'). No slash before the Folder Name, and use the Display Name instead of Name (which includes the folder name for some reason). The "bypass-shared-lock" is to get around if the file is locked or checked out, I think. Note that this permanently deletes the file, it won't be in the Recycle bin.

Was this reply helpful? Yes No
efeewfew 302 on at

Like (1)

Report

Thanks!

I needed this 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (2)

Report

I was with a similar problem, but I was dealing with subfolders, then I wrote the following, using dynamic fields

Writing here the Uri expression:
_api/web/GetFolderByServerRelativeUrl('@{triggerOutputs()?['body/{Path}']}')/Files('@{triggerOutputs()?['body/{FilenameWithExtension}']}')

Don't forget the single quotes, even when using dynamic fields!!

Thank you for useful discussion

Was this reply helpful? Yes No
jerome18 24 on at

Like (1)

Report

Thanks @mhemphill-wiley and @Anonymous, I needed to receive the filename from an email to delete a specific file and you showed me how to do it. As you can see, i only did a concat to specify the required file path and filename from compose actions : concat('/',outputs('repertoire'),'/',outputs('fichier'))

Many thanks to both of you

Was this reply helpful? Yes No