steampipe plugin install theapsgroup/clickupsteampipe plugin install theapsgroup/clickup

Table: clickup_folder

Obtain information about folders within your ClickUp environment.

However you MUST specify either an id (single) or space_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

select
  id,
  name,
  order_index,
  hidden,
  space_id,
  task_count,
  archived
from
  clickup_folder
where
  id = '7fsd72'

select
  id,
  name,
  order_index,
  hidden,
  space_id,
  task_count,
  archived
from
  clickup_folder
where
  space_id = '54649813'

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
archived	boolean	=	Indicates if the folder is archived.
hidden	boolean		Indicates if the folder is hidden.
id	text	=	Unique identifier for the folder.
name	text		Name of the given folder.
order_index	bigint		The order index of the folder.
override_statuses	boolean		Indicates if statuses can be overriden within the folder.
space_id	text	=	Unique identifier of the space to which the folder belongs.
statuses	jsonb		An array of status objects for the valid statuses within the folder.
task_count	bigint		Count of tasks within the folder.