v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Hub

Plugins Mods Docs Home

Plugins

theapsgroup/clickup

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_goal

Obtain information about folders within your ClickUp environment.

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

Examples

Get a specific goal by id

select
  id,
  pretty_id,
  name,
  team_id,
  folder_id,
  date_created,
  start_date,
  due_date,
  date_updated,
  private,
  archived,
  pinned,
  percent_complete
from
  clickup_goal
where
  id = 'v47b5vb'

List goals for a specific team

select
  id,
  pretty_id,
  name,
  team_id,
  folder_id,
  date_created,
  start_date,
  due_date,
  date_updated,
  private,
  archived,
  pinned,
  percent_complete
from
  clickup_goal
where
  team_id = '46446546'

Schema for clickup_goal

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
archived	boolean		Indicates if the goal is archived.
color	text		The color associated with the goal.
creator_id	bigint		Identifier for the user whom created the goal.
date_created	timestamp with time zone		Timestamp when the goal was created.
date_updated	timestamp with time zone		Timestamp when the goal was last updated.
description	text		Textual description of the goal.
due_date	timestamp with time zone		Timestamp when the goal is due.
folder_id	text		identifier for the folder of the goal.
id	text	=	Unique identifier for the goal.
multiple_owners	boolean		Indicates if the goal has/supports multiple owners.
name	text		The name of the given goal.
owner_email	text		Email address for the user designated as the owner of the goal.
owner_id	bigint		Identifier for the user designated as the owner of the goal.
owner_username	text		Username of the user designated as the owner of the goal.
owners	jsonb		An array of owners if multiple owners are assigned to the goal.
percent_completed	double precision		Numeric representation of how complete the goal is.
pinned	boolean		Indicates if the goal is pinned.
pretty_id	text		Pretty identifier for the goal.
private	boolean		Indicates if the goal is private.
start_date	timestamp with time zone		Timestamp when work on the goal was started.
team_id	text	=	Identifier for the team to which the goal is assigned.