Airtable API
query public
5
Node
JavaScript
Python beta
Ruby beta
Shell
curl
Hey! Want to build awesome, scalable APIs like this one?
Sign up with Standard Library today and build your own API or connect to others in seconds.
We hope you enjoy documentation for the Airtable query API on Standard Library! This API can be used via the command line (shell), Node, Ruby, Python or as a generic HTTP call in any language. Check the code examples on the right associated with each API method for how to use this API in your language of choice.
API Description
Query Airtable Bases
# API Documentation This file should contain documentation introducing your API to **end-users**. It will display on your service's [Standard Library](https://stdlib.com/) documentation page if you choose to publish it. Usage examples and additional information around calling your API belong here.
Count Rows by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
Delete Rows by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
Retrieve Distinct Values by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
field
required
string
The field (column name) to grab distinct values for
current value set to
enter a test value
Insert a Row into a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
fields
required
object
The fields of the record
current value set to
enter a test value
Retrieve the Max Value for a Field by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
field
required
string
The field (column name) to grab the max value for
current value set to
enter a test value
Retrieve the Min Value for a Field by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
field
required
string
The field (column name) to grab the min value for
current value set to
enter a test value
Replace Rows by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
replaceRows
required
array
An array of rows to replace
current value set to
enter a test value
Select Rows by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
Update Rows by querying a Base
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
table
required
string
The Table name or id
current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
fields
object
An object with key-value pairs representing column-cell updates
optional, default value is
{}
optional, current value set to
enter a test value
Made with by the Airtable team with the help of Standard Library.