# Deleting multiple rows in a certain table with Zapier

**URL:** <https://community.glideapps.com/t/deleting-multiple-rows-in-a-certain-table-with-zapier/57430>\
**Category:** Ask for Help\
**Created:** [February 2, 2023, 9:51pm UTC](https://community.glideapps.com/t/deleting-multiple-rows-in-a-certain-table-with-zapier/57430 "2023-02-02T21:51:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![FV.io](https://avatars.discourse-cdn.com/v4/letter/f/49beb7/32.png) [@FV.io](https://community.glideapps.com/u/FV.io)\
**Post date:** [February 2, 2023, 9:51pm UTC](https://community.glideapps.com/t/deleting-multiple-rows-in-a-certain-table-with-zapier/57430/1 "2023-02-02T21:51:41Z")

</div>

Hi Community!

I’ve been dealing with a automation for a few days now, without any luck…

I want Zapier to import data from glide, to Zapier, one day each month.  
Then I want Zapier to delete all rows in a certain table in my app.

As i understand, I’ll have to use the pre-made json script, fra Glide API, to complete this task.

The problem is that the standard script provided by Glide, only allow Zapier to delete one row at a time, because it only contain one mutation.

I want to duplicate the mutation, based on the current amount of rows in the table.  
Each mutation need to contain the row ID, I imported from Glide when the automation was triggered.

Can anyone help me out?  
Please check attached pictures, for more info:

 ![Skærmbillede 2023-02-02 kl. 22.23.59](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2df67a438c99898ac4682bea824c57d57571cea9.jpeg)  
 ![Skærmbillede 2023-02-02 kl. 22.24.49](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6bdf2b5ed21f8e3b7d62e257eeb376bbb18c6cb.jpeg)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 3, 2023, 12:07am UTC](https://community.glideapps.com/t/deleting-multiple-rows-in-a-certain-table-with-zapier/57430/3 "2023-02-03T00:07:53Z")

</div>

I don’t know if there’s an equivalent in Zapier, but here’s what I usually do in Make.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c83b81b2db4b8951461de3cf2429e9c607d0c8f5.png)

- Pass the list of rowIDs to delete via a webhook.

- Iterate through that list of IDs.

- For each ID, I use a text aggregator to construct the delete “action” for it and group them together by batches of 100.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78a95b6a6dd6e2ee68d39c56acd0a72045d463ea.jpeg)

- Use the HTTP module to make a call and delete multiples rows at once, in batches of 100.

 ![Hartic - Delete Order x Precincts Make 2023-02-03 at 7.07.17 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/359bd1be2169387d1e7876207d4dd8e3a5c74c89.jpeg)

---

<div class="post-metadata">

**Author:** ![FV.io](https://avatars.discourse-cdn.com/v4/letter/f/49beb7/32.png) [@FV.io](https://community.glideapps.com/u/FV.io)\
**Post date:** [February 3, 2023, 12:14am UTC](https://community.glideapps.com/t/deleting-multiple-rows-in-a-certain-table-with-zapier/57430/4 "2023-02-03T00:14:09Z")

</div>

Thanks a lot!

I’ll try that

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [February 3, 2023, 8:16am UTC](https://community.glideapps.com/t/deleting-multiple-rows-in-a-certain-table-with-zapier/57430/5 "2023-02-03T08:16:16Z")

</div>

You will have to use the loop feature from Zapier.