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_list

Obtain information about lists within your ClickUp environment.

However you MUST specify either an id (single) or folder_id (for multiple tasks) in the WHERE or JOIN clause.

Note: by default archived items won't be returned, to return archived items only set archived = true in the where clause.

Examples

Get a list by id

select
  id,
  name,
  order_index,
  content,
  status,
  priority,
  assignee,
  task_count,
  due_date,
  start_date,
  folder,
  space,
  archived
from
  clickup_list
where
  id = '6fs7dfm';

List lists for a specific folder

select
  id,
  name,
  order_index,
  content,
  status,
  priority,
  assignee,
  task_count,
  due_date,
  start_date,
  folder,
  space,
  archived
from
  clickup_list
where
  folder_id = 's6fsd8fds';

Schema for clickup_list

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
archived	boolean	=	Indicates if the list is archived.
assignee	text		Username of the user to whom the list is assigned.
assignee_email	text		Email address of the user to whom the list is assigned.
assignee_id	bigint		Unique identifier of the user to whom the list is assigned.
content	text		Content description of the list.
due_date	timestamp with time zone		Timestamp when the list is due.
folder	text		Name of the folder the list belongs to.
folder_id	text	=	Unique identifier of the folder the list belongs to.
id	text	=	Unique identifier for the list.
name	text		Name of the list.
order_index	bigint		Order index of the list.
priority	text		Priority of the list.
space	text		Name of the space the list belongs to.
space_id	text		Unique identifier of the space the list belongs to.
start_date	timestamp with time zone		Timestamp when work on the list was started.
status	text		Status of the list.
statuses	jsonb		An array of status objects for available statuses within the list.
task_count	text		Count of tasks on the list.