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 |