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_assignee

Obtain information about assignees of a specific task.

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

Examples

Get assignees for a specific task

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

List assignees 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_assignee a
  left join some_tasks on a.task_id = some_tasks.id

Schema for clickup_task_assignee

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.