Airtable Node Record Limit Reduced to 100 – Any Workarounds?

[roarav_27]

I'm using the Airtable node in n8n to search records, and I noticed that the Limit field doesn't allow me to set a value higher than 100. Previously, I could set it to 600 without any issues. Has there been a change in the Airtable integration or any updates to the node that enforce this new limit? If so, is there a workaround to retrieve more than 100 records in a single query? Any guidance would be appreciated!

[ScottWorld]

@roarav_27 

I would ask the N8N people about that.

In the meantime, for complex automations, you can use Make’s advanced automations and integrations, which doesn’t have any record limits at all for searching records.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

For extremely simple automations, you can also use Airtable’s built- in automations. Airtable’s anutomations are much more basic & much more limited than Make, but if your automation needs are simple enough, Airtable lets you find up to 1000 records.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[kuovonne]

The number of records you get from the Web API is determined by two different numbers: pageSize and maxRecords. The pageSize determines how many records you can get in a single call. The maximum pageSize is 100, so you will never get more than 100 records in a single call. You can set maxRecords to a larger number, but if this number is over 100, you will need to use multiple calls asking for subsequent pages of data in order to get all of the records.

[ScottWorld]

Make solves this API limitation natively, without any extra work on the user's end.

Make allows you to specify any record number that you want (up to Airtable's maximum record limit of 500,000 records per base), and Make will automatically paginate the records for the user... without the user even knowing that any pagination was taking place!

- ScottWorld, Expert Airtable Consultant