ClickUp

ClickUp is a cloud solution offering project management and collaboration tools such as task and time tracking, team chat, project whiteboard, etc.

Data integration: Skyvia supports importing data to and from ClickUp, exporting ClickUp data to CSV files, replicating ClickUp data to relational databases, and synchronizing ClickUp data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support ClickUp.

Query: Skyvia Query supports ClickUp.

Establishing Connection

Sign in using your credentials to create a connection with ClickUp.

Creating Connection

To connect to ClickUp, perform the following steps:

  1. In the Connection Editor, click Sign In with ClickUp.

    clickup-connection

  2. Enter your email and password in the corresponding boxes and click Log In.

    clickup-login

  3. Select the needed ClickUp workspace and click Connect Workspace.

    clickup-workspace

Additional Connection Parameters

Suppress Extended Requests

ClickUp API returns only part of the fields for some objects when querying multiple records. To query values of lacking fields, Skyvia performs additional extended requests. Skyvia performs such API requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls used.

The additional fields are the following:

OBJECT FIELD
FolderlessGoals FolderName, History, PrettyUrl
FolderGoals FolderName, History и PrettyUrl
Lists Statuses
FolderlessLists Statuses

Connector Specifics

Object Peculiarities

Querying Deleted Records

The deleted records are unavailable when you query all records in an object. However, ClickUp objects support soft delete operations. If an object supports filtering by ID, you can query the deleted record using filter by its ID.

TimeEntries

When you query time entries, you get the records created for the last 30 days for the current user. To get time entries for another team member or all team members, use filter by the Assignee field. To query time entries for multiple assignees, specify their IDs separated by comma, for example Assignee = 1234, 5678.

The Assignees field is designed for filtering only. If you query this field without filter by this field, it will return empty values when querying.

Teams_UserGroups

The Members field stores a list of IDs in array format. The Members_Add and Members_Rem fields do not store data and return empty values when querying. They exist only for adding or removing members’ list items.

When inserting records to the Teams_UserGroups object, map the Members field in array format, for example [123, 789].

To add a new member to the existing group, use the UPDATE or UPSERT operation and map the Members_Add field specifying the user IDs you want to add. For example, to add a user with Id = 456 to the existing list [123, 789], map the Members_Add field to [456] value. As a result the Members array will look like this [123, 456, 789].

To remove a user from the list, use the UPDATE or UPSERT operation and map the Members_Rem field specifying the user IDs you want to remove. For example, to remove a user with Id = 789 from the list [123, 456, 789], map the Members_Rem field to [789] value. As a result, the Members array will look like this [123, 456].

FolderlessGoals

When inserting records to the FolderlessGoals, map the Owners field in JSON format, for example, [12345678, 23456789].

To add a new owner to the existing owners’ list, use the UPDATE or UPSERT operation and map the Owners field specifying the user IDs you want to add. For example, to add a new owner with Id = 34567890 to the existing owners list [12345678, 23456789], map the Owners field to the [34567890] value. As a result, the owners’ list will look like this: [12345678, 23456789, 34567890].

To remove an owner from the list, use the UPDATE or UPSERT operation and map the OwnersRemove field specifying the user IDs you want to remove. For example, to remove an owner with Id = 12345678 from the existing list [12345678, 23456789, 34567890], map the OwnersRemove field to the [12345678] value. As a result, the owners’ list will look like [23456789, 34567890].

TaskComments and ListComments

These objects display the last 25 comments for each task or list within a query. To get earlier comments, filter by the Date and StartId fields. The StartId field doesn’t return data when querying. It is used for filtering only.

To increase query performance, you may filter by the TaskId field for the TaskComments object and the ListId field for the ListComments object.

Nested Objects

The following fields store complex structured data in JSON format. These objects are read-only.

Object Field
Lists Statuses
FolderlessLists Statuses
Workspaces Members

You can replicate these objects into databases or data warehouses using our new replication runtime. For this, select the Use New Replication Runtime in the Replication, enable the Unwind Nested Objects and select Separate Tables.

Filtering Specifics

Skyvia supports the following native filters for ClickUp objects.

Object Field Operator
TeamTasks = Status_Status, Parent,ListId, Project_Id, SpaceId
TeamTasks <, <=, >, >= CreatedDate, UpdatedDate, DateDone, DueDate
TimeEntries >, >= Start
TimeEntries <, <= End

Use these filters to improve performance and save API calls. You can use filters with other fields or operators, but it may increase API call usage.

Custom Fields

The CustomFields field in the TeamTasks object stores the custom fields related to specific task. You can add values to this field using the INSERT operation. To update or delete values from the CustomFields values, use stored procedures.

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for the FolderlessGoals, FolderGoals, TeamTasks, and Teams_UserGroups objects. Skyvia detects only new records for the Teams_UserGroups object.

Skyvia supports Synchronization for the FolderlessGoals and TeamTasks objects.

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE FolderlessGoals, FolderlessLists, Folders, ListComments, Lists, Spaces, Tags, TaskComments, Team_UserGroups, TeamTasks, TimeEntries
UPDATE, DELETE FolderGoals

Stored Procedures

UpdateTaskCustomField

To update value in the TeamTasks object CustomFields field, use the following command.

UpdateTaskCustomField(:task_id, :field_id, :valueArray, :valueObject, :valueString, :valueInt, :value_options)

PARAMETER NAME DESCRIPTION
Task_id Required. ID of the task you want to update
field_id Required. Universal unique identifier (UUID) of the Custom Field you want to set
ValueArray Parameter for JSON Array value update
ValueObject Parameter for JSON Object value update
ValueString Parameter for String value update
ValueInt Parameter for numeric value update
Value_options Parameter for drop-down menu option update

RemoveTaskCustomField

To delete custom field, use the following command

RemoveTaskCustomField(:task_id,:field_id)

Supported Actions

Skyvia supports all the common actions for ClickUp.