steampipe plugin install theapsgroup/clickupsteampipe plugin install theapsgroup/clickup

clickup_folder clickup_folderless_list clickup_goal clickup_list clickup_list_member clickup_space clickup_task clickup_task_assignee clickup_task_watcher clickup_team clickup_team_member

Table: clickup_team_member

Obtain information about members of a specific team.

You MUST specify a team_id in the WHERE or JOIN clause.

Examples

Get members for a specific team

select
  id,
  username,
  email,
  color,
  profile_picture,
  initials,
  last_active,
  date_joined,
  date_invited
from
  clickup_team_member
where
  team_id = 21596865;

List all members for all teams you have access to

select
  t.id as team_id,
  t.name as team_name,
  t.color as team_color,
  m.id as member_id,
  m.username as member,
  m.email as member_email
from
  clickup_team t
  left join clickup_team_member m on t.id = m.team_id

Schema for clickup_team_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
color	text		Color associated with the user.
date_invited	timestamp with time zone		Timestamp when the user was invited to join the team.
date_joined	timestamp with time zone		Timestamp when the user actually joined the team.
email	text		Email address for the user.
id	bigint		Identifier for the user.
initials	text		The initials of the user.
last_active	timestamp with time zone		Timestamp when the user was last active.
profile_picture	text		URL for the profile picture of the user.
team_id	text	=	Unique identifier for the team.
username	text		Username for the user.