> For the complete documentation index, see [llms.txt](https://docs.quanti.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quanti.io/connectors/sales-analytics-connectors/aircall.md).
# Aircall
Follow our setup guide to connect Aircall to QUANTI:
{% hint style="info" %}
This connector uses the [Aircall API v1](https://developer.aircall.io/api-references/) with API ID + API Token authentication (HTTP Basic Auth). It pulls call center data from your Aircall account.
{% endhint %}
***
## Overview
The Aircall connector centralizes your telephony data into your data warehouse, covering individual call records, phone line configurations, and agent profiles.
Data is split into two types:
* **Dimension tables** (`numbers`, `users`) — list of phone lines and agents, refreshed on each run using append-only insertion.
* **Call records** (`calls`) — individual call events refreshed with a configurable lookback window using delete-insert.
***
## Prerequisites
* An active **Aircall account** with admin access
* An **API ID** and **API Token** — generate them in your Aircall Dashboard under **Integrations > API Keys**
{% hint style="warning" %}
The API Token is only displayed once at creation time. Store it securely before closing the dialog.
{% endhint %}
***
## Setup Instructions
{% stepper %}
{% step %}
**Enter your API credentials**
Provide your **API ID** and **API Token**. Both are available in your Aircall Dashboard under **Integrations > API Keys**.
{% endstep %}
{% step %}
**Select your Prebuilt reports**
Choose which prebuilt reports to activate. You can enable all reports or select only those relevant to your use case. See the [Prebuilt Reports](#prebuilt-reports) section for a description of each table.
{% endstep %}
{% step %}
**Name your connector**
Give the connector a unique name within your QUANTI: project, then click **Create**.
{% endstep %}
{% endstepper %}
***
## Prebuilt Reports
The connector provides **3 prebuilt tables** organized into two groups: call records and directory.
### Data model
Prebuilt reports and definition
```mermaid
erDiagram
numbers {
integer id PK
string name
string digits
string country
string time_zone
boolean open
string availability_status
boolean is_ivr
boolean live_recording_activated
timestamp created_at
}
users {
integer id PK
string name
string email
boolean available
string availability_status
timestamp created_at
string time_zone
string language
string substatus
integer wrap_up_time
string extension
}
calls {
integer id PK
timestamp started_at
timestamp answered_at
timestamp ended_at
integer duration
string status
string direction
string raw_digits
string missed_call_reason
boolean archived
integer number_id
string number_name
string number_digits
string number_country
integer user_id
string user_name
string user_email
integer contact_id
string contact_name
}
numbers ||--o{ calls : "number_id"
users ||--o{ calls : "user_id"
```
### Call Records
| Table | Description |
| ------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `calls` | Individual call records filtered by start date. One row per call, with direction (inbound/outbound), status (answered, missed, done, voicemail, blocked), duration, handling agent, phone number, and linked contact. Key: `id`. Refreshed by delete-insert on `started_at`. |
### Directory
| Table | Description |
| --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `numbers` | All Aircall phone lines configured in the account: name, E.164 number, country, timezone, IVR flag, recording setting, and current availability status. Refreshed on each run (append-only). |
| `users` | All Aircall agents (users): name, email, availability, sub-status, wrap-up time, extension, and timezone. Refreshed on each run (append-only). |
***
Prebuilt reports and definition
***
## Scheduling
| Setting | Options |
| ------------------- | ------------------------------------------------ |
| **Frequency** | Daily (recommended) or Weekly |
| **Lookback window** | 1, 3, or 5 days (default: 5) |
| **Historical load** | Up to 365 days (3, 6, or 12 month quick options) |
{% hint style="info" %}
`calls` uses a **delete-insert** strategy on `started_at` to capture any updates to call status or duration within the lookback window. `numbers` and `users` use **append-only** insertion.
{% endhint %}
***
## Troubleshooting
Authentication error — 401 Unauthorized
Double-check your **API ID** and **API Token**. Both values are available in Aircall Dashboard > Integrations > API Keys. Make sure there are no trailing spaces. If the error persists, regenerate your API key pair — the token is only shown once at creation, so if you've lost it you'll need a new pair.
calls table is missing recent calls
The lookback window controls how far back calls are re-fetched. If calls are appearing in Aircall but not in your warehouse, extend the lookback to 5 days and trigger a manual sync. Calls are indexed by `started_at`, so calls that started outside the window will not be re-fetched.
user_id is null on some call records
`user_id` is null for missed calls where no agent answered. This is expected API behavior — missed calls have no handling agent.
Need help?
Contact QUANTI: support at or consult our documentation at