ClickUp Connector Reference

10 metrics128 dimensions

Fields

The ClickUp connector exposes 138 fields (10 metrics, 128 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

ClickUp Fields

ClickUp folder fields

The folder report of the ClickUp connector includes 8 fields.

ID	Type	Name	Description
folder__hidden	BOOLEAN	folder.hidden	folder.hidden
folder__id	TEXT	folder.id	folder.id
folder__lists	OBJECT	folder.lists	folder.lists
folder__name	TEXT	folder.name	folder.name
folder__orderindex	NUMERIC	folder.orderindex	folder.orderindex
folder__override_statuses	BOOLEAN	folder.override_statuses	folder.override_statuses
folder__space	OBJECT	folder.space	folder.space
folder__task_count	TEXT	folder.task_count	folder.task_count

ClickUp General fields

The General report of the ClickUp connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The unique identifier for the account.
account_name	TEXT	Account Name	The name of the account.
date	DATE	Date	The date of the record.

ClickUp list fields

The list report of the ClickUp connector includes 15 fields.

ID	Type	Name	Description
list__archived	BOOLEAN	list.archived	list.archived
list__assignee	TEXT	list.assignee	list.assignee
list__content	TEXT	list.content	list.content
list__due_date	DATE	list.due_date	list.due_date
list__folder	OBJECT	list.folder	list.folder
list__id	TEXT	list.id	list.id
list__name	TEXT	list.name	list.name
list__orderindex	NUMERIC	list.orderindex	list.orderindex
list__override_statuses	BOOLEAN	list.override_statuses	list.override_statuses
list__permission_level	TEXT	list.permission_level	list.permission_level
list__priority	TEXT	list.priority	list.priority
list__space	OBJECT	list.space	list.space
list__start_date	DATE	list.start_date	list.start_date
list__status	OBJECT	list.status	list.status
list__task_count	NUMERIC	list.task_count	list.task_count

ClickUp list_comments fields

The list_comments report of the ClickUp connector includes 7 fields.

ID	Type	Name	Description
list_comments__comment	OBJECT	list_comments.comment	list_comments.comment
list_comments__comment_text	TEXT	list_comments.comment_text	list_comments.comment_text
list_comments__date	TEXT	list_comments.date	list_comments.date
list_comments__id	TEXT	list_comments.id	list_comments.id
list_comments__reactions	OBJECT	list_comments.reactions	list_comments.reactions
list_comments__reply_count	NUMERIC	list_comments.reply_count	list_comments.reply_count
list_comments__user	OBJECT	list_comments.user	list_comments.user

ClickUp list_custom_fields fields

The list_custom_fields report of the ClickUp connector includes 7 fields.

ID	Type	Name	Description
list_custom_fields__date_created	TEXT	list_custom_fields.date_created	list_custom_fields.date_created
list_custom_fields__hide_from_guests	BOOLEAN	list_custom_fields.hide_from_guests	list_custom_fields.hide_from_guests
list_custom_fields__id	TEXT	list_custom_fields.id	list_custom_fields.id
list_custom_fields__name	TEXT	list_custom_fields.name	list_custom_fields.name
list_custom_fields__required	BOOLEAN	list_custom_fields.required	list_custom_fields.required
list_custom_fields__type	TEXT	list_custom_fields.type	list_custom_fields.type
list_custom_fields__type_config	OBJECT	list_custom_fields.type_config	list_custom_fields.type_config

ClickUp space fields

The space report of the ClickUp connector includes 7 fields.

ID	Type	Name	Description
space__assignees	OBJECT	space.assignees	space.assignees
space__features	OBJECT	space.features	space.features
space__id	TEXT	space.id	space.id
space__multiple_assignees	BOOLEAN	space.multiple_assignees	space.multiple_assignees
space__name	TEXT	space.name	space.name
space__private	BOOLEAN	space.private	space.private
space__statuses	OBJECT	space.statuses	space.statuses

ClickUp space_tags fields

The space_tags report of the ClickUp connector includes 5 fields.

ID	Type	Name	Description
space_tags__creator	NUMERIC	space_tags.creator	space_tags.creator
space_tags__name	TEXT	space_tags.name	space_tags.name
space_tags__project_id	TEXT	space_tags.project_id	space_tags.project_id
space_tags__tag_bg	TEXT	space_tags.tag_bg	space_tags.tag_bg
space_tags__tag_fg	TEXT	space_tags.tag_fg	space_tags.tag_fg

ClickUp task fields

The task report of the ClickUp connector includes 22 fields.

ID	Type	Name	Description
task__assignees	OBJECT	task.assignees	task.assignees
task__checklists	OBJECT	task.checklists	task.checklists
task__creator	OBJECT	task.creator	task.creator
task__date_closed	DATE	task.date_closed	task.date_closed
task__date_created	DATE	task.date_created	task.date_created
task__date_done	DATE	task.date_done	task.date_done
task__date_updated	DATE	task.date_updated	task.date_updated
task__due_date	DATE	task.due_date	task.due_date
task__folder	OBJECT	task.folder	task.folder
task__id	TEXT	task.id	task.id
task__list	OBJECT	task.list	task.list
task__name	TEXT	task.name	task.name
task__orderindex	TEXT	task.orderindex	task.orderindex
task__parent	TEXT	task.parent	task.parent
task__priority	OBJECT	task.priority	task.priority
task__space	OBJECT	task.space	task.space
task__start_date	DATE	task.start_date	task.start_date
task__status	OBJECT	task.status	task.status
task__tags	OBJECT	task.tags	task.tags
task__time_estimate	TIMESTAMP	task.time_estimate	task.time_estimate
task__time_spent	TIMESTAMP	task.time_spent	task.time_spent
task__url	TEXT	task.url	task.url

ClickUp team fields

The team report of the ClickUp connector includes 5 fields.

ID	Type	Name	Description
team__avatar	TEXT	team.avatar	team.avatar
team__color	TEXT	team.color	team.color
team__id	TEXT	team.id	team.id
team__members	OBJECT	team.members	team.members
team__name	TEXT	team.name	team.name

ClickUp team_custom_fields fields

The team_custom_fields report of the ClickUp connector includes 7 fields.

ID	Type	Name	Description
team_custom_fields__date_created	TEXT	team_custom_fields.date_created	team_custom_fields.date_created
team_custom_fields__hide_from_guests	BOOLEAN	team_custom_fields.hide_from_guests	team_custom_fields.hide_from_guests
team_custom_fields__id	TEXT	team_custom_fields.id	team_custom_fields.id
team_custom_fields__name	TEXT	team_custom_fields.name	team_custom_fields.name
team_custom_fields__required	BOOLEAN	team_custom_fields.required	team_custom_fields.required
team_custom_fields__type	TEXT	team_custom_fields.type	team_custom_fields.type
team_custom_fields__type_config	OBJECT	team_custom_fields.type_config	team_custom_fields.type_config

ClickUp team_goals fields

The team_goals report of the ClickUp connector includes 21 fields.

ID	Type	Name	Description
team_goals__archived	BOOLEAN	team_goals.archived	team_goals.archived
team_goals__color	TEXT	team_goals.color	team_goals.color
team_goals__creator	NUMERIC	team_goals.creator	team_goals.creator
team_goals__date_created	TEXT	team_goals.date_created	team_goals.date_created
team_goals__date_updated	TEXT	team_goals.date_updated	team_goals.date_updated
team_goals__description	TEXT	team_goals.description	team_goals.description
team_goals__due_date	TEXT	team_goals.due_date	team_goals.due_date
team_goals__editor_token	TEXT	team_goals.editor_token	team_goals.editor_token
team_goals__group_members	OBJECT	team_goals.group_members	team_goals.group_members
team_goals__id	TEXT	team_goals.id	team_goals.id
team_goals__key_result_count	NUMERIC	team_goals.key_result_count	team_goals.key_result_count
team_goals__last_update	TEXT	team_goals.last_update	team_goals.last_update
team_goals__members	OBJECT	team_goals.members	team_goals.members
team_goals__multiple_owners	BOOLEAN	team_goals.multiple_owners	team_goals.multiple_owners
team_goals__name	TEXT	team_goals.name	team_goals.name
team_goals__owners	OBJECT	team_goals.owners	team_goals.owners
team_goals__percent_completed	NUMERIC	team_goals.percent_completed	team_goals.percent_completed
team_goals__pinned	BOOLEAN	team_goals.pinned	team_goals.pinned
team_goals__pretty_id	TEXT	team_goals.pretty_id	team_goals.pretty_id
team_goals__private	BOOLEAN	team_goals.private	team_goals.private
team_goals__team_id	TEXT	team_goals.team_id	team_goals.team_id

ClickUp time_tracking fields

The time_tracking report of the ClickUp connector includes 3 fields.

ID	Type	Name	Description
time_tracking__intervals	OBJECT	time_tracking.intervals	time_tracking.intervals
time_tracking__time	NUMERIC	time_tracking.time	time_tracking.time
time_tracking__user	OBJECT	time_tracking.user	time_tracking.user

ClickUp time_tracking_tags fields

The time_tracking_tags report of the ClickUp connector includes 5 fields.

ID	Type	Name	Description
time_tracking_tags__creator	NUMERIC	time_tracking_tags.creator	time_tracking_tags.creator
time_tracking_tags__name	TEXT	time_tracking_tags.name	time_tracking_tags.name
time_tracking_tags__tag_bg	TEXT	time_tracking_tags.tag_bg	time_tracking_tags.tag_bg
time_tracking_tags__tag_fg	TEXT	time_tracking_tags.tag_fg	time_tracking_tags.tag_fg
time_tracking_tags__team_id	TEXT	time_tracking_tags.team_id	time_tracking_tags.team_id

ClickUp user fields

The user report of the ClickUp connector includes 5 fields.

ID	Type	Name	Description
user__color	TEXT	user.color	user.color
user__id	TEXT	user.id	user.id
user__profilepicture	TEXT	user.profilePicture	user.profilePicture
user__user	OBJECT	user.user	user.user
user__username	TEXT	user.username	user.username

ClickUp other fields

The ClickUp connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors