Skip to contents

Package

seatabler seatabler-package
seatabler: a generic R client for SeaTable servers

Connections

Configure and resolve the server connection (URL + token + workspace).

seatable_connection() is_seatable_connection()
Create a connection to a SeaTable server
default_connection()
The current default connection
set_default_connection()
Set (or clear) the default connection
with_connection()
Evaluate an expression with a temporary default connection
seatable_token()
Resolve the API token for a connection

Authentication

Import the Python SDK and obtain / mint API tokens.

seatable_module()
Import the seatable_api Python module
seatable_login() seatable_generate_token()
Authenticate with a SeaTable server

Bases, workspaces and tables

seatable_base()
Get a SeaTable base object
seatable_workspaces()
List workspaces (and their bases) visible to a connection
seatable_workspace_id()
Find the workspace containing a base
seatable_alltables()
List all tables across all bases visible to a connection

Querying and reading rows

seatable_query()
Run a SQL query against a SeaTable server
seatable_list_rows()
List rows from a SeaTable table
seatable_list_selected()
Select rows from a SeaTable table by id

Writing rows

Batch append / update / delete, with big-data batching.

seatable_update_rows() seatable_append_rows()
Update or append rows in a SeaTable table
seatable_delete_rows()
Delete rows from a SeaTable table

Big-data archive

seatable_archive_rows() seatable_unarchive_rows()
Move rows into and out of SeaTable big data storage

Columns and schema

seatable_columns()
Column names, types and default R types for a table
seatable_add_column() seatable_add_columns()
Add columns to a SeaTable table
seatable_delete_column()
Delete a column from a SeaTable table
seatable_select_options() seatable_add_select_options()
Read and add options for a select column

Snapshots

seatable_snapshots()
List the snapshots of a SeaTable base

REST transport

Low-level api-gateway helpers behind the big-data and snapshot functions.

seatable_rest() seatable_base_rest()
Call a SeaTable REST endpoint directly