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.1.0.tar.gz
(18.5 kB
view hashes)
Built Distribution
Close
Hashes for clickuptosql-1.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 48190851355fea35e1d3ab0c662dce2ff4873f662c3987315e015e161fc2263a |
|
MD5 | d8386ec82adbd243d825c4eb463abb84 |
|
BLAKE2b-256 | d57b5c733e22305f9e961b6a5fe859caa2faedc4f81fd693d61c8864aff03841 |