ClickUp + Steampipe

ClickUp is a SaaS specialising in Project/Task Management similar to Jira or Asana.

Steampipe is an open source CLI for querying cloud APIs using SQL from Turbot

Documentation

• Table definitions / examples

Getting Started

Installation

steampipe plugin install theapsgroup/clickup

Credentials

Configuration

Configuration can take place in the config file (which takes precedence) ~/.steampipe/config/clickup.spc or in Environment Variables.

Environment Variables:

• CLICKUP_TOKEN for the API token (ex: pk_t348t9v3UYFG535ti)

Configuration File:

connection "clickup" {
  plugin  = "theapsgroup/clickup"
  token   = "pk_t348t9v3UYFG535ti"
}

Testing

A quick test can be performed from your terminal with:

> steampipe query "select id, name, color from clickup_team"

+---------+---------------+---------+
| id      | name          | color   |
+---------+---------------+---------+
| 1111111 | The APS Group | #003b75 |
+---------+---------------+---------+