Delete the file from SharePoint location

ADF_Coder 0

Hi All,

I am trying to copy the files from Share Point to ADLS and referring to the below URL pipeline to achieve the copy functionality.

https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-factory/

I need help to know how I can delete the file after the files get copied in ADF itself (not power automate). It will be helpful If you can explain with flow.

Smaran Thoomu 12,100 Reputation points Microsoft Vendor

2024-05-24T04:00:47.8766667+00:00

@ADF_Coder Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
ADF_Coder 0 Reputation points

2024-05-24T04:08:32.3033333+00:00

checking will let you know.

1 answer

Amira Bedhiafi 18,501 Reputation points

2024-05-22T20:46:11.4833333+00:00
You can use a copy activity :

Set up your SharePoint source. You'll need to configure the linked service for SharePoint, which requires the URL of the SharePoint site and authentication details.

Specify the files or folder to be copied.

Then, configure the sink like below :

Set up your Azure Data Lake Storage destination. Configure the linked service for ADLS.

Specify the container and folder in ADLS where the files should be copied.

Next step, you need to set up the web activity to delete the file :

URL: Set the URL to delete the file from SharePoint. This URL will be specific to your SharePoint instance and the file to be deleted.

Method: Set the HTTP method to DELETE.

Headers: Add any necessary headers for authentication and content type.

Body: Add any required body content, if applicable. Usually, for a DELETE request, the body is not needed.

Authentication: Set up authentication. If SharePoint uses OAuth, you will need to configure an OAuth token.

Finally you may need to create a dependency between the Copy Data activity and the Web activity.
Please sign in to rate this answer.
ADF_Coder 0 Reputation points

2024-05-27T17:05:23.9833333+00:00

@Amira Bedhiafi ,

Its not working.

Smaran Thoomu 12,100 Reputation points Microsoft Vendor

2024-05-28T05:11:36.0366667+00:00

@ADF_Coder Could you please provide an update on what you have tried so far and the specific error message you are encountering? This will help me provide more effective assistance.

ADF_Coder 0 Reputation points

2024-05-28T11:20:43.96+00:00

@Amira Bedhiafi , @Smaran Thoomu ,

facing below issue

{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The type SP.FileCollection does not support HTTP DELETE method."}}}

Also got below error when used in for loop

The HTTP DELETE method cannot be used for media resource. The media resource could only be accessed by HTTP GET or updated by HTTP PUT.

URL - https://{siteurl}/path/path/_api/web/GetFileByServerRelativeUrl('@{item().ServerRelativeUrl}')/$value

Smaran Thoomu 12,100 Reputation points Microsoft Vendor

2024-05-28T16:08:30.2433333+00:00

@ADF_Coder As per the error message indicates that the type SP.FileCollection does not support the HTTP DELETE method. Additionally, you received an error when using the HTTP DELETE method in a for loop, which suggests that the media resource can only be accessed by HTTP GET or updated by HTTP PUT.

I think you may need to modify your approach to deleting the file. One possible solution is to use the SharePoint REST API to delete the file instead of the HTTP DELETE method. You can use the SharePoint REST API to delete the file by sending a DELETE request to the file's REST endpoint. Here's an example URL that you can use to delete a file from SharePoint: https://{siteurl}/_api/web/GetFileByServerRelativeUrl('{fileUrl}')

Replace {siteurl} with the URL of your SharePoint site and {fileUrl} with the server-relative URL of the file that you want to delete.

Please refer the documentation on how to delete a file using the SharePoint REST API

I hope this helps. Please let me know if you have any questions.

ADF_Coder 0 Reputation points

2024-05-28T16:49:14.18+00:00

Hi @Smaran Thoomu ,

Thank you for your reply. Actually I wanted to delete all the files from the specified sharepoint folder.

I am using web activity

with URL - https://{siteurl}/_api/web/GetFolderByServerRelativeUrl('/folder')/files

Method - DELETE

Authorization and Accept.

But facing below error.

{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The type SP.FileCollection does not support HTTP DELETE method."}}}

Can you help here? Please explain with example

Smaran Thoomu 12,100 Reputation points Microsoft Vendor

2024-05-30T06:33:50.7+00:00

ADF_Coder I agree that this issue looks strange, and I wasn't able to reproduce this issue. If you have a support plan, could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan, please let us know here.

ADF_Coder 0 Reputation points

2024-05-30T06:38:40.1+00:00

Hi @Smaran Thoomu ,

I don't have a support plan. I also just wanted to know that HTTP DELETE is used to delete files from Share Point, right?
Sign in to comment

Share via

Delete the file from SharePoint location

1 answer