Skip to main content

Save data from ClickUp to a SQLite database

Project description

clickup-to-sqlite

PyPI Changelog Tests License

Save data from ClickUp to a SQLite database.

Currently to CLI tool collects the following data from ClickUp:

  • Teams
  • Spaces
  • Lists
  • Folders
  • Tasks
  • Time entries

The following data is currently not yet downloaded:

  • Comments
  • Goals
  • Guests
  • Member data
  • Views

How to install

$ pip install clickup-to-sqlite

Authentication

First, you will need to get your personal access token from ClickUp. Retrieve it from ClickUp under Settings > My Apps > Apps > API Token. Then use the value with the --auth-token option like explained below or provide it with the CLICKUP_ACCESS_TOKEN environment variable. This works especially well when using something like direnv.

Usage

To download your ClickUp data into a sqlite database run the following command:

$ clickup-to-sqlite fetch --auth-token=pk_YOUR_PERSONAL_TOKEN clickup.sqlite

Note: Currently the data fetching will run into the rate limit applied by the ClickUp API if your backlog of tasks or time entries is rather large.

Once you have downloaded the data into the sqlite database, you can explore the data. I recommend to have a look at Datasette for adhoc analysis.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

clickup-to-sqlite-0.2.0.tar.gz (12.3 kB view details)

Uploaded Source

Built Distribution

clickup_to_sqlite-0.2.0-py3-none-any.whl (12.0 kB view details)

Uploaded Python 3

File details

Details for the file clickup-to-sqlite-0.2.0.tar.gz.

File metadata

  • Download URL: clickup-to-sqlite-0.2.0.tar.gz
  • Upload date:
  • Size: 12.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.8.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.8

File hashes

Hashes for clickup-to-sqlite-0.2.0.tar.gz
Algorithm Hash digest
SHA256 e077f03cc7dc7d2c255e90bbbd8cd40d7a0c8c1fe4447c8e754c9719fdf676cf
MD5 e03c8d22777a7f3d2036407d018f7c16
BLAKE2b-256 6e9cdd59794e18b8cc3cbddb2c3ef1a1e27771b7c2dbc84b43f1785d5013dbae

See more details on using hashes here.

Provenance

File details

Details for the file clickup_to_sqlite-0.2.0-py3-none-any.whl.

File metadata

  • Download URL: clickup_to_sqlite-0.2.0-py3-none-any.whl
  • Upload date:
  • Size: 12.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.8.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.8

File hashes

Hashes for clickup_to_sqlite-0.2.0-py3-none-any.whl
Algorithm Hash digest
SHA256 920ca178c3be0c32c6589a0cd3061b558b77a07c53558c53d4542207ac8eadff
MD5 5a593ca080acf33b9e8a79658b115bdd
BLAKE2b-256 e19977dac65f3a83b402c7c2441ab39964a0fc24f4e5e3f343a10536f49dffc0

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page