external_contact

Table Type: Metadata

Contains external contacts. These are named contacts who have been identified as individuals, so that they can be recognised over multiple interactions, possibly across different media types.

Columns

Column Type Modifiers Notes
id string Primary Key The unique identifier of the external contact.
db_last_updated datetime When this record was last updated in UTC.
db_when_created datetime When this record was created in UTC.
db_when_deleted datetime When this record was deleted in UTC.
type string The type of the external contact. One of: Ephemeral, Identified or Curated
division_id string The division ID this external contact belongs to.
first_name string The first name of the external contact.
middle_name string The middle name of the external contact.
last_name string The last name of the external contact.
salutation string The salutation of the external contact.
title string The title of the external contact.
work_phone_display string The work phone number display of the external contact.
work_phone_extension int64
work_phone_accepts_sms boolean Whether the work phone number accepts SMS messages.
work_phone_normalization_country_code string The country code used for normalizing the work phone number.
work_phone_user_input string The work phone number as input by the user.
work_phone_e164 string The work phone number in E.164 format.
work_phone_country_code string The country code of the work phone number.
cell_phone_display string The cell phone number display of the external contact.
cell_phone_extension int64
cell_phone_accepts_sms boolean Whether the cell phone number accepts SMS messages.
cell_phone_normalization_country_code string The country code used for normalizing the cell phone number.
cell_phone_user_input string The cell phone number as input by the user.
cell_phone_e164 string The cell phone number in E.164 format.
cell_phone_country_code string The country code of the cell phone number.
home_phone_display string The home phone number display of the external contact.
home_phone_extension int64 The home phone number extension of the external contact.
home_phone_accepts_sms boolean Whether the home phone number accepts SMS messages.
home_phone_normalization_country_code string The country code used for normalizing the home phone number.
home_phone_user_input string The home phone number as input by the user.
home_phone_e164 string The home phone number in E.164 format.
home_phone_country_code string The country code of the home phone number.
other_phone_display string The other phone number display of the external contact.
other_phone_extension int64 The other phone number extension of the external contact.
other_phone_accepts_sms boolean Whether the other phone number accepts SMS messages.
other_phone_normalization_country_code string The country code used for normalizing the other phone number.
other_phone_user_input string The other phone number as input by the user.
other_phone_e164 string The other phone number in E.164 format.
other_phone_country_code string The country code of the other phone number.
work_email string The work email of the external contact.
personal_email string The personal email of the external contact.
other_email string The other email of the external contact.
address1 string The first line of the address of the external contact.
address2 string The second line of the address of the external contact.
city string The city of the external contact.
state string The state of the external contact.
postal_code string The postal code of the external contact.
country_code string The country code of the external contact.
twitter_name string
twitter_screen_name string
twitter_verified boolean
twitter_profile_url string
whatsapp_phone_display string
whatsapp_phone_extension int64
whatsapp_phone_accepts_sms boolean
whatsapp_phone_normalization_country_code string
whatsapp_phone_user_input string
whatsapp_phone_e164 string
whatsapp_phone_country_code string
whatsapp_display_name string
facebook_display_name string
modify_date datetime The date the external contact was last modified.
create_date datetime The date the external contact was created.
external_organization_id string The external organization id of the external contact or NULL.
external_organization_name string The external organization name of the external contact or NULL.

Actions and Background Tasks

Actions