Aircall

Aircall ETL for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Aircall Email Aircall password
Replication Type	Key based Replication
Replication Key	DATE
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Users	Tags
Numbers	Teams
Contacts	Calls

CompanyInfo

Integrate Aircall with Daton

1. Signin to Daton

2. Select Aircall from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Aircall account Email and Password and provide your store URL

5. After providing the Email,password authorize Daton to periodically extract data from Aircall.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Aircall Data

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.

Source API Documentation https://developer.aircall.io/api-references/#retrieve-company-information

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
name	STRING
users_count	NUMERIC
numbers_count	NUMERIC