Table: clickup_team
Obtain information about teams you have access to in your ClickUp environment.
Examples
List all teams
select id, name, colorfrom clickup_team;
List all users for all teams
select t.name as team, u.username, u.email, u.last_activefrom clickup_team t left join clickup_team_member u on t.id = u.team_id
Schema for clickup_team
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
color | text | Color associated with the team. | |
id | text | Unique identifier for the team. | |
name | text | Name given to the team. |