Create, update, and query all User Groups for a Slack team.
The connector uses the Slack API to process search criteria that refer to the IncludeDisabled column while other search criteria are processed client-side within the connector. For example, the following query is processed server side:
SELECT * FROM UserGroups WHERE IncludeDisabled = 'true'
Inserts are allowed only for paid workspaces and when you specify the Name of the user group. Other optional fields are Description, Handle, and PreferredChannelIds. For example:
INSERT INTO UserGroups (Name, PreferredChannelIds) VALUES ('newgroup', 'C5S8LAY0Y,C79J7PREU')
You can update a user group by providing the Id and you can update the UserIds, Name, Description, PreferredChannelIds, and Handle columns. Updates are only allowed for paid workspaces.
UPDATE UserGroups SET PreferredChannelIds = 'C5S8LAY0Y,C79J7PREU', Name = 'newname' WHERE Id = 'U4826PEF'
Slack does not support the deletion of user groups.
The Id of the User Group.
Indicates the friendly name of the group.
Explains the purpose of the group.
Identifier of the team this user group belongs to.
Contains a list of user id values that belong to the User Group.
Indicates the total number of users in a group.
Indicates the value used to notify group members via a mention without a leading @ sign.
Channels that members of this group will be invited to upon joining.
Groups (private channels) that members of this group will be invited to upon joining.
Represents this conversation as being externally shared.
Datetime of the creation of the user group.
Datetime that the user group became disabled.
Id of the user who created the user group.
Id of the user who last modified the user group.
Id of the user who disabled/archived the user group.
This parameter's value can be admins for a Workspace Admins group, owners for a Workspace Owners group or null for a custom group.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
A boolean set to include or exclude disabled User Groups in the retrieved data.