Kanban Lite

Interact with a Kanban Lite workspace – boards, cards, comments, attachments, columns, labels, and more

Actions46

Storage → Migrate to SQLite

AI-generated

Summary

Migrate board data to SQLite

Inputs

  • transport — How this node connects to Kanban Lite - selects the transport mode for the operation. Remote API connects to a standalone server via HTTP; Local SDK accesses a workspace directly via the Kanban Lite SDK (requires kanban-lite installed). Defaults to Remote API mode if not specified. The mode also determines which credentials are required: kanbanLiteApi for Remote API, kanbanLiteSdk for Local SDK. The choice does not affect the migration logic itself, only the connection path.
  • sqlitePath — Optional path for the SQLite database file. When left empty, the operation defaults to .kanban/kanban.db on the server/workspace. This parameter is only exposed for the Storage resource and Migrate to SQLite operation.

Output shape

The node outputs items on its main output. Each item's json field contains the result of the migration operation as returned by the selected transport mode. In API mode the result envelope includes { data, statusCode }; in SDK mode it includes { data } only. The exact data shape depends on the Kanban Lite server/sdk implementation of the migration.

Transport mode selection (transport) does not change what the operation does—it only changes how the request is routed (HTTP POST to /api/storage/migrate-to-sqlite via Remote API, or direct SDK method call via Local SDK). The sqlitePath parameter is passed through to the underlying migration routine and used as the target SQLite database path if provided.

Examples

Example 1: Migrate to a custom SQLite path using Remote API

Set transport to 'api' (default), provide kanbanLiteApi credentials, set sqlitePath to '/data/kanban_backup.db'. The node will POST to the server's /api/storage/migrate-to-sqlite endpoint with the sqlitePath in the request body.

Example 2: Migrate using Local SDK with custom path

Set transport to 'sdk', ensure kanban-lite is installed and kanbanLiteSdk credentials point to a valid workspace directory, set sqlitePath to a desired local path. The node instantiates KanbanSDK and calls migrateToSqlite with the provided path.

Links

Discussion