@David8012 : what exactly would you like to know about the pagination?
There are 2 options:
- Using the Baserow Get Many node and switching the Return all button on. This avoids the pagination issue and returns all records over all pages
- Use an HTTP node an make a call directly to the Baserow API. This is a bit more complex. The call returns an object that will always have 4 properties
count
: the total amount of records
next
: the url to the next set of results. This is null is there is no next set of results
previous
: the url to the previous set of results. This is always null on the first page
results
: an array with the actual results.
If you want to implement this in n8n, you need to create a loop.
- Step 1: Make an API call without page
- Step 2: store the results in a global variable
- Step 3: check if the next property has a value
- Step 3.1: if yes, make a new API call with the url of the next property (and go back to Step 1)
- Step 3.2: if no: we are ready, the results are in the global variable