v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →
Steampipe logo 
Hub
Plugins
theapsgroup/clickup
Overview
11Tables
Versions
GitHub
steampipe plugin install theapsgroup/clickup

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
archivedbooleanIndicates if the space is archived.
custom_itemsbooleanIndicates if the space has custom items enabled.
due_datesbooleanIndicates if the space has due dates enabled.
idtext=Unique identifier for the space.
milestonesbooleanIndicates if the space has milestones enabled.
multiple_assigneesbooleanIndicates if the space supports multiple assignees to tasks, etc.
nametextThe name of the space.
pointsbooleanIndicates if the space has points enabled.
privatebooleanIndicates if the space is designated as a private space.
sprintsbooleanIndicates if the space has sprints enabled.
statusesjsonbAn array os statuses available on the space.
tagsbooleanIndicates if the space has tags enabled.
team_idtext=
time_estimatesbooleanIndicates if the space has time estimates enabled.
time_trackingbooleanIndicates if the space has time tracking enabled.