n8nctl data-tables
n8nctl data-tables¶
Manage data tables and their rows
Synopsis¶
Create, list, inspect, update and delete data tables, and manage their rows. Data tables may be unlicensed on some editions (the API returns 403).
n8nctl data-tables create --set name=orders --set 'columns=[{"name":"sku","type":"string"}]'
n8nctl data-tables rows
Options¶
-h, --help help for data-tables
Options inherited from parent commands¶
--api-key string override the API key (prefer keyring via 'auth login')
--base-url string override the instance base URL (e.g. https://host/api/v1)
--columns strings comma-separated columns for table/csv output
--dry-run print the equivalent curl and send no request
--jq string apply a jq program to the result (e.g. '.[].id'); implies JSON input
--no-color disable colored output [env: NO_COLOR]
--no-header hide the table header row
-o, --output string output format: table|json|yaml|csv [env: N8NCTL_OUTPUT]
--profile string config profile (instance) to use [env: N8NCTL_PROFILE]
-q, --quiet suppress non-essential chatter
--rps float client-side rate limit in requests/sec (0 = use config/default)
--show-token do not redact the API key in --dry-run output
-v, --verbose verbose (debug) logging to stderr
SEE ALSO¶
- n8nctl - Control any n8n instance from the terminal via its public API
- n8nctl data-tables add-rows - Add rows (body: a JSON array of row objects)
- n8nctl data-tables create - Create a data-table
- n8nctl data-tables delete - Delete a data-table
- n8nctl data-tables delete-rows - Delete rows matching a filter
- n8nctl data-tables get - Get a single data-table by id
- n8nctl data-tables list - List data-tables
- n8nctl data-tables rows - List rows in a data table
- n8nctl data-tables update - Update a data-table
- n8nctl data-tables update-rows - Update rows matching a filter (body: {filter, data})
- n8nctl data-tables upsert-rows - Insert or update rows (body: {filter, data})