# Multiple Delete Rows in BT

**URL:** <https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555>\
**Category:** Ask for Help\
**Tags:** multiple-rows, big-tables\
**Created:** [September 27, 2023, 3:14am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555 "2023-09-27T03:14:46Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\
**Post date:** [September 27, 2023, 3:14am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/1 "2023-09-27T03:14:46Z")

</div>

Hi Gliders!

I’m stuck with trouble how to delete multimultiple Rows in BT. It’s terrible to do it one by one with huge quantity of updates 😱  
Are there workarounds maybe?

My use case is storing bar-codes to a row, having ~500 rows a day. I need it for a couple weeks for history and reporting. Then i need to rollout this set into one row per day to pack \ compress rows for decreasing quantity of rows. Because do not need such detail history after a couple weeks. But both kind of rows (detailed and packed) i need for reporting & diagrams.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 27, 2023, 3:16am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/2 "2023-09-27T03:16:14Z")

</div>

Use the API. You can delete rows in batches of up to 500 with a single API call.

---

<div class="post-metadata">

**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\
**Post date:** [September 27, 2023, 6:30am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/3 "2023-09-27T06:30:11Z")

</div>

@Darren_Murphy Thank you 🙏  
Could you explain please or give a link to - how to do it with batches of row just by single API call?  
Would it cost 500 updates if the batch is 500 rows?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 27, 2023, 7:21am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/4 "2023-09-27T07:21:55Z")

</div>

The [documentation](https://www.glideapps.com/docs/essentials/data-sources/getting-started-with-the-glide-api/using-glide-tables-api#delete-rows) shows you how to do it. Just create a separate mutation for each row to be deleted, and send them all in a single call as a collection.

Example:

```auto
{
  "appID": "APP-ID",
  "mutations": [
    {
      "kind": "delete-row",
      "tableName": "native-table-xxxxx",
      "rowID": "ROW-ID"
    },
    {
      "kind": "delete-row",
      "tableName": "native-table-xxxxx",
      "rowID": "ROW-ID"
    }
  ]
}

```

Each row deleted is one update, the same as it would be if you used a delete row action.

---

<div class="post-metadata">

**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\
**Post date:** [September 27, 2023, 8:42am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/5 "2023-09-27T08:42:12Z")

</div>

Thank you very much, Darren! 🙏  
Am going to do.  
Regret about huge quantity of updates in this solution 😱  
instead of just one update in case of Delete row by Multi-Relation…

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 27, 2023, 8:58am UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/6 "2023-09-27T08:58:19Z")

</div>

Deleting rows through a multi-relation still counts one update for each deleted row - so it’s the same either way.

---

<div class="post-metadata">

**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\
**Post date:** [September 27, 2023, 6:59pm UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/7 "2023-09-27T18:59:41Z")

</div>

Oh, i did’nt know that, thank you 🙏

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 4, 2023, 7:00pm UTC](https://community.glideapps.com/t/multiple-delete-rows-in-bt/66555/8 "2023-10-04T19:00:25Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.