Schema Information

This subtopic provides a structured reference to assist you in working with Daton's ClickUp connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the ClickUp connector:

• Teams

• Spaces

• Folders

• Lists

• Folderless Lists

• Tasks

• Task Status History

• Goals

Teams

The Teams API allows you to manage and interact with teams in your ClickUp workspace. You can create, retrieve, update, and delete teams, facilitating team collaboration and organization.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
color	STRING
avatar	STRING
members	RECORD

Spaces

The Spaces API enables you to manage spaces within ClickUp, which serve as high-level categories for organizing your projects and tasks.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
color	STRING
private	BOOLEAN
avatar	STRING
statuses	RECORD
multiple_assignees	BOOLEAN
features	RECORD
archived	BOOLEAN

Folders

With the Folders API, you can manage folders within spaces, providing an additional layer of organization for your projects and tasks.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
orderindex	NUMERIC
override_statuses	BOOLEAN
hidden	BOOLEAN
space	RECORD
task_count	STRING
archived	BOOLEAN
lists	RECORD
permission_level	STRING

Lists

The Lists API allows you to manage lists within folders, representing specific project or task lists.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
orderindex	NUMERIC
status	STRING
assignee	STRING
task_count	NUMERIC
due_date	STRING
start_date	STRING
folder	RECORD
space	RECORD
archived	BOOLEAN
override_statuses	BOOLEAN
permission_level	STRING

Folderless Lists

Folderless Lists are lists that exist outside of folders. The Folderless Lists API lets you manage these lists independently, facilitating flexible task management without folder constraints.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
orderindex	NUMERIC
status	STRING
assignee	STRING
task_count	NUMERIC
due_date	STRING
start_date	STRING
folder	RECORD
space	RECORD
archived	BOOLEAN
override_statuses	BOOLEAN
permission_level	STRING

Tasks

The Tasks API provides comprehensive control over tasks within ClickUp. You can create, retrieve, update, and delete tasks, as well as perform various task-related actions, empowering efficient task management.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
name	STRING
status	RECORD
orderindex	STRING
date_created	STRING
date_updated	STRING
date_closed	STRING
date_done	STRING
archived	BOOLEAN
creator	RECORD
assignees	RECORD
parent	STRING
priority	RECORD
due_date	STRING
start_date	STRING
time_estimate	NUMERIC
time_spent	NUMERIC
custom_fields	RECORD
team_id	STRING
url	STRING
sharing	RECORD
permission_level	STRING
list	RECORD
project	RECORD
folder	RECORD
space	RECORD

Task Status History

The Task Status History API enables you to track and retrieve historical changes in task statuses. This data helps you analyze task progression and monitor changes over time for reporting and analysis.

For more information, see the link.

FIELDS

Field Name	Data Type
status	STRING
color	STRING
type	STRING
total_time	RECORD
orderindex	NUMERIC
task_id	STRING

Goals

The Goals API allows you to manage goals within ClickUp, providing a structured approach to setting and tracking objectives.

For more information, see the link.

FIELDS

Field Name	Data Type
id	STRING
pretty_id	STRING
name	STRING
team_id	STRING
creator	NUMERIC
color	STRING
date_created	STRING
due_date	STRING
description	STRING
private	BOOLEAN
archived	BOOLEAN
multiple_owners	BOOLEAN
editor_token	STRING
date_updated	STRING
last_update	STRING
pinned	BOOLEAN
owners	RECORD
key_result_count	NUMERIC
percent_completed	BIGNUMERIC