Access last or first item, Pagination or Sheet info about api-docs HOT 2 CLOSED

Thank you Jason.

I totally didn't spot reference.md - assumed docs were in progress!

from api-docs.

Thanks @dac09! Some answers:

• Pagination is done by passing limit and offset parameters, like ?limit=10&offset=20. That would get items 21–30 (counting from 1). More here: https://github.com/fieldbook/api-docs/blob/master/reference.md#pagination
• When you paginate, you get back an object that tells you the total number of items in the sheet. So to get just the number of items in a sheet, you could query with ?limit=0, which would return no items but would include the count.
• To get the first item in a sheet, just pass limit=1. The last item is trickier, you'd have to do this with one call to get the count, and then another call with offset=N where N is count - 1.
• You can do simple field=value queries right now, exact match. We'll support the full query language through the API in the future. More here: https://github.com/fieldbook/api-docs/blob/master/reference.md#sheet-queries

Hope that helps!

from api-docs.