Thread Discussion

Started by Gary Wong • Aug 19, 2025 5:17 PM

Total Replies

2

Participants

1

Activity

Quiet

— No recent activity

Duration

5:17 PM

Aug 19

Original Message

Thread starter

G

Gary Wong5:17 PM

Hello! We have a situation where the HubDB v3 api (and v2) "Get Rows for a Table" call is returning a different result every few times we hit it if we include a "sort" parameter.

Here's a video of me refreshing the page and getting a different result every few times:

Example:

https://api.hubapi.com/cms/v3/hubdb/tables/129601963/rows?portalId=1641088&properties=delivery_date_ts&properties=delivery_city&properties=page_title&limit=1&sort=page_title

Notes:

Table has > 6500 rows, about 38 columns
I've recreated the table, and reimported the data a few times. Each new table has this issue.
V2 API has the same behavior
I don't have this issue with my other tables, but they are much smaller.

Any idea what can cause this?

Replies

2 messages in thread

G

Gary WongReply 1Aug 19, 2025 5:38 PM

I did open a ticket with HS support, since this is probably some kind of bug or indexing issue.

G

Gary WongReply 2Aug 19, 2025 5:56 PM

Per HS AI response to my ticket, I've tried more deterministic queries with multiple sorts using different variations, including even row id, but none...