> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/legacy/legacy-experience/books/reference/airtable-legacy.md).

# Airtable (Legacy)

## Introduction

The **Airtable** Book integrates with Airtable and helps automate data management. You can read, update, and organize records using natural language, making workflows faster and easier.

## Prerequisites

1. **Airtable Account**: You need to have an active Airtable account. If you do not have one, you can sign up for an Airtable trial account to get started.
2. **API Access**: Ensure that your Airtable account has API access enabled. API access is required for Kognitos to communicate with Airtable.
3. **API Token**: Obtain your Airtable API token, which is used to access Airtable via the API securely. You can generate this token in your Airtable account settings under "API".

## Adding the Airtable Book

1. Navigate to **Books → All Books**.
2. Click **Airtable (Legacy).**
3. Click on **Add Connection**.
4. Enter your credentials when prompted:
   1. **Airtable Token**: The API token for your Airtable account, to authenticate API requests.
   2. **Airtable Base**: The name of the Airtable base you want to connect to. This base contains the tables and records you will interact with.

## Procedures

### Fetching Airtable Data

To fetch data from Airtable using custom queries:

```
obtain airspot's Projects table where
    the required foreign columns are "Project Manager"
```

To fetch data from Airtable using direct queries:

```
obtain airspot's Employees table where
    the required foreign columns are "Manager"
```