Windsor brings all your ClickUp data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
ClickUp Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| BOOLEAN | folder.hidden | folder.hidden | folder | |
| folder__id | TEXT | folder.id | folder.id | folder |
| folder__lists | OBJECT | folder.lists | folder.lists | folder |
| folder__name | TEXT | folder.name | folder.name | folder |
| folder__orderindex | NUMERIC | folder.orderindex | folder.orderindex | folder |
| folder__override_statuses | BOOLEAN | folder.override_statuses | folder.override_statuses | folder |
| folder__space | OBJECT | folder.space | folder.space | folder |
| folder__task_count | TEXT | folder.task_count | folder.task_count | folder |
| list__archived | BOOLEAN | list.archived | list.archived | list |
| list__assignee | TEXT | list.assignee | list.assignee | list |
| list__content | TEXT | list.content | list.content | list |
| list__due_date | DATE | list.due_date | list.due_date | list |
| list__folder | OBJECT | list.folder | list.folder | list |
| list__id | TEXT | list.id | list.id | list |
| list__name | TEXT | list.name | list.name | list |
| list__orderindex | NUMERIC | list.orderindex | list.orderindex | list |
| list__override_statuses | BOOLEAN | list.override_statuses | list.override_statuses | list |
| list__permission_level | TEXT | list.permission_level | list.permission_level | list |
| list__priority | TEXT | list.priority | list.priority | list |
| list__space | OBJECT | list.space | list.space | list |
| list__start_date | DATE | list.start_date | list.start_date | list |
| list__status | OBJECT | list.status | list.status | list |
| list__task_count | NUMERIC | list.task_count | list.task_count | list |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| space__assignees | OBJECT | space.assignees | space.assignees | space |
| space__features | OBJECT | space.features | space.features | space |
| space__id | TEXT | space.id | space.id | space |
| space__multiple_assignees | BOOLEAN | space.multiple_assignees | space.multiple_assignees | space |
| space__name | TEXT | space.name | space.name | space |
| space__private | BOOLEAN | space.private | space.private | space |
| space__statuses | OBJECT | space.statuses | space.statuses | space |
| task__assignees | OBJECT | task.assignees | task.assignees | task |
| task__checklists | OBJECT | task.checklists | task.checklists | task |
| task__creator | OBJECT | task.creator | task.creator | task |
| task__date_closed | DATE | task.date_closed | task.date_closed | task |
| task__date_created | DATE | task.date_created | task.date_created | task |
| task__date_updated | TEXT | task.date_updated | task.date_updated | task |
| task__due_date | DATE | task.due_date | task.due_date | task |
| task__folder | OBJECT | task.folder | task.folder | task |
| task__id | TEXT | task.id | task.id | task |
| task__list | OBJECT | task.list | task.list | task |
| task__name | TEXT | task.name | task.name | task |
| task__orderindex | TEXT | task.orderindex | task.orderindex | task |
| task__parent | TEXT | task.parent | task.parent | task |
| task__priority | OBJECT | task.priority | task.priority | task |
| task__space | OBJECT | task.space | task.space | task |
| task__start_date | DATE | task.start_date | task.start_date | task |
| task__status | OBJECT | task.status | task.status | task |
| task__tags | OBJECT | task.tags | task.tags | task |
| task__time_estimate | TEXT | task.time_estimate | task.time_estimate | task |
| task__time_spent | TEXT | task.time_spent | task.time_spent | task |
| task__url | TEXT | task.url | task.url | task |
| team__avatar | TEXT | team.avatar | team.avatar | team |
| team__color | TEXT | team.color | team.color | team |
| team__id | TEXT | team.id | team.id | team |
| team__members | OBJECT | team.members | team.members | team |
| team__name | TEXT | team.name | team.name | team |
| today | DATE | Today | Today's date | |
| user__user | OBJECT | user.user | user.user | user |