Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Aircall connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Aircall connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Aircall connector:
- Users
- Numbers
- Contacts
- CompanyInfo
- Tags
- Teams
- Calls
Users
Purpose: Fetch all Users associated to a Company and their information.
Source API Documentation https://developer.aircall.io/api-references/#list-all-users
Replication: Key-Based Replication
Replication Key: lastRunDate
FIELDS
Name |
Target Datatype |
|---|---|
id |
NUMERIC |
direct_link |
STRING |
name |
STRING |
email |
STRING |
available |
BOOLEAN |
availability_status |
STRING |
created_at |
TIMESTAMP |
time_zone |
STRING |
| language | STRING |
Tags
Purpose: Fetch all Tags associated to a company and their information.
Source API Documentation https://developer.aircall.io/api-references/#list-all-tags
Replication: Full Replication
Replication Key: NA
FIELDS
Name |
Target Datatype |
|---|---|
id |
NUMERIC |
name |
STRING |
color |
STRING |
| description | STRING |
Numbers
Purpose: Fetch all Numbers associated to a company and their information.
Source API Documentation https://developer.aircall.io/api-references/#list-all-numbers
Replication: Key-Based Replication
Replication Key: lastRunDate
FIELDS
Name |
Target Datatype |
|---|---|
id |
NUMERIC |
direct_link |
STRING |
name |
STRING |
digits |
STRING |
created_at |
TIMESTAMP |
country |
STRING |
time_zone |
STRING |
open |
BOOLEAN |
availability_status |
STRING |
is_ivr |
BOOLEAN |
live_recording_activated |
BOOLEAN |
messages |
RECORD |
| users | RECORD |
Teams
Purpose: Fetch all Teams associated to a company and their information.
Source API Documentation https://developer.aircall.io/api-references/#list-all-teams
Replication: Full Replication
Replication Key: NA
FIELDS
Name |
Target Datatype |
|---|---|
id |
NUMERIC |
name |
STRING |
direct_link |
STRING |
created_at |
TIMESTAMP |
| users | RECORD |
Contacts
Purpose:Fetch all the shared Contacts associated to a company with their phone numbers and emails information.
Source API Documentation https://developer.aircall.io/api-references/#list-all-contacts
Replication: Key-Based Replication
Replication Key: lastRunDate
FIELDS
Name |
Target Datatype |
|---|---|
id |
NUMERIC |
direct_link |
STRING |
first_name |
STRING |
last_name |
STRING |
company_name |
STRING |
information |
STRING |
is_shared |
BOOLEAN |
created_at |
TIMESTAMP |
updated_at |
TIMESTAMP |
emails |
STRING |
| phone_numbers | RECORD |
Calls
Purpose: Fetch all Calls associated to a company and their information.
Source API Documentation https://developer.aircall.io/api-references/#list-all-calls
Replication: Key-Based Replication
Replication Key: lastRunDate
FIELDS
Name |
Target Datatype |
|---|---|
id |
NUMERIC |
direct_link |
STRING |
direction |
STRING |
status |
STRING |
missed_call_reason |
STRING |
started_at |
TIMESTAMP |
answered_at |
TIMESTAMP |
ended_at |
TIMESTAMP |
duration |
NUMERIC |
voicemail |
STRING |
recording |
STRING |
asset |
STRING |
raw_digits |
STRING |
user |
RECORD |
contact |
STRING |
archived |
BOOLEAN |
assigned_to |
STRING |
transferred_to |
STRING |
cost |
STRING |
number |
RECORD |
comments |
RECORD |
tags |
RECORD |
| teams | STRING |
CompanyInfo
Purpose: Company information can be retrieve with this GET request.
FIELDS
Name |
Target Datatype |
|---|---|
name |
STRING |
users_count |
NUMERIC |
| numbers_count | NUMERIC |
