Save data from ClickUp to a SQLite database
Project description
clickup-to-sqlite
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | e077f03cc7dc7d2c255e90bbbd8cd40d7a0c8c1fe4447c8e754c9719fdf676cf |
|
MD5 | e03c8d22777a7f3d2036407d018f7c16 |
|
BLAKE2b-256 | 6e9cdd59794e18b8cc3cbddb2c3ef1a1e27771b7c2dbc84b43f1785d5013dbae |
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 920ca178c3be0c32c6589a0cd3061b558b77a07c53558c53d4542207ac8eadff |
|
MD5 | 5a593ca080acf33b9e8a79658b115bdd |
|
BLAKE2b-256 | e19977dac65f3a83b402c7c2441ab39964a0fc24f4e5e3f343a10536f49dffc0 |