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_space

Obtain information about the spaces within your ClickUp environment.

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

Note: In the event of using the space id to obtain a single entity, the team_id field will be null as no value is returned by the API.

Examples

Get a space by id

select
  id,
  name,
  private,
  sprints,
  tags,
  milestones
from
  clickup_space
where
  id = '7423465';

List all spaces for a specific team

select
  id,
  name,
  private,
  sprints,
  tags,
  milestones,
  statuses,
  multiple_assignees,
  due_dates,
  points,
  time_estimates,
  time_tracking,
  archived
from
  clickup_space
where
  team_id = '969532885';

List spaces which do not have the sprints features enabled

select
  id,
  name,
  private,
  sprints,
  tags,
  milestones,
  statuses,
  multiple_assignees,
  due_dates,
  points,
  time_estimates,
  time_tracking,
  archived
from
  clickup_space
where
  team_id = '969532885'
  and sprints = false;

Schema for clickup_space

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
archived	boolean		Indicates if the space is archived.
custom_items	boolean		Indicates if the space has custom items enabled.
due_dates	boolean		Indicates if the space has due dates enabled.
id	text	=	Unique identifier for the space.
milestones	boolean		Indicates if the space has milestones enabled.
multiple_assignees	boolean		Indicates if the space supports multiple assignees to tasks, etc.
name	text		The name of the space.
points	boolean		Indicates if the space has points enabled.
private	boolean		Indicates if the space is designated as a private space.
sprints	boolean		Indicates if the space has sprints enabled.
statuses	jsonb		An array os statuses available on the space.
tags	boolean		Indicates if the space has tags enabled.
team_id	text	=
time_estimates	boolean		Indicates if the space has time estimates enabled.
time_tracking	boolean		Indicates if the space has time tracking enabled.