Forum Academy Marketplace Showcase Pricing Features

Data API URL only pulling 100 rows

Hello,

I’m able to pull only 100 rows from my data api url. How do I get more than 100 rows?

Thanks,
George

Hi George,

Simply loop on it (pagination).

Hi John,

I’m currently on the professional plan already. What plan is needed?

Thanks,
George

This is covered in the reference. It’s called pagination.

1 Like

You should change this. No one understands it.

Azure literally has a switch - pagination on or off. If on then everything is automatically handled. No cursors or other nonsense.

Azure also fetches 1000 items before pagination is required - not 100. 100 is way too small a number.

Finally you can also set a limit on the number of number of records to be retrieved- e.g. stop pagination after 10,000 items, or 5,000. Etc.

You should consider making your pagination this easy.

3 Likes

I second this!

1 Like

Hi @emmanuel,

Is it possible for Bubble to implement something similar to what @scriptschool describes above? More rows

Thanks,
George

Not this second, but we’ll look into where it fits in the roadmap. I can’t give a timeline now though.

2 Likes

:unamused: Sure is a greatly limiting factor.

Thanks,
George

Hi, as follow up I am for the first time using an API endpoint/wf to ‘return data from API’.

I am getting only 50 rows now from these API calls when i know there are more on this search.

Is the ‘return data from API’ limited to 50?

Update: After checking the manual… yes, the limit is 50.

Guys - 50 is such a small number. Please, change this.

These are the keys and data types of the parameters that are returned. When the name and type of data are set, define the data you want to return. In the case of the Workflow API, we limit the size of lists to 50 entries. For a full list of data, please use the Data API that handles pagination.

1 Like

Hi Emannuel,

Almost a year later and we’ve also hit a roadblock with the pagination. Would be extreme useful to disable pagination for apps on a certain plan.

Thanks,

Mido

1 Like

Hi @emmanuel,
Is there any update regarding this? It’s a huge roadblock for some of us.

Thanks,
George

Yes, we managed to solve this with custom code. Which API are you using? Feel free to message me.