ClickUp Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
ClickUp Tables
| Name | Description |
| AuthorizedUser | Returns the user that belongs to this token. |
| FolderlessLists | Returns folderless lists for a specific space |
| Folders | Returns folders for a specific space |
| FolderViews | Returns views for a specific folder |
| Goals | Returns goals for a specific team |
| ListComments | Returns list comments. |
| ListCustomFields | Returns list custom fields. |
| ListMembers | Returns list members. |
| Lists | Returns lists for a specific folder |
| ListViews | Returns views for a specific list |
| Spaces | Returns for a specific team |
| SpaceTags | Returns space tags. |
| SpaceViews | Returns views for a specific space |
| TaskComments | Returns task comments. |
| TaskMembers | Returns task members. |
| Tasks | Returns tasks for a specific list |
| TaskTemplates | Returns task templates |
| TaskTimeInStatus | Get task's time in status |
| Teams | Returns teams for the account. |
| TeamTasks | Returns tasks for a specific team |
| TeamViews | Returns views for a specific team |
| TimeEntries | Returns time within a specified date range |
| TrackedTime | Returns tracked time for a specific task |
| Users | Returns all users of the team. |
| ViewComments | Returns view comments. |
| ViewTasks | Returns view tasks |
| Webhooks | Returns webhools for a specific team |