Data Table

Node: dataTable · Full type: n8n-nodes-base.dataTable · Version: 1.1

Operations

Resource: row

deleteRows

Parameter	Type	Default	Details
matchType	options	"anyCondition"	anyCondition, allConditions
filters	fixedCollection	{}	groups: conditions
options	collection	{}	keys: dryRun

get

Parameter	Type	Default	Details
matchType	options	"anyCondition"	anyCondition, allConditions
filters	fixedCollection	{}	groups: conditions
returnAll	boolean	false
limit	number	50
orderBy	boolean	false
orderByColumn	options	"createdAt"
orderByDirection	options	"DESC"	ASC, DESC

rowExists

Parameter	Type	Default	Details
matchType	options	"anyCondition"	anyCondition, allConditions
filters	fixedCollection	{}	groups: conditions

rowNotExists

Parameter	Type	Default	Details
matchType	options	"anyCondition"	anyCondition, allConditions
filters	fixedCollection	{}	groups: conditions

insert

Parameter	Type	Default	Details
columns	resourceMapper	{...}	required
options	collection	{}	keys: optimizeBulk

update

Parameter	Type	Default	Details
matchType	options	"anyCondition"	anyCondition, allConditions
filters	fixedCollection	{}	groups: conditions
columns	resourceMapper	{...}	required
options	collection	{}	keys: dryRun

upsert

Parameter	Type	Default	Details
matchType	options	"anyCondition"	anyCondition, allConditions
filters	fixedCollection	{}	groups: conditions
columns	resourceMapper	{...}	required
options	collection	{}	keys: dryRun

Resource: table

create

Parameter	Type	Default	Details
tableName	string	""	required
columns	fixedCollection	{}	groups: column
options	collection	{}	keys: createIfNotExists

delete

Parameter	Type	Default	Details
dataTableId	resourceLocator	{...}	required; modes: list, name, id

list

Parameter	Type	Default	Details
returnAll	boolean	true
limit	number	50
options	collection	{}	keys: filterName, sortField, sortDirection

update

Parameter	Type	Default	Details
dataTableId	resourceLocator	{...}	required; modes: list, name, id
newName	string	""	required

Common Parameters

Parameter	Type	Default	Details
dataTableId	resourceLocator	{...}	required; modes: list, name, id

Parameter Details

filters children:

conditions group:

Parameter	Type	Default	Details
keyName	options	"id"
condition	options	"eq"
keyValue	string	""

options children:

Parameter	Type	Default	Details
dryRun	boolean	false

columns children:

column group:

Parameter	Type	Default	Details
name	string	""	required
type	options	"string"	boolean, date, number, string

Example

NODE "dataTable" AS "Data Table" {
  resource: "row",
  operation: "get",
  tableName: {{ $json.tableName }},
  newName: {{ $json.newName }}
}