Delete a file in sharepoint using Azure Data Factory Delete Activity

Question

Delete a file in sharepoint using Azure Data Factory Delete Activity

Arghya 1

I am trying to delete a file that is located in a sharepoint directory after successful copy activity. The Delete Activity is having the following properties:

Linked Service : HTTP  
DataSet : Excel  
Additional Header: @{concat('Authorization: Bearer ', activity('GetToken').output.access_token)}   
                                Here, GetToken is the Web Activity in ADF that generates a token number for accessing   
                                SharePoint.

When I am running the pipeline, I am getting the below error:

     Invalid delete activity payload with 'folderPath' that is required and cannot be empty.

I have no clue on how to tackle this.

Answer 1

KranthiPakala-MSFT 35,366 Microsoft Employee

Hello @Arghya ,

Thanks for the question and using MS Q&A platform.

As per my understanding you are trying to delete a file in Sharepoint online using Azure Data Factory. Please correct if I'm not accurate.

Currently delete activity in ADF only supports the below data stores and not sharepoint online. which is why you are receiving the above error.

Ref: Delete activity supported data sources

As a workaround you may try exploring HTTP connector. OR you can use custom activity and write your own code to delete files from SharePoint.

Hope this info helps.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Arghya 1 Reputation point

2022-09-03T01:58:17.657+00:00

Thank you for your answer. I am using HTTP connector as Source in the "Delete" Activity.

Are you suggesting anything different?
KranthiPakala-MSFT 35,366 Reputation points Microsoft Employee

2022-09-05T23:49:52.227+00:00

Hello @Arghya ,

Thanks for your response. As mentioned in my previous response you cannot use HTTP connector in Delete activity. Only above-mentioned data sources are supported by Delete activity.

Have you a chance to try to delete the file from Sharepoint online using POSTMAN? If yes, then you may use the Web Activity with HTTP a connector to do the same. If you aren't able to do it using POSTMAN, then you do not achieve through ADF HTTP connector, and you will have to write your own code/logic and implement it using Custom activity.

Hope this clarifies.
KranthiPakala-MSFT 35,366 Reputation points Microsoft Employee

2022-09-08T08:23:46.13+00:00

Hello @Arghya ,

We still have not heard back from you. Just wanted to check if the above information was helpful? If it answers your query, please do click Accept Answer and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Delete a file in sharepoint using Azure Data Factory Delete Activity

1 answer

Activity