# 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"
```