steampipe plugin install theapsgroup/clickupsteampipe plugin install theapsgroup/clickup

Table: clickup_list_member

Obtain information about members of a list within your ClickUp environment.

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

Examples

select
  id,
  username,
  email,
  color,
  profile_picture,
  initials
from
  clickup_list_member
where
  list_id = '9429v3v2390'

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
color	text		The color associated with the user.
email	text		Email address of the user.
id	bigint		Unique Identifier of the user.
initials	text		Initials of the user.
list_id	text	=	Identifier for the list the user is a member of.
profile_picture	text		URL of the profile picture for the user.
username	text		Username of the user.