Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

Use Airtable's API with Artavolo

Updated

Artavolo answers Airtable's REST API at the same paths, with the same ids and the same JSON. A script, the Airtable.js library or an HTTP step written for Airtable keeps working once you change two things: the address and the token.

Point a script at Artavolo

  1. Create an Artavolo API token for the workspace that holds the base. See Use the REST API and API tokens.
  2. Replace https://api.airtable.com with https://artavolo.com, or your own server's address.
  3. Replace the Airtable token with the Artavolo token. It is sent the same way: Authorization: Bearer <token>.

With Airtable.js that is the apiKey and the endpointUrl you pass to new Airtable(). A list request looks like this: GET https://artavolo.com/v0/appXXXXXXXXXXXXXX/Tasks?filterByFormula={Status}='Done'.

Ids stay the same

A base brought over with the Airtable importer keeps Airtable's ids: the base's app... id, each table's tbl..., each field's fld... and each record's rec.... Saved record ids and links in your own systems keep pointing at the same records. You can also name a table or a field by its name. A record made in Artavolo gets an id that starts with recAV.

What it answers

  • Records: list (with pageSize up to 100, offset, fields[], sort, view and filterByFormula), read one, create, update with PATCH or PUT, and delete, up to 10 records per request as in Airtable.
  • The meta API: /v0/meta/whoami, /v0/meta/bases and /v0/meta/bases/{base}/tables, with field types named as Airtable names them. Integration tools use these to fill their base, table and field pickers.
  • Polling: sort by CREATED_TIME() or LAST_MODIFIED_TIME() without a time field of your own, and ask only for what changed with createdAfter or modifiedAfter.
  • Subscriptions: /v0/hooks sends each change of a table to an address you give, signed with a secret. See Connect Zapier, Make or n8n.

Values come in Airtable's cell format: a single select as its option's name, links as record ids, attachments with their URL, file name, size and type. Errors and the 429 for too many requests come in Airtable's shape too, so code that already handles them backs off correctly.

Good to know

  • The token's owner acts with their own permissions: roles, hidden tables and record rules apply, every write is in the audit log, and deletes go to the trash.
  • filterByFormula handles comparisons, AND, OR, NOT, FIND, SEARCH, BLANK(), IS_BEFORE, IS_AFTER, IS_SAME and RECORD_ID(). Anything else is refused with Airtable's INVALID_FILTER_BY_FORMULA, never answered with a wider list.
  • Not there yet: performUpsert, changing a base's structure through the meta API (it only reads), Airtable's own webhooks API, record comments and cellFormat=string.
  • Every table can also be exported in Airtable's CSV and JSON formats, so you can take your data back to Airtable at any time.

Related