Aircall Lite

Aircall is a cloud-based call center and phone system.

Features

Feature Name	Supported	Notes
Capture deletes		`CONTACT`, `NUMBERS`, `TAGS`, `TEAM`, `USER_AVAILABILITY`, `USERS`, and `WEBHOOK` tables.
History mode
Custom data
Data blocking		Column level
Column hashing
Re-sync		Connection level and table level. A parent table re-sync includes all associated child tables.
Row filtering
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking
Authorization via API

We support the SaaS Deployment model for the connector.

Follow our step-by-step Aircall setup guide to connect Aircall with your destination using Fivetran connectors.

To capture new records, we incrementally sync the following tables and their child tables:

To capture updates and deletes, we do the following:

We re-import the NUMBERS table and its child tables once a week.
We use webhooks for the CONTACT and USERS tables and their child tables. We register a webhook, fivetran webhook, in your Aircall account to receive the webhook events for these tables.

This schema applies to all Aircall connections.

Explore Aircall schema ERD

The Aircall API provides only the last 3 months' worth of data for the Call endpoint. Due to this, during the initial sync, we only sync the last 3 months' worth of data for the CALL table. If you want to sync older historical data for this table, contact Aircall's support team.
Due to Aircall API limitations, we can only sync data created after the sync is initiated for the MESSAGE table. Historical backfill is not supported.