Pagination n8n help

@David8012 : what exactly would you like to know about the pagination?

There are 2 options:

  1. 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

  1. 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