Skip to content

ClickUp

ClickUp is a cloud-based productivity platform designed to help teams and individuals manage tasks, projects, and workflows in one place.

ingestr supports ClickUp as a source.

URI format

clickup://?api_token=<token>

URI parameters:

  • api_token is a personal token used to authenticate with the ClickUp API.

ClickUp requires a api_token to connect to the ClickUP API. For more information, read here to get credentail.

Once you've completed the guide, you should have api_token. Let's say your API Token is token_123, here's a sample command that will copy the data from Clickup into a DuckDB database:

To ingest tasks from ClickUp into a DuckDB database:

sh
ingestr ingest \
  --source-uri "clickup://?api_token=token_123" \
  --source-table "tasks" \
  --dest-uri duckdb:///clickup.duckdb \
  --dest-table "public.tasks"
clickup_img

Tables

ClickUp source allows ingesting the following resources into separate tables:

TablePKInc KeyInc StrategyDetails
userid-mergeThe authorised user profile
teamsidmergeWorkspaces available to the authenticated user. In ClickUp, a "team" in the API is equivalent to a workspace, which is the highest-level container for all spaces, folders, lists, and tasks
spacesid-mergeSpaces available within a workspace. Spaces are major sections used to organize work, such as departments, projects, or business units. Each space can contain folders, lists, and tasks
listsidmergeLists contained in each space. Lists are collections of tasks, often representing projects, sprints, or workflow stages
tasksiddate_updatedmergeTasks belonging to each list

Use these as --source-table parameter in the ingestr ingest command.

WARNING

ClickUp does not support incremental loading for many endpoints, which means ingestr will load endpoints incrementally if they support it, and do a full-refresh if not.