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