ClickUp to SQL
Replicate ClickUp Database to a SQL Table.
Developed by Dipan Nanda (c) 2023
Example of Usage
from clickuptosql import Migrate2Sql
from etl_encrypt import get_clickup_api_key
from sqlalchemy.types import NVARCHAR
spaces = None
attributes = None
# None selects every attribute by default
# spaces = [<-- LIST OF SPACE_ID'S -->]
# attributes = [<-- LIST OF ATTRIBUTES -->]
api_key = '<-- YOUR API KEY -->'
server = '<-- SERVER NAME -->'
database = '<-- DATABASE NAME -->'
username = '<-- YOUR USERNAME -->'
password = '<-- YOUR PASSWORD -->'
driver = '<-- SQL DRIVER -->'
sql_string = f'{username}:{password}@{server}/{database}?driver={driver}'
dtype = {'id': NVARCHAR(length=50)}
helper = Migrate2Sql(clickup_api_token=api_key, spaces=spaces, optimise=True,
attribute_values=attributes, sql_connection=sql_string, dtype=dtype)
helper.start()
Changelog
Go here to checkout the complete changelog.
License
This is under GNU GPL v3.0 License
1 maintainer
Release files for clickuptosql 1.1.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| clickuptosql-1.1.0.tar.gz | 18.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| clickuptosql-1.1.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 36.8 kB
Release files / clickuptosql-1.1.0.tar.gz
| Download URL | clickuptosql-1.1.0.tar.gz |
|---|---|
| Size | 18.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
626c061d5532555aeccb6e58122abbb402546a1827b21a3ec6c2ac47cd6d877b
|
|
BLAKE2b-256 checksum How to use checksums |
5448d0c11abbe1a31c0ba2b292d9e27004cf2a3668c0ad055baa6275744a2b12
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.16
|
Release files / clickuptosql-1.1.0-py3-none-any.whl
| Download URL | clickuptosql-1.1.0-py3-none-any.whl |
|---|---|
| Size | 18.3 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
48190851355fea35e1d3ab0c662dce2ff4873f662c3987315e015e161fc2263a
|
|
BLAKE2b-256 checksum How to use checksums |
d57b5c733e22305f9e961b6a5fe859caa2faedc4f81fd693d61c8864aff03841
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.16
|
