Aircall Connector Reference

10 metrics94 dimensions

The Aircall connector exposes 104 fields (10 metrics, 94 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Aircall Fields

Aircall calls fields

The calls report of the Aircall connector includes 26 fields.

IDTypeNameDescription
calls__answered_atNUMERICcalls.answered_atcalls.answered_at
calls__archivedBOOLEANcalls.archivedcalls.archived
calls__assetTEXTcalls.assetcalls.asset
calls__assigned_toTEXTcalls.assigned_tocalls.assigned_to
calls__commentsOBJECTcalls.commentscalls.comments
calls__contactTEXTcalls.contactcalls.contact
calls__costTEXTcalls.costcalls.cost
calls__country_code_a2TEXTcalls.country_code_a2calls.country_code_a2
TEXTcalls.direct_linkcalls.direct_link
calls__directionTEXTcalls.directioncalls.direction
calls__durationNUMERICcalls.durationcalls.duration
calls__ended_atNUMERICcalls.ended_atcalls.ended_at
calls__idTEXTcalls.idcalls.id
calls__missed_call_reasonTEXTcalls.missed_call_reasoncalls.missed_call_reason
calls__numberOBJECTcalls.numbercalls.number
calls__pricing_typeTEXTcalls.pricing_typecalls.pricing_type
calls__raw_digitsTEXTcalls.raw_digitscalls.raw_digits
calls__recordingTEXTcalls.recordingcalls.recording
calls__started_atNUMERICcalls.started_atcalls.started_at
calls__statusTEXTcalls.statuscalls.status
calls__tagsOBJECTcalls.tagscalls.tags
calls__teamsOBJECTcalls.teamscalls.teams
calls__transferred_byTEXTcalls.transferred_bycalls.transferred_by
calls__transferred_toTEXTcalls.transferred_tocalls.transferred_to
calls__userOBJECTcalls.usercalls.user
calls__voicemailTEXTcalls.voicemailcalls.voicemail

Aircall company fields

The company report of the Aircall connector includes 3 fields.

IDTypeNameDescription
company__nameTEXTcompany.namecompany.name
company__numbers_countNUMERICcompany.numbers_countcompany.numbers_count
company__users_countNUMERICcompany.users_countcompany.users_count

Aircall contacts fields

The contacts report of the Aircall connector includes 11 fields.

IDTypeNameDescription
contacts__company_nameTEXTcontacts.company_namecontacts.company_name
contacts__created_atNUMERICcontacts.created_atcontacts.created_at
TEXTcontacts.direct_linkcontacts.direct_link
contacts__emailsOBJECTcontacts.emailscontacts.emails
contacts__first_nameTEXTcontacts.first_namecontacts.first_name
contacts__idTEXTcontacts.idcontacts.id
contacts__informationTEXTcontacts.informationcontacts.information
contacts__is_sharedBOOLEANcontacts.is_sharedcontacts.is_shared
contacts__last_nameTEXTcontacts.last_namecontacts.last_name
contacts__phone_numbersOBJECTcontacts.phone_numberscontacts.phone_numbers
contacts__updated_atNUMERICcontacts.updated_atcontacts.updated_at

Aircall General fields

The General report of the Aircall connector includes 3 fields.

IDTypeNameDescription
account_idTEXTAccount IDThe Windsor.ai account the row belongs to.
account_nameTEXTAccount NameThe name of the Windsor.ai account.
dateDATEDateThe record's timestamp (call start / creation date).

Aircall numbers fields

The numbers report of the Aircall connector includes 17 fields.

IDTypeNameDescription
numbers__availability_statusTEXTnumbers.availability_statusnumbers.availability_status
numbers__availableBOOLEANnumbers.availablenumbers.available
numbers__countryCOUNTRYnumbers.countrynumbers.country
numbers__created_atTEXTnumbers.created_atnumbers.created_at
numbers__digitsTEXTnumbers.digitsnumbers.digits
TEXTnumbers.direct_linknumbers.direct_link
numbers__emailTEXTnumbers.emailnumbers.email
numbers__idTEXTnumbers.idnumbers.id
numbers__is_ivrBOOLEANnumbers.is_ivrnumbers.is_ivr
numbers__languageTEXTnumbers.languagenumbers.language
numbers__live_recording_activatedBOOLEANnumbers.live_recording_activatednumbers.live_recording_activated
numbers__messagesOBJECTnumbers.messagesnumbers.messages
numbers__nameTEXTnumbers.namenumbers.name
numbers__openBOOLEANnumbers.opennumbers.open
numbers__priorityTEXTnumbers.prioritynumbers.priority
numbers__time_zoneTEXTnumbers.time_zonenumbers.time_zone
numbers__wrap_up_timeNUMERICnumbers.wrap_up_timenumbers.wrap_up_time

Aircall tags fields

The tags report of the Aircall connector includes 4 fields.

IDTypeNameDescription
tags__colorTEXTtags.colortags.color
tags__descriptionTEXTtags.descriptiontags.description
tags__idTEXTtags.idtags.id
tags__nameTEXTtags.nametags.name

Aircall teams fields

The teams report of the Aircall connector includes 5 fields.

IDTypeNameDescription
teams__created_atTEXTteams.created_atteams.created_at
TEXTteams.direct_linkteams.direct_link
teams__idTEXTteams.idteams.id
teams__nameTEXTteams.nameteams.name
teams__usersOBJECTteams.usersteams.users

Aircall users fields

The users report of the Aircall connector includes 10 fields.

IDTypeNameDescription
users__availability_statusTEXTusers.availability_statususers.availability_status
users__availableBOOLEANusers.availableusers.available
users__created_atTEXTusers.created_atusers.created_at
TEXTusers.direct_linkusers.direct_link
users__emailTEXTusers.emailusers.email
users__idTEXTusers.idusers.id
users__languageTEXTusers.languageusers.language
users__nameTEXTusers.nameusers.name
users__time_zoneTEXTusers.time_zoneusers.time_zone
users__wrap_up_timeNUMERICusers.wrap_up_timeusers.wrap_up_time

Aircall webhooks fields

The webhooks report of the Aircall connector includes 7 fields.

IDTypeNameDescription
webhooks__activeBOOLEANwebhooks.activewebhooks.active
webhooks__created_atTEXTwebhooks.created_atwebhooks.created_at
TEXTwebhooks.direct_linkwebhooks.direct_link
webhooks__eventsOBJECTwebhooks.eventswebhooks.events
webhooks__idTEXTwebhooks.idwebhooks.id
webhooks__tokenTEXTwebhooks.tokenwebhooks.token
webhooks__urlTEXTwebhooks.urlwebhooks.url

Aircall other fields

The Aircall connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20