Seatable

SeaTable

The robomotion seatable CLI connects to SeaTable for collaborative database management. It manages rows (CRUD with filtering and sorting), tables, bases, links between records, file attachments, and views.

When to use

• List, create, update, or delete rows in SeaTable tables
• Search and filter rows with SQL-like conditions
• Manage links between records and file attachments
• List tables, views, and manage base schemas

Prerequisites

• robomotion CLI installed
• Package installed: robomotion install seatable
• SeaTable API token configured via Robomotion vault

IMPORTANT: Session Mode Required for Multi-Step Operations

Each CLI command runs as a separate process — connection IDs from connect do NOT persist across calls. You MUST use --session on connect and pass --session-id to all subsequent commands.

Workflow

1. Install (once): robomotion install seatable
2. Connect with session:

   robomotion seatable seatable_connect --session --output json
   # → {"outClientId":"<client-id>","session_id":"<session-id>"}
   

3. Use the returned client-id and session-id in all subsequent commands:

   robomotion seatable seatable_list_rows --client-id "<client-id>" --table-name <table> --session-id "<session-id>" --output json
   

4. Disconnect when done:

   robomotion seatable seatable_disconnect --client-id "<client-id>" --session-id "<session-id>" --output json
   

Always append --output json to get structured JSON results.

Commands Reference

• robomotion seatable seatable_connect --session --output json Connects to SeaTable and returns a client ID for subsequent operations
• robomotion seatable seatable_disconnect --client-id --session-id "<session-id>" --output json Closes the SeaTable connection and releases resources
• robomotion seatable seatable_create_row --client-id --table-name --row-data --session-id "<session-id>" --output json Creates a new row in a SeaTable table
• robomotion seatable seatable_get_row --client-id --table-name --row-id --session-id "<session-id>" --output json Retrieves a single row from a SeaTable table by its ID
• robomotion seatable seatable_list_rows --client-id --table-name [--view-name] [--0] [--100] --session-id "<session-id>" --output json Retrieves multiple rows from a SeaTable table
• robomotion seatable seatable_update_row --client-id --table-name --row-id --row-data --session-id "<session-id>" --output json Updates an existing row in a SeaTable table
• robomotion seatable seatable_delete_row --client-id --table-name --row-id --session-id "<session-id>" --output json Deletes a row from a SeaTable table
• robomotion seatable seatable_lock_row --client-id --table-name --row-id --session-id "<session-id>" --output json Locks a row in a SeaTable table to prevent changes
• robomotion seatable seatable_unlock_row --client-id --table-name --row-id --session-id "<session-id>" --output json Unlocks a row in a SeaTable table
• robomotion seatable seatable_search_rows --client-id --table-name --search-query [--100] --session-id "<session-id>" --output json Searches for rows containing a keyword in a SeaTable table
• robomotion seatable seatable_sql_query --client-id --sql-query --session-id "<session-id>" --output json Executes a SQL query on a SeaTable base
• robomotion seatable seatable_create_link --client-id --link-id --table-name --other-table-name --row-id --other-row-id --session-id "<session-id>" --output json Creates a link between two rows in different tables
• robomotion seatable seatable_delete_link --client-id --link-id --table-name --other-table-name --row-id --other-row-id --session-id "<session-id>" --output json Removes a link between two rows in different tables
• robomotion seatable seatable_upload_file --client-id --file-path --session-id "<session-id>" --output json Uploads a file to SeaTable storage
• robomotion seatable seatable_get_asset_url --client-id --asset-path --session-id "<session-id>" --output json Gets a download URL for a file/image asset stored in SeaTable
• robomotion seatable seatable_get_metadata --client-id --session-id "<session-id>" --output json Retrieves the metadata (structure) of a SeaTable base including tables، columns، and links
• robomotion seatable seatable_api_call --client-id --endpoint [--http-method] [--request-body] [--headers] --session-id "<session-id>" --output json Makes a custom API call to SeaTable for advanced operations

Environment

• ROBOMOTION_API_TOKEN (if vault credentials are needed)