Unanswered

HTTP Request to Delete Sharepoint file

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

mhemphill-wiley 48 on at

Like (10)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Thanks!

I needed this 🙂

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

Like (2)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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