Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Retrieving records via row number

Topic Labels: API
2849 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there any way in the API to retrieve the record at a particular row number? I know I could get all the rows up to that row number using the maxRecords option of the select method, but that would obviously be quite inefficient.

Thanks in advance.

-Mark

2 Replies 2

Just came across this question…thought I would share my views

Make sure that you have an “autonumber” field associated with each record in your base.

Then use the “filterByFormula” functionality the API provides you with to fetch only that row number (i.e the autonumber field)

Thanks, Andrew! Unfortunately, we are building a framework for others to use and therefore we don’t have control over the bases that our code will be accessing.

-Mark