# API add row limit

**URL:** https://community.glideapps.com/t/api-add-row-limit/65109
**Category:** Ask for Help
**Created:** [August 17, 2023, 2:23am UTC](https://community.glideapps.com/t/api-add-row-limit/65109 "2023-08-17T02:23:23Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [August 17, 2023, 2:23am UTC](https://community.glideapps.com/t/api-add-row-limit/65109/1 "2023-08-17T02:23:23Z")

</div>

Is there a limit on how many rows or the request size of the API you can insert into Glide app.

We just had an instance where we tried to add in 30 rows, but only 13 were added. We got no errors.

We then started to add the missing rows again single and then bulk of 5 and all went through with no errors.

---

<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: [August 17, 2023, 2:32am UTC](https://community.glideapps.com/t/api-add-row-limit/65109/2 "2023-08-17T02:32:00Z")

</div>

The hard limit on the number of mutations that can be sent in a single call is 500, although its recommended to send batch sizes of no more than 100.

30 should be no problem at all, although sometimes there can be a slight delay before all rows show up.

Are these being added to a Big Table, or Regular Glide Table?  
If a Big Table, you usually have to reload the table before you see any new rows that have been added via the API.

---

<div class="post-metadata">

### Author: ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [August 17, 2023, 6:15pm UTC](https://community.glideapps.com/t/api-add-row-limit/65109/3 "2023-08-17T18:15:33Z")

</div>

Hi Darren,

What is a mutation, is that a row. Does it matter how many columns in a row, does the affect the limit.

We spotted the issue after 3 hours. This is regular Glide Table. When we were testing in blocks of 5’s the updates were reflected within 5 seconds.

Also there was no pattern to what was accepted and what was missed. It was not that the first 13 were added, the ones added were non-sequential

---

<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: [August 18, 2023, 12:54am UTC](https://community.glideapps.com/t/api-add-row-limit/65109/4 "2023-08-18T00:54:49Z")

</div>

> [@Dan\_San](#):
>
> What is a mutation, is that a row

A mutation refers to any of the add, edit, delete actions.

> [@Dan\_San](#):
>
> Does it matter how many columns in a row, does the affect the limit.

I don’t believe there should be a limit related to that.

> [@Dan\_San](#):
>
> It was not that the first 13 were added, the ones added were non-sequential

Yes, it’s always the case that the adds are not sequential.

---

<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: [August 18, 2023, 2:26am UTC](https://community.glideapps.com/t/api-add-row-limit/65109/5 "2023-08-18T02:26:47Z")

</div>

> [@Dan\_San](#):
>
> What is a mutation,

Explained in the docs:

> **[Using Glide Tables API](https://www.glideapps.com/docs/essentials/data-sources/getting-started-with-the-glide-api/using-glide-tables-api#mutations)**
>
> Explore what you can do with the Glide Tables API

 ![CleanShot 2023-08-18 at 10.25.40@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b555e6035f0aee0b841a941c0615c7d66486136a.jpeg)

---

<div class="post-metadata">

### Author: ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [August 18, 2023, 4:39am UTC](https://community.glideapps.com/t/api-add-row-limit/65109/6 "2023-08-18T04:39:00Z")

</div>

Thanks.

That means we tried to do 30 mutations in a single JSON and the document says it can support up to 500.

It is also claiming that the response should be an array of results, one for each mutation, I am not sure we are getting that, I will double check and wait for it to happen again.

---

<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: [August 18, 2023, 5:40am UTC](https://community.glideapps.com/t/api-add-row-limit/65109/7 "2023-08-18T05:40:04Z")

</div>

> [@Dan\_San](#):
>
> It is also claiming that the response should be an array of results, one for each mutation, I am not sure we are getting that, I will double check and wait for it to happen again.

Yes, that’s correct. If you’re adding rows, the response will include an array of RowIDs.  
Although the rows are not guaranteed to be added in sequence, the array of RowIDs will be in sequence. That is, the first RowID in the array will correspond to the first mutation, and so on.

---

<div class="post-metadata">

### Author: ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)
#### Post date: [August 18, 2023, 3:23pm UTC](https://community.glideapps.com/t/api-add-row-limit/65109/8 "2023-08-18T15:23:26Z")

</div>

Thanks guys, the documentation and your input was good.

We managed to hunt down the issue, we had done something silly, one of the mutations caused a failure, we were not looking in the right place. Will update code, test and push live and see if it happens again.

As always… thanks for assistance, support and brainstorm
