SeaTable
Read and write SeaTable base rows, links, files and webhooks.
OCNORA ships 18 typed SeaTable operations and 1 trigger. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run. Endpoints not covered by a typed node are called at https://cloud.seatable.io through the HTTP node with the same credential.
Before you connect SeaTable
- Authentication
- API key
- Credential
- {"api_token", "account_token"}the base API token, or {"api_token": "…", "account_token": "…"} where the account token is only needed by the webhook operations
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
- Prerequisites
- Two credentials, and they are not interchangeable: the base 'api_token' names the workspace and base, and the 40-character 'account_token' (POST /api2/auth-token/ with a username and password) is the only one SeaTable's webhook endpoints accept. Publishing also needs MANTLE_APP_PUBLIC_BASE_URL set to a URL SeaTable can reach.
Prerequisites are taken from the connection notes in this provider’s node contracts; each node’s reference page says which apply to it.
What you can do with SeaTable
Operations, grouped by what they do to your data, plus 1 trigger that start a run.
Create and send 3
Read and search 8
Delete and cancel 3
Other operations 1
A sample SeaTable workflow
- 1Row Eventtrigger.seatable_eventStart a run when a row is added, changed or deleted in a SeaTable base.
- 2Get File Download Linkseatable.get_file_download_linkTurn a stored asset path into a temporary, downloadable URL.
- 3Append Rowsseatable.append_rowsAdd one or more rows to a table, keyed by column name; the result reports how many of them SeaTable actually inserted.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 18
- Append RowsAdd one or more rows to a table, keyed by column name; the result reports how many of them SeaTable actually inserted.seatable.append_rows
- Create Row LinksLink rows across two tables through a link column; SeaTable rejects the whole request if any of the links already exists.seatable.create_row_links
- Create WebhookRegister a webhook so SeaTable posts every change in this base to a workflow's trigger.webhook ingress URL.seatable.create_webhook
- Delete Row LinksUnlink rows through a link column and report how many links actually went.seatable.delete_row_links
- Delete RowsDelete one or more rows from a table by their row ids.seatable.delete_rows
- Delete WebhookRemove a webhook so SeaTable stops posting this base's changes.seatable.delete_webhook
- Get File Download LinkTurn a stored asset path into a temporary, downloadable URL.seatable.get_file_download_link
- Get MetadataRead the base's structure: its tables, their columns and views, and the internal table and link ids the link operations need.seatable.get_metadata
- Get RowRead a single row by its row id, with every column it carries.seatable.get_row
- Get Upload LinkMint a short-lived upload target for this base, together with the parent and relative paths an upload has to send back.seatable.get_upload_link
- List Row LinksRead the rows linked to each of the given rows through one link column.seatable.list_row_links
- List RowsRead one page of rows from a table, or from one of its views.seatable.list_rows
- List WebhooksList the webhooks registered on this base; needs an account token.seatable.list_webhooks
- Query SQLSearch a base with SeaTable's SQL dialect, binding workflow values through ? placeholders rather than string concatenation.seatable.query_sql
- Update Row LinksReplace each addressed row's links in one link column with the given set.seatable.update_row_links
- Update RowsUpdate one or more existing rows, each addressed by its row id.seatable.update_rows
- Update WebhookRepoint an existing webhook at another URL, or rotate its signing secret; SeaTable wants the URL on either change.seatable.update_webhook
- Upload FileUpload a file into the base's asset store and return the values a file column or an image column stores for it.seatable.upload_file
SeaTable questions
- How does OCNORA authenticate with SeaTable?
- With a stored API key credential, shaped {"api_token", "account_token"} or the base API token, or {"api_token": "…", "account_token": "…"} where the account token is only needed by the webhook operations. A connection test can check it when you add it.
- What can I automate with SeaTable?
- 18 typed operations and 1 trigger, each with a reference page listing its config fields and the shapes it emits.
- What if the SeaTable operation I need is not listed?
- Call https://cloud.seatable.io from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use SeaTable?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are SeaTable calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
More in Databases & warehouses
See your first SeaTable workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.