# Use Airtable's API with Artavolo

> Artavolo answers Airtable's REST API at the same paths, so scripts, Airtable.js and integrations keep working after you change the address and the token.

Source: https://artavolo.com/page/airtable-compatible-api

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](https://artavolo.com/page/rest-api-and-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](https://artavolo.com/page/zapier-make-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

- [Move from Airtable](https://artavolo.com/page/move-from-airtable)
- [Connect Zapier, Make or n8n](https://artavolo.com/page/zapier-make-n8n)
- [Use the REST API and API tokens](https://artavolo.com/page/rest-api-and-tokens)
- [Airtable-compatible API reference](https://artavolo.com/docs/airtable-api)
