Aircall Calls

NOTE: This table is only available to some customers with custom call center numbers

NOTE: This table will be published in Week 23 or 24

One can see the full documentation about Aircall API endpoint here. We use most of the same columns with some cleaning for use at Monta. https://developer.aircall.io/api-references/#call-overview

Name	Data Type	Description
call_id	INTEGER	Primary key
call_provider_id	STRING	Call identifier from call provider
started_at	Timestamp_NTZ	Timestamp when the Call started. In UTC
ended_at	Timestamp_NTZ	Timestamp when the Call ended. In UTC
answered_at	Timestamp_NTZ	Timestamp when the Call was answered. In UTC
duration_seconds	INTEGER	Duration of the call in second. This field is computed by `ended_at - started_at`.
direction	STRING	Direction of the call: "inbound" or "outbound".
aircall_link	STRING	URL to access the call in the Aircall web application.
status	STRING	Status of the call: "answered", "missed", "voicemail", "abandoned" or "refused".
missed_call_reason	STRING	Representing the reason why the Call was missed. Can be `out_of_opening_hours`, `short_abandoned`, `abandoned_in_ivr`, `abandoned_in_classic`, `no_available_agent` or `agents_did_not_answer`.
user_id	INTEGER	ID of the user that took or made the call
user_name	STRING	Name of the user who took or made the call
user_email	STRING	Email of the user who took or made the call
user_language	STRING	Language preference for the user who took or made the call. The format is IETF language tag. Default is en-US.
user_wrap_up_time	INTEGER	A pre-set timer triggered after a call has ended, during which the user can’t receive any calls.
user_extension	STRING	The extension of the user
number_id	INTEGER	Unique identifier for the Number.
number_name	STRING	The name of the Number.
number_digits	STRING	International format of the Number.
number_country	STRING	ISO 3166-1 alpha-2 country code of the Number.
number_time_zone	STRING	Number's time zone
assigned_to_id	INTEGER	ID of the user to whom the call was assigned
assigned_to_email	STRING	Email of the user to whom the call was assigned
assigned_to_name	STRING	Name of the user to whom the call was assigned
transferred_by_id	INTEGER	ID of the user who made the transfer
transferred_by_email	STRING	Email of the user who made the transfer
transferred_by_first_name	STRING	First name of the user who made the transfer
transferred_by_last_name	STRING	Last name of the user who made the transfer
transferred_to_id	INTEGER	ID of the user who whom the call was transferred
transferred_to_email	STRING	Email of the user who whom the call was transferred
transferred_to_name	STRING	Name of the user who whom the call was transferred
pricing_type	STRING
recording	STRING	If present, the direct URL of the live recording (mp3 file) for this Call. This feature can be enabled from the Aircall Dashboard, on each Number - more information in our (valid for only 1 hour)
team_id	STRING	Unique identifier for the Team.
team_name	STRING	Full name of the Team.
comments_id	STRING	ID of Notes added to this Call by Users.
comments_content	STRING	Content of Notes added to this Call by Users.
tag_ids	STRING	IDs of Tags added to this Call by Users.
tag_names	STRING	Names of Tags added to this Call by Users.
final_ivr_id	STRING	Id of the last ivr option selected
final_ivr_key	STRING	Key of the last ivr option selected
final_ivr_started_at	Timestamp_NTZ	Timestamp when the last IVR option starts i.e. user starts listening to IVR Options.
final_ivr_ended_at	Timestamp_NTZ	Timestamp when the last IVR option ends i.e. user selects an option or default option is selected.