Help

Retrieving records via row number

Topic Labels: API
3497 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark_Friedman
4 - Data Explorer
4 - Data Explorer

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
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

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