[RESOLVED] Data API not returning new records - only shows data from when API was first enabled

Need help Database
1

Hi,

I have a data type called _designer_colours that is enabled for the Data API.

When I first enabled the Data API for this data type, it returned all existing records correctly (100 records). However, any new records I create after that point do not appear in the API response.

For example:

  • I created a new record called “AAA”

  • It appears correctly in the Bubble database

  • But when I call the API endpoint, “AAA” is not in the response

  • The API still returns the same 100 records from when it was first enabled

What I’ve tried:

  • Hard refresh the Bubble editor

  • Edit and re-save the new record

  • Disable and re-enable the data type in API settings

  • Check Privacy Rules (none are set)

  • Delete and recreate the record

API endpoint: https://[my_app].bubbleapps.io/version-test/api/1.1/obj/_designer_colours

Environment: Version-test (development)

Is there a way to force the Data API to refresh and return newly created records?

2

The Data API returns a maximum of 100 items per request. What you need to do is use Bubble’s pagination to retrieve other parts of the list if it contains more than 100 items. To do that, you use the “cursor” parameter.

For example, the first page will have 100 items when using cursor=0, which will return items 0–99. To go to the second page, you will use cursor=100, which will return items 100–200, and so on…

By reading the Bubble documentation, this should become clearer to you:

3

Thank you, but pagination is not the issue here.

The problem is that newly created records do not appear in the API response at all, regardless of pagination.

To clarify:

  • I created a record called “AAA”

  • “AAA” should appear in the first page of results (cursor=0) since it alphabetically comes before “Agate Grey”

  • But it does not appear anywhere in the API response

  • The record exists in my database and I can see it in the Bubble editor

  • Records that existed BEFORE I enabled the Data API appear correctly

  • Records created AFTER enabling the Data API do not appear

This is not a pagination issue - it’s a data synchronization issue where the API is not picking up new records.

When I first enabled the Data API for this data type, it returned all existing records correctly (100 records). However, any new records I create after that point do not appear in the API response.

4

UPDATE: I think I found the issue, the API returns reverse alphabetical order, AAA was last!

1 Like
5

You can set “sort_field” with “descending” to solve this as well. I’m glad you discovered the problem!