delete using restapi

Question

Hi Team,

am trying to delete date using restapi .. how can i add condition to delete from last modified date

an example

have below mentioneed data on portal

table1

col1 date

test 02/01/2023

and currently using copy command to copy data how can i send delete command to delete it

currently i am using below url but unable to get it

https://stackoverflow.com/questions/55515105/rest-delete-multiple-items-in-the-batch

Answer 1

Hi Vineet S,

Thank you for posting query in Microsoft Q&A Platform.

Actually, your question is little unclear, what is source here and what is Sink here is unclear. Kindly elaborate more with details.

Assuming, you are taking data from some source and loading it in to some SQL table using REST API dataset in Sink tab of Copy activity and you wish to delete some records from that SQL table using REST API call and you have REST API setup handy for that table. Please correct me if I am wrong with more details on query.

If my understanding, is correct then kindly consider using web activity after copy activity. In the web activity make API call to delete rows.

Hope this helps. Please let me know if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.