# API (Get Rows) - Max number of rows?

**URL:** <https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546>\
**Category:** Ask for Help\
**Created:** [November 1, 2024, 9:32am UTC](https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546 "2024-11-01T09:32:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\
**Post date:** [November 1, 2024, 9:32am UTC](https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546/1 "2024-11-01T09:32:00Z")

</div>

Hi

Im using API (Get Rows) to get a Big Table, but im only getting the first 10.000 rows.  
Is this a limit from Glide?

---

<div class="post-metadata">

**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\
**Post date:** [November 1, 2024, 9:40am UTC](https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546/2 "2024-11-01T09:40:52Z")

</div>

Ah sorry, found is in documentation: [Using Glide API | Glide Docs](https://www.glideapps.com/docs/using-glide-tables-api)

---

<div class="post-metadata">

**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\
**Post date:** [November 1, 2024, 9:43am UTC](https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546/3 "2024-11-01T09:43:48Z")

</div>

Is there a function to “startAt”: lastrow-5000?

---

<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:** [November 1, 2024, 9:53am UTC](https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546/4 "2024-11-01T09:53:10Z")

</div>

As far as I’m aware, that’s not supported with the Big Table query API. I think you’d probably have to figure out a way to filter the results, perhaps based on a date range?

---

<div class="post-metadata">

**Author:** ![Danny\_Nielsen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danny_nielsen/32/61765_2.png) [@Danny\_Nielsen](https://community.glideapps.com/u/Danny_Nielsen)\
**Post date:** [November 1, 2024, 10:11am UTC](https://community.glideapps.com/t/api-get-rows-max-number-of-rows/77546/5 "2024-11-01T10:11:27Z")

</div>

Ok. For now, i’ll just follow the guide and add another query with “startAt”: CONTINUATION.

Later i can change et to two query’s, first one to get lastrow and then the accual query.