Windsor brings all your Aircall data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Aircall Field Reference
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
calls__answered_at | NUMERIC | calls.answered_at | calls.answered_at | calls |
calls__archived | BOOLEAN | calls.archived | calls.archived | calls |
calls__asset | TEXT | calls.asset | calls.asset | calls |
calls__assigned_to | TEXT | calls.assigned_to | calls.assigned_to | calls |
calls__comments | OBJECT | calls.comments | calls.comments | calls |
calls__contact | TEXT | calls.contact | calls.contact | calls |
calls__cost | TEXT | calls.cost | calls.cost | calls |
calls__country_code_a2 | TEXT | calls.country_code_a2 | calls.country_code_a2 | calls |
calls__direct_link | TEXT | calls.direct_link | calls.direct_link | calls |
calls__direction | TEXT | calls.direction | calls.direction | calls |
calls__duration | NUMERIC | calls.duration | calls.duration | calls |
calls__ended_at | NUMERIC | calls.ended_at | calls.ended_at | calls |
calls__id | NUMERIC | calls.id | calls.id | calls |
calls__missed_call_reason | TEXT | calls.missed_call_reason | calls.missed_call_reason | calls |
calls__number | OBJECT | calls.number | calls.number | calls |
calls__pricing_type | TEXT | calls.pricing_type | calls.pricing_type | calls |
calls__raw_digits | TEXT | calls.raw_digits | calls.raw_digits | calls |
calls__recording | TEXT | calls.recording | calls.recording | calls |
calls__started_at | NUMERIC | calls.started_at | calls.started_at | calls |
calls__status | TEXT | calls.status | calls.status | calls |
calls__tags | OBJECT | calls.tags | calls.tags | calls |
calls__teams | OBJECT | calls.teams | calls.teams | calls |
calls__transferred_by | TEXT | calls.transferred_by | calls.transferred_by | calls |
calls__transferred_to | TEXT | calls.transferred_to | calls.transferred_to | calls |
calls__user | OBJECT | calls.user | calls.user | calls |
calls__voicemail | TEXT | calls.voicemail | calls.voicemail | calls |
company__name | TEXT | company.name | company.name | company |
company__numbers_count | NUMERIC | company.numbers_count | company.numbers_count | company |
company__users_count | NUMERIC | company.users_count | company.users_count | company |
contacts__company_name | TEXT | contacts.company_name | contacts.company_name | contacts |
contacts__created_at | NUMERIC | contacts.created_at | contacts.created_at | contacts |
contacts__direct_link | TEXT | contacts.direct_link | contacts.direct_link | contacts |
contacts__emails | OBJECT | contacts.emails | contacts.emails | contacts |
contacts__first_name | TEXT | contacts.first_name | contacts.first_name | contacts |
contacts__id | NUMERIC | contacts.id | contacts.id | contacts |
contacts__information | TEXT | contacts.information | contacts.information | contacts |
contacts__is_shared | BOOLEAN | contacts.is_shared | contacts.is_shared | contacts |
contacts__last_name | TEXT | contacts.last_name | contacts.last_name | contacts |
contacts__phone_numbers | OBJECT | contacts.phone_numbers | contacts.phone_numbers | contacts |
contacts__updated_at | NUMERIC | contacts.updated_at | contacts.updated_at | contacts |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
numbers__availability_status | TEXT | numbers.availability_status | numbers.availability_status | numbers |
numbers__available | BOOLEAN | numbers.available | numbers.available | numbers |
numbers__country | TEXT | numbers.country | numbers.country | numbers |
numbers__created_at | TEXT | numbers.created_at | numbers.created_at | numbers |
numbers__digits | TEXT | numbers.digits | numbers.digits | numbers |
numbers__direct_link | TEXT | numbers.direct_link | numbers.direct_link | numbers |
numbers__email | TEXT | numbers.email | numbers.email | numbers |
numbers__id | NUMERIC | numbers.id | numbers.id | numbers |
numbers__is_ivr | BOOLEAN | numbers.is_ivr | numbers.is_ivr | numbers |
numbers__language | TEXT | numbers.language | numbers.language | numbers |
numbers__live_recording_activated | BOOLEAN | numbers.live_recording_activated | numbers.live_recording_activated | numbers |
numbers__messages | OBJECT | numbers.messages | numbers.messages | numbers |
numbers__name | TEXT | numbers.name | numbers.name | numbers |
numbers__open | BOOLEAN | numbers.open | numbers.open | numbers |
numbers__priority | TEXT | numbers.priority | numbers.priority | numbers |
numbers__time_zone | TEXT | numbers.time_zone | numbers.time_zone | numbers |
numbers__wrap_up_time | NUMERIC | numbers.wrap_up_time | numbers.wrap_up_time | numbers |
source | TEXT | Source | The name of the Windsor connector returning the row | |
tags__color | TEXT | tags.color | tags.color | tags |
tags__description | TEXT | tags.description | tags.description | tags |
tags__id | NUMERIC | tags.id | tags.id | tags |
tags__name | TEXT | tags.name | tags.name | tags |
teams__created_at | TEXT | teams.created_at | teams.created_at | teams |
teams__direct_link | TEXT | teams.direct_link | teams.direct_link | teams |
teams__id | NUMERIC | teams.id | teams.id | teams |
teams__name | TEXT | teams.name | teams.name | teams |
teams__users | OBJECT | teams.users | teams.users | teams |
today | DATE | Today | Today's date | |
users__availability_status | TEXT | users.availability_status | users.availability_status | users |
users__available | BOOLEAN | users.available | users.available | users |
users__created_at | TEXT | users.created_at | users.created_at | users |
users__direct_link | TEXT | users.direct_link | users.direct_link | users |
users__email | TEXT | users.email | users.email | users |
users__id | NUMERIC | users.id | users.id | users |
users__language | TEXT | users.language | users.language | users |
users__name | TEXT | users.name | users.name | users |
users__time_zone | TEXT | users.time_zone | users.time_zone | users |
users__wrap_up_time | NUMERIC | users.wrap_up_time | users.wrap_up_time | users |
webhooks__active | BOOLEAN | webhooks.active | webhooks.active | webhooks |
webhooks__created_at | TEXT | webhooks.created_at | webhooks.created_at | webhooks |
webhooks__direct_link | TEXT | webhooks.direct_link | webhooks.direct_link | webhooks |
webhooks__events | OBJECT | webhooks.events | webhooks.events | webhooks |
webhooks__id | NUMERIC | webhooks.id | webhooks.id | webhooks |
webhooks__token | TEXT | webhooks.token | webhooks.token | webhooks |
webhooks__url | TEXT | webhooks.url | webhooks.url | webhooks |