ExternalTeams
Returns a list of all the external teams connected and details about the connection.
Select
The ExternalTeams view returns the external organizations connected to the current Slack Enterprise org. The ConnectionStatus column is processed server side with the = operator. The SlackConnectPrefFilter and WorkspaceFilter pseudo columns are also pushed to the server. All other filters are processed client side. Results are returned in Slack's default order (team_name ascending); client-side ORDER BY is supported via SQL but operates per-page when combined with cursor pagination.
SELECT * FROM ExternalTeams SELECT TeamId, TeamName, TeamDomain, ConnectionStatus, LastActiveTimestamp FROM ExternalTeams SELECT * FROM ExternalTeams WHERE ConnectionStatus = 'CONNECTED' SELECT * FROM ExternalTeams WHERE ConnectionStatus = 'BLOCKED'
Filtering by Workspace
WorkspaceFilter narrows results to external orgs connected on a specific encoded workspace Id.
SELECT * FROM ExternalTeams WHERE WorkspaceFilter = 'T0123ABCD'
Filtering by Slack Connect Preference
SlackConnectPrefFilter narrows results to external orgs that have a specific Slack Connect preference override. Acceptable values are approved_orgs_only, allow_sc_file_uploads, profile_visibility, away_team_sc_invite_permissions, accept_sc_invites, sc_mpdm_to_private, require_sc_channel_for_sc_dm, and external_awareness_context_bar.
SELECT * FROM ExternalTeams WHERE SlackConnectPrefFilter = 'approved_orgs_only'
Nested Columns
The ConnectedWorkspaces, SlackConnectPrefs, Canvas, and Lists columns are returned as JSON strings. ConnectedWorkspaces is an array of objects with workspace_id and workspace_name fields. Canvas and Lists each contain total_count and ownership_details fields summarising shared canvases and lists respectively.
Limitations
This method is only available on Slack workspaces using the Enterprise plan. The conversations.connect:manage and team:read scopes are required on the bot token.
Columns
| Name | Type | References | Description |
| TeamId [KEY] | String |
Team.Id | The Id of the external team. |
| TeamName | String | The name of the external team. | |
| TeamDomain | String | The domain of the external team. | |
| PublicChannelCount | Integer | Number of public channels shared with the external team. | |
| PrivateChannelCount | Integer | Number of private channels shared with the external team. | |
| ImChannelCount | Integer | Number of direct-message channels shared with the external team. | |
| MpimChannelCount | Integer | Number of multi-party direct-message channels shared with the external team. | |
| ConnectionStatus | String | Status of the connection with the external team.
The allowed values are CONNECTED, DISCONNECTED, BLOCKED, IN_REVIEW. | |
| LastActiveTimestamp | Datetime | Unix timestamp of the most recent activity in any channel shared with the external team. | |
| IsSponsored | Boolean | Indicates whether the connection with the external team is sponsored. | |
| ConnectedWorkspaces | String | Workspaces in the current organization connected to the external team. Returned as a JSON array of objects containing workspace_id and workspace_name. | |
| SlackConnectPrefs | String | Slack Connect preferences configured for the external team. Returned as a JSON object. | |
| Canvas | String | Canvas sharing summary for the external team. Returned as a JSON object containing total_count and ownership_details. | |
| Lists | String | Slack List sharing summary for the external team. Returned as a JSON object containing total_count and ownership_details. |
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.
| Name | Type | Description | |
| SlackConnectPrefFilter | String | Filters connected orgs by Slack Connect preference override.
The allowed values are approved_orgs_only, allow_sc_file_uploads, profile_visibility, away_team_sc_invite_permissions, accept_sc_invites, sc_mpdm_to_private, require_sc_channel_for_sc_dm, external_awareness_context_bar. | |
| WorkspaceFilter | String | Filters connected orgs by a specified encoded workspace Id. |