How to Retrieve the Count of Rows in a Bubble Table via the Data API

Does Bubble provide a dedicated endpoint to retrieve the count of rows in a table?

Not directly. Bubble’s Data API GET endpoint returns count information, but there is no separate built-in “row count only” endpoint.

If you use:

GET https://your-app.bubbleapps.io/api/1.1/obj/<data_type>?cursor=0
Authorization: Bearer YOUR_API_TOKEN

Bubble’s response will include this information:

{
  "response": {
    "cursor": 0,
    "results": [...],
    "count": 100,
    "remaining": 124
  }
}

Here, cursor represents the offset of the current page. So if cursor=0, you are on the first page. If cursor=100, that request starts from row 101 of that request scope.

The formula to get the count of rows

For the total number of rows visible to that API request, the full formula is:

total = cursor + count + remaining

So on the first page with cursor=0:

total = cursor + count + remaining
total = 0 + 100 + 124 = 204

Important: This returns the count of rows for the exact request you made, which is not necessarily the same as the full table. For example, if you added some constraints, the count is naturally associated with that query, not the full table.

So, in conclusion: Bubble’s count is only the number of records returned in that response, not the full table count by itself. remaining tells you how many records are left after that page, and cursor tells you how far into the result set this page starts.

So if you want the total number of rows available for that request, you need to combine all three values.