Extending table rows past 1000

Marketing & Content Hub Blog, Website & Page Publishing
1

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!

2

Hi @LMcCarthy2,

HubDB can actually contain 10,000 rows per table:

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.:

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

Hope this helps!

3

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?

4

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?