# Extending table rows past 1000

**URL:** <https://community.hubspot.com/t/extending-table-rows-past-1000/125869>\
**Category:** Blog, Website & Page Publishing\
**Tags:** enterprise\
**Created:** [February 11, 2025, 5:29pm UTC](https://community.hubspot.com/t/extending-table-rows-past-1000/125869 "2025-02-11T17:29:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![LMcCarthy2](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@LMcCarthy2](https://community.hubspot.com/u/LMcCarthy2)\
**Post date:** [February 11, 2025, 5:29pm UTC](https://community.hubspot.com/t/extending-table-rows-past-1000/125869/1 "2025-02-11T17:29:14Z")

</div>

My orginization used a HubDB for a table on our website. This is a large table of around 1500 rows, so it’s being limited by Hubspots table limit of 1000. What would be the easiest way to extend this limit? So far most of my research involves custom scripting, but it seems like I should be able to edit a module to incorporate this change.

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![evaldas](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/evaldas/32/69160_2.png) [@evaldas](https://community.hubspot.com/u/evaldas)\
**Post date:** [February 11, 2025, 6:45pm UTC](https://community.hubspot.com/t/extending-table-rows-past-1000/125869/2 "2025-02-11T18:45:28Z")

</div>

Hi @LMcCarthy2,

HubDB can actually contain 10,000 rows per table:

> **[HubDB - HubSpot docs](https://developers.hubspot.com/docs/cms/start-building/features/storage/hubdb)**
>
> Build data-driven content with HubDB, HubSpot's native database tool.

If you mean that you already have 1,500 rows in an existing HubDB table and want to display more than 1,000 rows on a web page, then you can add a **limit** in the function query, i.e.:

```lia-code-sample
{% for row in hubdb_table_rows(xxxxxxxxx, 'limit=1500') %}
 {# your code here #}
{% endfor %} 

```

Hope this helps!

---

<div class="post-metadata">

**Author:** ![LMcCarthy2](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@LMcCarthy2](https://community.hubspot.com/u/LMcCarthy2)\
**Post date:** [February 11, 2025, 7:10pm UTC](https://community.hubspot.com/t/extending-table-rows-past-1000/125869/3 "2025-02-11T19:10:19Z")

</div>

Thank you for your response.

Unfortunately, my table is still stuck at the 1000 row limit after implementing that change. Is it possible that i’m being API limited?

---

<div class="post-metadata">

**Author:** ![evaldas](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/evaldas/32/69160_2.png) [@evaldas](https://community.hubspot.com/u/evaldas)\
**Post date:** [February 11, 2025, 7:24pm UTC](https://community.hubspot.com/t/extending-table-rows-past-1000/125869/4 "2025-02-11T19:24:04Z")

</div>

Ar you using the function query in HubL or are you trying to retrieve rows via the API?

Can you share the query you are using?