Replicate ClickUp Database to a SQL Table.
Project description
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
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
clickuptosql-1.0.0.tar.gz
(18.5 kB
view hashes)
Built Distribution
Close
Hashes for clickuptosql-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ddfc193abb5af8d0e886f4ed8e279a7f4ad9fc0c000aab9c2abceee794de9aeb |
|
MD5 | 629d9e2c2f558baec09bc529f4a42bb1 |
|
BLAKE2b-256 | 6adb1ec819d84580ceb9207edcfdbbbae09f9f7c2482373319c23b148f3de888 |