How to retrieve only the two most recently created rows from a Baserow table in Make, without fetching the entire dataset.

Technical Help
, ,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What are the exact steps to reproduce this issue?

Hi everyone,
I’m working with Make.com and Baserow, and I want to fetch only the last two created rows from a specific table.

Using the standard “List Rows” module in Make, it always returns the oldest rows first, and there’s no option to change the sorting order.
The only workaround I see is setting limit=1000 and manually filtering the latest entries afterward, which is inefficient as the data grows.
I’m using a custom webhook trigger in Make, which is fired when a new row is created in Baserow.
So in Make I already receive the newly created row – but I also need to fetch the previous row (i.e. the one created right before), to increment a custom invoice number.

Is there a reliable and efficient way to retrieve only the most recently created rows, directly, without loading the full dataset?

Thanks in advance!
Best regards

2

Hi @upclh welcome to the community! Yes this is possible by creating a “Created on” field and then using 3 parameters in your api request, specifically:

order_by, size and user_field_names

Your request would look something like this

https://api.baserow.io/api/database/rows/table/{{tableid}}/?user_field_names=true&size=2&order_by=-Created on

Note the - before the Created on value in the order_by parameter - this ensures it is sorting it in descending order not ascending. The size parameter is what you should use instead of limit and the user_field_names just let’s you use Created on instead of using the field_id value.