ClickUp Tables

Tables

ClickUpFolders

Represents folder entities under spaces that help organize related lists and tasks for structured project management.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ID	string	Unique identifier of the folder as provided by ClickUp.
Name	string	Display name of the ClickUp folder.
Orderindex	integer	Ordering index of the folder within its parent space.
OverrideStatuses	boolean	Indicator specifying whether the folder overrides space-level statuses.
Hidden	boolean	Indicator specifying whether the folder is hidden.
TaskCount	integer	Number of tasks contained within the ClickUp folder.
Archived	boolean	Indicator specifying whether the folder is archived.
ListStatuses	string	Status configuration applied to lists within the folder.
PermissionLevel	string	Permission level assigned to the ClickUp folder.
ClickUpSpaceID	string	Unique identifier of the ClickUp space associated with the folder.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed.

ClickUpGoals

Contains goal objects used to track high-level objectives and key results across tasks and projects in ClickUp.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ID	string	Unique identifier of the goal as provided by ClickUp.
PrettyId	string	Human-readable identifier for the ClickUp goal.
Name	string	Display name of the ClickUp goal.
Creator	integer	Unique identifier of the user who created the goal.
OwnerId	integer	Unique identifier of the primary owner of the goal.
OwnerUsername	string	Username of the goal owner.
OwnerEmail	string	Email address of the goal owner.
OwnerColor	string	Primary color associated with the goal owner’s profile.
OwnerPermissionLevel	string	Permission level assigned to the goal owner.
OwnerProfilePicture	string	URL to the goal owner’s profile picture.
OwnerInitials	string	Initials derived from the goal owner’s name.

ClickUpLists

Represents ordered collections of related tasks, typically organized within folders or directly under spaces.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ID	string	Unique identifier of the list as provided by ClickUp.
Name	string	Display name of the ClickUp list.
Orderindex	integer	Ordering index of the list within its parent container.
Content	string	Content or description associated with the ClickUp list.
Status	string	Default or current status configuration of the ClickUp list.
Priority	string	Default priority setting applied to tasks within the list.
Assignee	string	Default assignee applied to tasks within the list, if defined.
TaskCount	integer	Number of tasks contained within the ClickUp list.
DueDate	datetime	Due date applied to the ClickUp list, if defined.
StartDate	datetime	Start date applied to the ClickUp list, if defined.
FolderName	string	Name of the folder containing the ClickUp list.

ClickUpSpaces

Defines top-level project containers within a team, grouping folders, lists, and other child resources in ClickUp.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ID	string	Unique identifier of the space as provided by ClickUp.
Name	string	Display name of the ClickUp space.
Color	string	Primary color associated with the ClickUp space.
Private	boolean	Indicator specifying whether the space is private.
Avatar	string	URL to the avatar image associated with the ClickUp space.
AdminCanManage	boolean	Indicator specifying whether admins can manage the space.
ListStatus	string	Configuration settings defining task statuses within the space.
MultipleAssignees	boolean	Indicator specifying whether multiple assignees are allowed for tasks in the space.
Archived	boolean	Indicator specifying whether the space is archived.
ClickUpTeamID	string	Unique identifier of the ClickUp team associated with the space.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed.

ClickUpTaskAssignees

Lists users assigned to specific tasks, defining who is responsible for completing or collaborating on work items.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ClickUpUserID	integer	Unique identifier of the ClickUp user assigned to the task.
ClickUpTaskID	string	Unique identifier of the ClickUp task assigned to the user.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed.

ClickUpTaskWatchers

Stores watcher assignments for tasks, indicating which users are subscribed to receive updates about changes to specific tasks.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ClickUpUserID	integer	Unique identifier of the ClickUp user watching the task.
ClickUpTaskID	string	Unique identifier of the ClickUp task being watched by the user.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed.

ClickUpTasks

Represents individual tasks in ClickUp, including details such as description, status, assignments, due dates, and other task metadata.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ID	string	Unique identifier of the task as provided by ClickUp.
CustomItemId	integer	Identifier of the custom item associated with the task, if applicable.
Name	string	Name or title of the ClickUp task.
TextContent	string	Plain text content associated with the ClickUp task.
Description	string	Detailed description of the ClickUp task.
StatusName	string	Name of the current status assigned to the task.
StatusId	string	Unique identifier of the task’s current status.
StatusColor	string	Color associated with the task’s current status.
StatusType	string	Type or category of the task’s current status.
StatusOrderindex	integer	Ordering index of the task’s status within its workflow.
Orderindex	string	Ordering index of the task within its list.

ClickUpTeamMembers

Defines the association between ClickUp users and the teams they belong to, including roles and access context within each team.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ClickUpUserID	integer	Unique identifier of the ClickUp user associated with the team.
ClickUpTeamID	string	Unique identifier of the ClickUp team associated with the user.
ClickUpUserConfigID	integer	Identifier linking the user record to its specific ClickUp configuration.
ClickUpTeamConfigID	integer	Identifier linking the team record to its specific ClickUp configuration.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed.

ClickUpTeams

Represents team entities (workspaces or collaborative groups) in ClickUp, used to organize users and work across shared projects.

Name	Type	Description
ConfigID	integer	Identifier linking the record to a specific ClickUp configuration or integration setup.
ID	string	Unique identifier of the team as provided by ClickUp.
Name	string	Display name of the ClickUp team.
Color	string	Primary color associated with the ClickUp team.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed.

ClickUpUsers