Retrieving records via row number

[Mark_Friedman]

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

[Andrew_Johnson1]

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)

[Mark_Friedman]

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