steampipe plugin install theapsgroup/clickup

Table: clickup_team

Obtain information about teams you have access to in your ClickUp environment.

Examples

List all teams

select
id,
name,
color
from
clickup_team;

List all users for all teams

select
t.name as team,
u.username,
u.email,
u.last_active
from
clickup_team t
left join clickup_team_member u on t.id = u.team_id

Schema for clickup_team

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
colortextColor associated with the team.
idtextUnique identifier for the team.
nametextName given to the team.