airtable - sinsunsan/archiref_wiki GitHub Wiki

• More infos about air-table query format https://github.com/Airtable/airtable.js/blob/master/lib/query.js#L96

• A blog post explaining some changes (feb 2016) to the api client http://blog.airtable.com/post/138484080527/the-right-sort-of-api-updates

• a ui allowing to quickly url encode parameters

API query usage

In all example {tableId} is to replace by your table Id

Limit number of items per page

https://api.airtable.com/v0/{DatabaseId}/{TableId}?pageSize=1

Filters items with a title = to a defined value

https://api.airtable.com/v0/{DatabaseId}/{TableId}?filterByFormula={title}="Ternes"

Filters items with a integer field > 0

https://api.airtable.com/v0/{DatabaseId}/{TableId}?filterByFormula={cost}>1000000