Skip to main content

Retrieving records via row number

  • March 22, 2018
  • 2 replies
  • 32 views
M

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

A
Forum|alt.badge.img+3
  • Andrew_Johnson1
  • Participating Frequently
  • April 27, 2018

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)

M
  • Mark_Friedman
  • Author
  • New Participant
  • April 27, 2018

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

Terms & ConditionsAccessibility statement