APP_ACTIVATE_USER_CHANNEL_DETAILS

Update: Nov 19:

Added: COMPANY_DISPLAY_NAME

Updated Nov 14 to include:

Table updated to include data_type column and removed table_name column

Update: Nov 5:

Added: CHANNEL_DISPLAY_NAME


column_namedata_typedescription
ACTIVATE_USER_IDTEXTThe unique ID number assigned to each user in the company's internal system.
ACTIVATE_USER_NAMETEXTThe full name of the user associated with the activate_user_id.
ALL_GROUP_ROLESTEXTAll of the roles and groups that the user belongs to within the company.
ALL_PERMISSIONSTEXTAll of the access permissions granted to the user within the company's systems.
CHANNEL_DISPLAY_NAMETEXTDisplay name of the channel associated with the channel_id
CHANNEL_IDTEXTThe unique ID number assigned to each channel in the company's internal system.
CHANNEL_NAMETEXTThe name of the channel that the user has access to.
CHANNEL_TYPETEXTThe category or type of channel, e.g. public, private, or direct message.
CHILDREN_CHANNEL_IDSVARIANTThe IDs of any sub-channels nested within the parent channel.
COMPANY_CHANNEL_IDTEXTThe Channel ID of the company channel the user first joined
COMPANY_NAMETEXTThe name of the company channel that the user first joined
DOMAINTEXTThe website domain associated with the company and its channels.
EMAIL_OPT_INBOOLEANWhether the user has opted in for marketing email notifications
FIRST_CHANNEL_ACTIVITY_ATTIMESTAMP_NTZThe timestamp of the user's first activity within the channel.
HEAD_COUNTNUMBERThe total number of members in the channel.
IS_EMPLOYEEBOOLEANA true/false value indicating whether the user is an employee of the company.
IS_WORKPLACE_ADMINBOOLEANA true/false value indicating whether the user has admin permissions for the channel.
IS_WORKPLACE_MEMBERBOOLEANA true/false value indicating whether the user is a member of the channel.
JOINED_CHANNEL_ATTIMESTAMP_NTZThe timestamp when the user first joined or was added to the channel.
LANGUAGE_PREFERENCETEXTThe preferred language setting for the user's account.
LAST_BOOKEDTIMESTAMP_NTZThe timestamp of the user's most recent booking activity within the channel.
PARENT_CHANNEL_IDSVARIANTThe IDs of all channels directly above the current channel in the channel hierarchy.
PARENT_CHANNEL_NAMETEXTThe name of the channel directly above the current channel in the channel hierarchy.
PARENT_IDTEXTThe ID of the channel directly above the current channel in the channel hierarchy.
PARENT_PERMISSIONSTEXTThe permissions inherited by the current channel from channels higher in the hierarchy.
PRIMARY_COMPANY_IDTEXTThe ID of the user's primary company.
PRIMARY_LOCATION_IDTEXTThe ID of the user's primary location.
PRIMARY_LOCATION_NAMETEXTThe name of the user's primary location channel.
USER_CREATED_ATTIMESTAMP_NTZThe timestamp when the user's account was first created.
USER_EMAILTEXTThe email address associated with the user's account.
USER_LAST_SEEN_ATTIMESTAMP_NTZThe timestamp of the user's most recent activity within the company's systems.
USER_STATUSTEXTThe status of the user's account, e.g. active, inactive, suspended, etc.
COMPANY_DISPLAY_NAMETEXTThe display name of the company channel that the the user first joined

Interested in using our Next-Generation API Suite? Request Access by emailing [email protected]