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_watcher

Obtain information about watchers of a specific task.

You MUST specify a task_id in the WHERE or JOIN clause.

Get watchers for a specific task

select
  id,
  username,
  email,
  color,
  profile_picture,
  initials
from
  clickup_task_watcher
where
  task_id = '4g9milk'

List watchers for a selection of tasks

with some_tasks as (
  select
    t.id
  from
    clickup_task t
  where
    t.list_id = 'xczx34'
  order by
    id desc
  limit
    10
)
select
  id,
  username,
  email,
  color,
  profile_picture,
  initials,
  task_id
from
  clickup_task_watcher w
  left join some_tasks on w.task_id = some_tasks.id

Schema for clickup_task_watcher

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
color	text		Color associated with the task assignee.
email	text		Email address for the task assignee.
id	bigint		Identifier for the task assignee.
initials	text		The initials of the task assignee.
profile_picture	text		URL for the profile picture of the task assignee.
task_id	text	=	Unique identifier for the task.
username	text		Username for the task assignee.