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_task

Obtain information about tasks assigned to a specific team within your ClickUp environment.

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

Get a task by id

select
  id,
  name,
  description,
  creator,
  status,
  priority
from
  clickup_task
where
  id = '69xca6m';

List all tasks for a specific list

select
  id,
  status,
  date_created,
  date_closed,
  due_date,
  team_id,
  project_id
from
  clickup_task
where
  list_id = '19306756';

List all tasks for a specific team

select
  id,
  status,
  date_created,
  date_closed,
  due_date,
  team_id,
  project_id
from
  clickup_task
where
  team_id = '2506756';

Obtain tasks for a team that are of a specific status

select
  id,
  status,
  date_created,
  date_closed,
  due_date,
  team_id,
  space_id,
  list_id,
  folder_id
from
  clickup_task
where
  team_id = '2506756'
  and status = 'planned';

Schema for clickup_task

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
archived	boolean	=	Indicates if the task is archived.
creator	text		Username of the user whom created the task.
creator_email	text		Email address of the user whom created the task.
creator_id	bigint		Identifier for the user whom created the task.
custom_id	text		Custom identifier for the task.
date_closed	timestamp with time zone		Timestamp when the task was closed.
date_created	timestamp with time zone		Timestamp when the task was created.
date_updated	timestamp with time zone		Timestamp when the task was last updated.
dependencies	jsonb		An array of task dependencies.
description	text		The description on the task.
due_date	text		Timestamp when the task is due.
folder	text		Name of the folder the task belongs to.
folder_id	text		Identifier of the folder the task belongs to.
id	text	=	Unique string identifier for the task.
linked_tasks	jsonb		An array of json objects to identify linked tasks.
list	text		Name of the list the task belongs to.
list_id	text	=	Identifier of the list the task belongs to.
name	text		Name given to the task.
order_index	text		Order index of the task.
parent	text		Unique identifier for the parent task.
permission_level	text		Permission level associated to the task.
points	bigint		Points attributed to the task.
priority	text		The priority of the task.
project	text		Name of the project the task belongs to.
project_id	text		Identifier of the project the task belongs to.
space_id	text		Identifier of the space the task belongs to.
start_date	timestamp with time zone		Timestamp when work on the task was started.
status	text	=	Current status of the task.
tags	jsonb		An array of tags associated with the task.
team_id	text	=	Unique identifier for the team associated with the task.
text_content	text		The textual content of the task.
time_estimate	bigint		Estimate (in ms) of how long is required to complete the task.
url	text		Direct URL to the task.