Retrieves the Do Not Disturb status for up to 50 users on a team.

View-Specific Information

SELECT

The connector uses the Slack API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.

• User supports the =, IN operators.
• TeamId supports the = operator.

The TeamInfo table requires the User column in the WHERE clause. If User is not specified, the connector automatically adds every user to the request and returns the DND status for all users.

TeamId is required when using an org-level token to specify the workspace.

Note: TeamId is only relevant when you connect with an org-level token. When you connect with a workspace-level token, the Slack API accepts the TeamId but ignores it and returns data for the authenticated workspace. Filtering on an invalid or empty TeamId therefore does not raise an error and does not return an empty result set.

For example, the following queries are processed server-side:

SELECT * FROM TeamInfo WHERE User = 'U01KZFNNTPC'

SELECT * FROM TeamInfo WHERE User IN ('U01KZFNNTPC','U04QTH44D9S')

SELECT * FROM TeamInfo WHERE TeamId = 'T01234ABCDE'

SELECT * FROM TeamInfo WHERE User = 'U01KZFNNTPC' AND TeamId = 'T01234ABCDE'

Columns

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.