Comment on page
Aircall
Aircall ETL for data replication
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
- 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.
- 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
Users
Purpose: Fetch all Users associated to a Company and their information.
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.
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.
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.
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.
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.
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.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
name | STRING |
users_count | NUMERIC |
numbers_count | NUMERIC |
Last modified 2yr ago