Access last or first item, Pagination or Sheet info

[dac09]

Hi,

First of all - great product you guys are building - I'm certainly curious what I can get done with it.

I had a few questions regarding the API:

• Is there a quick way of accessing the first and/or last item in a sheet?
• How do I paginate, for example if I have a huge number of rows (as I expect to have over time)?
• Is there a way I can query book info? (So that I can access, for example the number of items in each sheet)
• Could I somehow list a subset of items in a sheet? e.g. filter

Thanks

[jasoncrawford]

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!

[dac09]

Thank you Jason.

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