# Schema Information

## Tables/APIs 

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

* [Teams](#teams) 
* [Spaces](#spaces) 
* [Folders](#folders) 
* [Lists](#lists) 
* [Folderless Lists ](#folderless-lists)
* [Tasks](#tasks) 
* [Task Status History ](#task-status-history)
* [Goals](#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](https://clickup.com/api/clickupreference/operation/GetAuthorizedTeams/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>avatar</td><td>STRING</td></tr><tr><td>members</td><td>RECORD</td></tr></tbody></table>

### Spaces&#x20;

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](https://clickup.com/api/clickupreference/operation/GetSpaces/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>private</td><td>BOOLEAN</td></tr><tr><td>avatar</td><td>STRING</td></tr><tr><td>statuses</td><td>RECORD</td></tr><tr><td>multiple_assignees</td><td>BOOLEAN</td></tr><tr><td>features</td><td>RECORD</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr></tbody></table>

### Folders&#x20;

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](https://clickup.com/api/clickupreference/operation/GetFolders/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>orderindex</td><td>NUMERIC</td></tr><tr><td>override_statuses</td><td>BOOLEAN</td></tr><tr><td>hidden</td><td>BOOLEAN</td></tr><tr><td>space</td><td>RECORD</td></tr><tr><td>task_count</td><td>STRING</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr><tr><td>lists</td><td>RECORD</td></tr><tr><td>permission_level</td><td>STRING</td></tr></tbody></table>

### Lists&#x20;

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

For more information, see the [link](https://clickup.com/api/clickupreference/operation/GetLists/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>orderindex</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>assignee</td><td>STRING</td></tr><tr><td>task_count</td><td>NUMERIC</td></tr><tr><td>due_date</td><td>STRING</td></tr><tr><td>start_date</td><td>STRING</td></tr><tr><td>folder</td><td>RECORD</td></tr><tr><td>space</td><td>RECORD</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr><tr><td>override_statuses</td><td>BOOLEAN</td></tr><tr><td>permission_level</td><td>STRING</td></tr></tbody></table>

### Folderless Lists&#x20;

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](https://clickup.com/api/clickupreference/operation/GetFolderlessLists/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>orderindex</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>assignee</td><td>STRING</td></tr><tr><td>task_count</td><td>NUMERIC</td></tr><tr><td>due_date</td><td>STRING</td></tr><tr><td>start_date</td><td>STRING</td></tr><tr><td>folder</td><td>RECORD</td></tr><tr><td>space</td><td>RECORD</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr><tr><td>override_statuses</td><td>BOOLEAN</td></tr><tr><td>permission_level</td><td>STRING</td></tr></tbody></table>

### Tasks&#x20;

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](https://clickup.com/api/clickupreference/operation/GetTasks/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>status</td><td>RECORD</td></tr><tr><td>orderindex</td><td>STRING</td></tr><tr><td>date_created</td><td>STRING</td></tr><tr><td>date_updated</td><td>STRING</td></tr><tr><td>date_closed</td><td>STRING</td></tr><tr><td>date_done</td><td>STRING</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr><tr><td>creator</td><td>RECORD</td></tr><tr><td>assignees</td><td>RECORD</td></tr><tr><td>parent</td><td>STRING</td></tr><tr><td>priority</td><td>RECORD</td></tr><tr><td>due_date</td><td>STRING</td></tr><tr><td>start_date</td><td>STRING</td></tr><tr><td>time_estimate</td><td>NUMERIC</td></tr><tr><td>time_spent</td><td>NUMERIC</td></tr><tr><td>custom_fields</td><td>RECORD</td></tr><tr><td>team_id</td><td>STRING</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>sharing</td><td>RECORD</td></tr><tr><td>permission_level</td><td>STRING</td></tr><tr><td>list</td><td>RECORD</td></tr><tr><td>project</td><td>RECORD</td></tr><tr><td>folder</td><td>RECORD</td></tr><tr><td>space</td><td>RECORD</td></tr></tbody></table>

### Task Status History&#x20;

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](https://clickup.com/api/clickupreference/operation/GetBulkTasks'TimeinStatus/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>status</td><td>STRING</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>total_time</td><td>RECORD</td></tr><tr><td>orderindex</td><td>NUMERIC</td></tr><tr><td>task_id</td><td>STRING</td></tr></tbody></table>

### 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](https://clickup.com/api/clickupreference/operation/GetGoals/).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>pretty_id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>team_id</td><td>STRING</td></tr><tr><td>creator</td><td>NUMERIC</td></tr><tr><td>color</td><td>STRING</td></tr><tr><td>date_created</td><td>STRING</td></tr><tr><td>due_date</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>private</td><td>BOOLEAN</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr><tr><td>multiple_owners</td><td>BOOLEAN</td></tr><tr><td>editor_token</td><td>STRING</td></tr><tr><td>date_updated</td><td>STRING</td></tr><tr><td>last_update</td><td>STRING</td></tr><tr><td>pinned</td><td>BOOLEAN</td></tr><tr><td>owners</td><td>RECORD</td></tr><tr><td>key_result_count</td><td>NUMERIC</td></tr><tr><td>percent_completed</td><td>BIGNUMERIC</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/business/clickup/schema-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.