interface SeaTableV2NodeParameters {
apply_default?: boolean;
assetPath?: string;
bigdata?: boolean;
columnsUi?: {
columnValues: {
columnName?: string;
columnValue?: string;
}[];
};
dataPropertyName?: string;
fieldsToSend?: "autoMapInputData"
| "defineBelow";
inputsToIgnore?: string;
linkColumn?: string;
linkColumnSourceId?: string;
linkColumnTargetId?: string;
operation?:
| "create"
| "get"
| "update"
| "add"
| "remove"
| "list"
| "search"
| "upload"
| "metadata"
| "lock"
| "unlock"
| "snapshot"
| "collaborator"
| "getPublicURL";
options?: | { convert?: boolean; simple?: boolean }
| {
convert?: boolean;
insensitive?: boolean;
simple?: boolean;
wildcard?: boolean;
}
| { append?: boolean; replace?: boolean };
resource?: "base" | "row" | "link" | "asset";
rowId?: string;
searchColumn?: string;
searchString?: string;
searchTerm?: string;
tableName?: string;
uploadColumn?: string;
viewName?: string;
}Properties§
readonly apply _ default?: booleanreadonly asset Path?: string§readonly bigdata?: booleanWhether write to Big Data backend (true) or not (false). True requires the activation of the Big Data backend in the base.
readonly columns Ui?: { ... }Add destination column with its value. Provide the value in this way. Date: YYYY-MM-DD or YYYY-MM-DD hh:mm. Duration: time in seconds. Checkbox: true, on or 1. Multi-Select: comma-separated list. Default: {} Type options: {"multipleValueButtonText":"Add Column to Send","multipleValues":true}
readonly data Property Name?: stringName of the binary property which contains the data for the file to be written Default: "data"
readonly fields To Send?: "autoMapInputData" | "defineBelow"Whether to insert the input data this node receives in the new row Default: "defineBelow"
readonly inputs To Ignore?: stringList of input properties to avoid sending, separated by commas. Leave empty to send all properties.
readonly link Column?: stringChoose from the list of specify the Link Column by using an expression. You have to provide it in the way "column_name:::link_id:::other_table_id". Type options: {"loadOptionsDependsOn":["tableName"],"loadOptionsMethod":"getLinkColumns"}
readonly link Column Source Id?: stringProvide the row ID of table you selected
readonly link Column Target Id?: stringProvide the row ID of table you want to link
readonly operation?:
| "create"
| "get"
| "update"
| "add"
| "remove"
| "list"
| "search"
| "upload"
| "metadata"
| "lock"
| "unlock"
| "snapshot"
| "collaborator"
| "getPublicURL"Default: "create"
readonly options?:
| { convert?: boolean; simple?: boolean }
| {
convert?: boolean;
insensitive?: boolean;
simple?: boolean;
wildcard?: boolean;
}
| { append?: boolean; replace?: boolean }Default: {}
readonly resource?: "base" | "row" | "link" | "asset"Default: "row"
readonly row Id?: stringChoose from the list, or specify an ID using an expression Type options: {"loadOptionsDependsOn":["tableName"],"loadOptionsMethod":"getRowIds"}
readonly search Column?: stringSelect the column to be searched. Not all column types are supported for search. Choose from the list, or specify a name using an expression. Type options: {"loadOptionsDependsOn":["tableName"],"loadOptionsMethod":"getSearchableColumns"}
readonly search String?: stringSeaTable identifies users with a unique username like 244b43hr6fy54bb4afa2c2cb7369d244@auth.local. Get this username from an email or the name of a collaborator.
readonly search Term?: stringWhat to look for?
readonly table Name?: stringChoose from the list, or specify an ID using an expression Type options: {"loadOptionsMethod":"getTableNames"}
readonly upload Column?: stringChoose from the list, or specify the name using an expression Type options: {"loadOptionsDependsOn":["tableName"],"loadOptionsMethod":"getAssetColumns"}
readonly view Name?: stringThe name of SeaTable view to access, or specify by using an expression. Provide it in the way "col.name:::col.type". Type options: {"loadOptionsDependsOn":["tableName"],"loadOptionsMethod":"getTableViews"}
Whether to use the column default values to populate new rows during creation (only available for normal backend)