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_folderless_list

Obtain information about lists that aren't associated to folders within your ClickUp environment.

However you MUST specify a space_id 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

List lists for a space that are not associated with a folder.

select
  id,
  name,
  order_index,
  content,
  status,
  priority,
  assignee,
  task_count,
  due_date,
  start_date,
  folder,
  space,
  archived
from
  clickup_folderless_list
where
  space_id = '7423465';

Schema for clickup_folderless_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.