ClickUp
ClickUp ETL connector for data replication
Features | Details |
---|---|
Release Status | Under Development |
Source API Version | V2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | ClickUp API key |
Replication Type | Full Replication
Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | 1 hour |
Teams | Spaces |
Folders | Lists |
Tasks | Goals |
- 1.Sign in to Daton
- 2.Select ClickUp from the list of Integrations
- 3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide your ClickUp API Key
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Purpose: This API is used to fetch all the teams and members in the workspace
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
name | STRING |
color | STRING |
avatar | STRING |
members | RECORD |
Purpose: This API is used to fetch all the spaces created in the workspace
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
name | STRING |
private | BOOLEAN |
statuses | RECORD |
multiple_assignees | BOOLEAN |
features | RECORD |
Purpose: This API is used to fetch all the folders under the spaces
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
name | STRING |
orderindex | NUMERIC |
override_statuses | BOOLEAN |
hidden | BOOLEAN |
space | RECORD |
task_count | STRING |
lists | RECORD |
Purpose: This API is used to fetch all the lists under the folders
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
name | STRING |
orderindex | NUMERIC |
content | STRING |
status | RECORD |
priority | RECORD |
assignee | STRING |
task_count | STRING |
due_date | STRING |
start_date | STRING |
folder | RECORD |
space | RECORD |
archived | BOOLEAN |
override_statuses | BOOLEAN |
permission_level | STRING |
Purpose: This API is used to fetch all the tasks
Replication: Key Based Incremental
Replication Key: date_updated_lt, date_updated_gt
Fields
Name | Data Type |
---|---|
id | STRING |
name | STRING |
status | RECORD |
orderindex | STRING |
date_created | STRING |
date_updated | STRING |
creator | RECORD |
list | RECORD |
folder | RECORD |
space | RECORD |
url | STRING |
Purpose: This API is used to fetch all the goals set in the workspace
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
pretty_id | STRING |
name | STRING |
team_id | STRING |
creator | NUMERIC |
owner | STRING |
color | STRING |
date_created | STRING |
start_date | STRING |
due_date | STRING |
description | STRING |
private | BOOLEAN |
archived | BOOLEAN |
multiple_owners | BOOLEAN |
editor_token | STRING |
date_updated | STRING |
last_update | STRING |
folder_id | STRING |
pinned | BOOLEAN |
key_result_count | NUMERIC |
members | RECORD |
percent_completed | NUMERIC |
Last modified 6mo ago