ClickUp

Adding the data source

Based on ClickUp API documentation

Requirements

Make sure to use an user with admin access to the Workspaces to be replicated

Instructions

Currently ClickUp has two versions: ClickUp 2.0 and ClickUp 3.0. Following you can find the instructions to obtain the API Key in both versions.

Instructions to ClickUp 2.0

1) Log in to your ClickUp account, click on your profile icon on the bottom left and then on "My Settings";

2) On the settings page, on the left bar, look for “Apps”;

3) Search for the “API Token” section and copy the value found – this is the time to generate a first API Token if you don’t have one yet;

4) On the Kondado platform, go to the add new sources page and select the ClickUp data source;

5) Name your data source and, in API Token, paste the value obtained in step 3 and click "SAVE".

Instructions to ClickUp 3.0

1) Log in to your ClickUp account, click on your profile icon on the upper-right corner and then on "Settings";

2) Scroll down and click on the “Apps” section in the sidebar;

3) Search for the “API Token” section and click on “Generate” if you don't have an API token yet, or on “Regenerate” if you already have one. Copy the value displayed in the “API Token” section;

4) On the Kondado platform, go to the add new sources page and select the ClickUp data source;

5) Name your data source and, in API Token, paste the value obtained in step 3 and click "SAVE".

Pipelines

Relationship Chart

Click to open the relationship chart

Workspaces

Field	Type
id	text
name	text
color	text
avatar	text

Spaces

Main object

Field	Type
space_id	text
workspace_id	text
archived	boolean
multiple_assignees	boolean
name	text
private	boolean

priorities

Field	Type
space_id	text
color	text
priority_id	float
priorities__orderindex	float
priorities__priority	text

statuses

Field	Type
space_id	text
status_id	text
color	text
orderindex	float
status	text
type	text

_features

Field	Type
space_id	text
eature	text
feature_key	text
feature_val	boolean

Folders

Main object

Field	Type
folder_id	text
space_id	text
archived	boolean
hidden	boolean
name	text
orderindex	float
override_statuses	boolean
permission_level	text
task_count	float

statuses

Field	Type
folder_id	text
color	text
status_id	text
orderindex	float
status	text
type	text

Lists

Field	Type
list_id	text
folder_id	text
archived	boolean
due_date	timestamp
name	text
orderindex	float
override_statuses	boolean
permission_level	text
priority__color	text
priority__priority	text
start_date	timestamp
status__color	text
status__hide_label	boolean
status__status	text
task_count	float

Lists members

Field	Type
list_id	text
user_id	text
username	text
email	text
color	text
initials	text
profilepicture	text

Tasks

Main object

Campo	Tipo
task_id	text
workspace_id	text	Workspaces > > id
creator_id	text	List members > > user_id
folder_id	text	Folders > > folder_id
list_id	text	Lists > > list_id
space_id	text	Spaces > > space_id
custom_id	text
date_closed	timestamp
date_done	timestamp
date_created	timestamp
date_updated	timestamp
start_date	timestamp
description	text
due_date	timestamp
name	text
orderindex	float
parent	text
permission_level	text
points	float
archived	boolean
priority_color	text
priority_id	text
priority_orderindex	float
priority_priority	text
status__color	text
status__orderindex	float
status__status	text
status__type	text
text_content	text
time_estimate	float
url	text

clickup_tasks__tags

Campo	Tipo
task_id	text
tag_creator	text	List members > > user_id
tag_name	text
tag_bg	text
tag_fg	text

clickup_tasks__dependencies

Campo	Tipo
task_id	text
dependency_date_created	timestamp
dependency_depends_on	text
dependency_type	float
dependency_userid	text	List members > > user_id

clickup_tasks__assignees

Campo	Tipo
task_id	text
assignee_id	text	List members > > user_id

clickup_tasks__linked_tasks

Campo	Tipo
task_id	text
date_created	timestamp
link_id	text
userid	text	List members > > user_id

Tasks: custom fields

Field	Type
task_id	text
field_x	text
field_y	timestamp
field_z	float

Custom fields from tasks inside folderless lists will not be returned

Tasks: time in status

Main object

Field	Type
task_id	text
current_status_name	text
current_status_color	text
current_status_total_time_by_minute	float
current_status_total_time_since	timestamp

status_history

Field	Type
task_id	text
status_name	text
status_color	text
status_type	text
total_time_by_minute	float
total_time_since	timestamp
orderindex	float