Users
Update and query all users for a Slack team.
Select
The connector uses the Slack API to process search criteria that refer to the Id column, while other filters are processed client-side within the connector. 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 = 'test@company.com' 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. |