Aircall Field Reference


Fields

IDTypeNameDescriptionReport
calls__answered_atNUMERICcalls.answered_atcalls.answered_atcalls
calls__archivedBOOLEANcalls.archivedcalls.archivedcalls
calls__assetTEXTcalls.assetcalls.assetcalls
calls__assigned_toTEXTcalls.assigned_tocalls.assigned_tocalls
calls__commentsOBJECTcalls.commentscalls.commentscalls
calls__contactTEXTcalls.contactcalls.contactcalls
calls__costTEXTcalls.costcalls.costcalls
calls__country_code_a2TEXTcalls.country_code_a2calls.country_code_a2calls
TEXTcalls.direct_linkcalls.direct_linkcalls
calls__directionTEXTcalls.directioncalls.directioncalls
calls__durationNUMERICcalls.durationcalls.durationcalls
calls__ended_atNUMERICcalls.ended_atcalls.ended_atcalls
calls__idNUMERICcalls.idcalls.idcalls
calls__missed_call_reasonTEXTcalls.missed_call_reasoncalls.missed_call_reasoncalls
calls__numberOBJECTcalls.numbercalls.numbercalls
calls__pricing_typeTEXTcalls.pricing_typecalls.pricing_typecalls
calls__raw_digitsTEXTcalls.raw_digitscalls.raw_digitscalls
calls__recordingTEXTcalls.recordingcalls.recordingcalls
calls__started_atNUMERICcalls.started_atcalls.started_atcalls
calls__statusTEXTcalls.statuscalls.statuscalls
calls__tagsOBJECTcalls.tagscalls.tagscalls
calls__teamsOBJECTcalls.teamscalls.teamscalls
calls__transferred_byTEXTcalls.transferred_bycalls.transferred_bycalls
calls__transferred_toTEXTcalls.transferred_tocalls.transferred_tocalls
calls__userOBJECTcalls.usercalls.usercalls
calls__voicemailTEXTcalls.voicemailcalls.voicemailcalls
company__nameTEXTcompany.namecompany.namecompany
company__numbers_countNUMERICcompany.numbers_countcompany.numbers_countcompany
company__users_countNUMERICcompany.users_countcompany.users_countcompany
contacts__company_nameTEXTcontacts.company_namecontacts.company_namecontacts
contacts__created_atNUMERICcontacts.created_atcontacts.created_atcontacts
TEXTcontacts.direct_linkcontacts.direct_linkcontacts
contacts__emailsOBJECTcontacts.emailscontacts.emailscontacts
contacts__first_nameTEXTcontacts.first_namecontacts.first_namecontacts
contacts__idNUMERICcontacts.idcontacts.idcontacts
contacts__informationTEXTcontacts.informationcontacts.informationcontacts
contacts__is_sharedBOOLEANcontacts.is_sharedcontacts.is_sharedcontacts
contacts__last_nameTEXTcontacts.last_namecontacts.last_namecontacts
contacts__phone_numbersOBJECTcontacts.phone_numberscontacts.phone_numberscontacts
contacts__updated_atNUMERICcontacts.updated_atcontacts.updated_atcontacts
datasourceTEXTData SourceThe name of the Windsor connector returning the row
numbers__availability_statusTEXTnumbers.availability_statusnumbers.availability_statusnumbers
numbers__availableBOOLEANnumbers.availablenumbers.availablenumbers
numbers__countryTEXTnumbers.countrynumbers.countrynumbers
numbers__created_atTEXTnumbers.created_atnumbers.created_atnumbers
numbers__digitsTEXTnumbers.digitsnumbers.digitsnumbers
TEXTnumbers.direct_linknumbers.direct_linknumbers
numbers__emailTEXTnumbers.emailnumbers.emailnumbers
numbers__idNUMERICnumbers.idnumbers.idnumbers
numbers__is_ivrBOOLEANnumbers.is_ivrnumbers.is_ivrnumbers
numbers__languageTEXTnumbers.languagenumbers.languagenumbers
numbers__live_recording_activatedBOOLEANnumbers.live_recording_activatednumbers.live_recording_activatednumbers
numbers__messagesOBJECTnumbers.messagesnumbers.messagesnumbers
numbers__nameTEXTnumbers.namenumbers.namenumbers
numbers__openBOOLEANnumbers.opennumbers.opennumbers
numbers__priorityTEXTnumbers.prioritynumbers.prioritynumbers
numbers__time_zoneTEXTnumbers.time_zonenumbers.time_zonenumbers
numbers__wrap_up_timeNUMERICnumbers.wrap_up_timenumbers.wrap_up_timenumbers
sourceTEXTSourceThe name of the Windsor connector returning the row
tags__colorTEXTtags.colortags.colortags
tags__descriptionTEXTtags.descriptiontags.descriptiontags
tags__idNUMERICtags.idtags.idtags
tags__nameTEXTtags.nametags.nametags
teams__created_atTEXTteams.created_atteams.created_atteams
TEXTteams.direct_linkteams.direct_linkteams
teams__idNUMERICteams.idteams.idteams
teams__nameTEXTteams.nameteams.nameteams
teams__usersOBJECTteams.usersteams.usersteams
todayDATETodayToday's date
users__availability_statusTEXTusers.availability_statususers.availability_statususers
users__availableBOOLEANusers.availableusers.availableusers
users__created_atTEXTusers.created_atusers.created_atusers
TEXTusers.direct_linkusers.direct_linkusers
users__emailTEXTusers.emailusers.emailusers
users__idNUMERICusers.idusers.idusers
users__languageTEXTusers.languageusers.languageusers
users__nameTEXTusers.nameusers.nameusers
users__time_zoneTEXTusers.time_zoneusers.time_zoneusers
users__wrap_up_timeNUMERICusers.wrap_up_timeusers.wrap_up_timeusers
webhooks__activeBOOLEANwebhooks.activewebhooks.activewebhooks
webhooks__created_atTEXTwebhooks.created_atwebhooks.created_atwebhooks
TEXTwebhooks.direct_linkwebhooks.direct_linkwebhooks
webhooks__eventsOBJECTwebhooks.eventswebhooks.eventswebhooks
webhooks__idNUMERICwebhooks.idwebhooks.idwebhooks
webhooks__tokenTEXTwebhooks.tokenwebhooks.tokenwebhooks
webhooks__urlTEXTwebhooks.urlwebhooks.urlwebhooks