How to delete entries from Azure Table Storage using ADF

Arundhati Sen 151

I am trying to delete entries from Azure Table Storage using ADF

I got this article (https://video2.skills-academy.com/en-us/rest/api/storageservices/delete-entity1) which says we can use a HTTP DELETE request, but I am not sure about the headers I have to pass, can someone show me with a practical working example.

Suppose we have a Table named ETLADSPlanD under storage eundnavadfsta01

User's image

URL will be :

https://eundnavadfsta01.table.core.windows.net/ETLADSPlanD(PartitionKey='PlanD-Workflow1', RowKey='workflow1')

and how to construct the headers to make it work from ADF?

Is there any way we can delete all the entries that is older than timestamp 1 month using HTTP request from ADF?

HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2023-05-09T21:25:11.06+00:00

Hello @Arundhati Sen ,

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

Not sure if you have already gone through the thread here This is a use case for postman , but this should be easy to convert to ADF implementation.

In a table storage for all the operation you will have to pass the partition key and row key , so I do not think you can implment the timestamp logic they way we do in SQL .

Thanks

Himanshu

Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.
Arundhati Sen 151 Reputation points

2023-05-10T11:36:27.6766667+00:00

Hi @HimanshuSinha-msft

I tried the postman solution (https://raaviblog.com/azure-table-storage-service-rest-api-operations-using-postman/) still it is not working from ADF.

Can you please create a small example and show.

Use case: How from ADF we can delete entry from Table Storage using REST API

ADF solution I tried:

From ADF I am sending the URL (

https://eundnavadfsta01.table.core.windows.net/ETLADSPlanD(PartitionKey='a', RowKey='b')?sv=2022-11-02&ss=t&srt=sco&sp=rwdlacu&se=2026-05-10T19:18:45Z&st=2023-05-10T11:18:45Z&spr=https&sig=XXX

) but getting below error :

"Response": "<?xml version="1.0" encoding="utf-8"?><error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>AtomFormatNotSupported</code><message xml:lang="en-US">Atom format is not supported.\nRequestId:803a33e9-3002-00ec-6a32-833eaf000000\nTime:2023-05-10T11:28:54.7865589Z</message></error>",

Share via

How to delete entries from Azure Table Storage using ADF

Your answer