Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Retrieve all data from table without any filters

Topic Labels: API
Solved
Jump to Solution
541 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I am trying to retrieve all records from a table. The master view has filters on it that have to stay there for other business users, but I would like to retrieve all records without the filters with the API. More specifically, the table is filtered to records added in the last week, but I need all of the records from the beginning of the table.

Is there a way to use the API to get all records even if the table in the browser has filters on it?

1 Solution

Accepted Solutions

Sure - just dont include the view in the parameters. This will only respond with 100 records at a time but you can use offset and basic pagination to access all records.

See Solution in Thread

2 Replies 2

Sure - just dont include the view in the parameters. This will only respond with 100 records at a time but you can use offset and basic pagination to access all records.

Your solution was correct, thank you! I found out that the error was in the data table itself.