Users
Update and query all users for a Slack team.
Select
The 本製品 uses the Slack API to process search criteria that refer to the Id column, while other filters are processed client-side within the 本製品. For example, the following query is processed server side:
SELECT * FROM Users WHERE Id = 'U5SU7GU6N'
Insert
Slack does not support inserting new users.
Update
You can update a user's FirstName, LastName, ProfileDisplayName, and ProfileEmail by providing the Id of the user. Only a team admin of a paid team can update another user's profile.
UPDATE Users SET ProfileDisplayName = 'Dis Name', ProfileEmail = '[email protected]' WHERE Id = 'U5SU7GU6N'
Delete
Slack does not support deleting users.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
The Id of the User. |
FirstName | String | False |
Fist name of the user. |
LastName | String | False |
Last name of the user. |
FullName | String | True |
Full name of the user. |
ProfileDisplayName | String | False |
Display name of the user. |
ProfileEmail | String | False |
Email of the user. |
ProfileImage | String | True |
URLs to square, web-viewable image of a user's profile. |
Deleted | Boolean | True |
Indicates if the user is deactivated. |
TeamId | String | True |
Id of the Slack team the user belongs to. |
IsAdmin | Boolean | True |
Indicates whether the user administers this team. |
Color | String | True |
A field used in some clients to display a colored username. |
Timezone | String | True |
String for the geographic region. |
TimezoneLabel | String | True |
String describing the name of that timezone. |
TimezoneOffset | Integer | True |
A signed integer indicating the number of seconds to offset UTC time by. |
IsOwner | Boolean | True |
Indicates whether this user is the owner of this team. |
IsPrimaryOwner | Boolean | True |
Indicates whether this user is the primary owner of this team. |
IsRestricted | Boolean | True |
Indicates whether this user is restricted from the team . |
IsUltraRestricted | Boolean | True |
Indicates whether this user is forbidden from the team. |
Updated | Datetime | True |
A datetime that shows when the user was last updated. |
IsAppUser | Boolean | True |
A boolean value indicating if the user uses the Slack App. |
Has2fa | Boolean | True |
A boolean value indicating if the user uses Two Factor Authentication. |