Crate Db

Node: crateDb · Full type: n8n-nodes-base.crateDb · Version: 1

Credentials

crateDb (alias: @crate)

CREDENTIAL @crate = crateDb "My Crate Db"

Operations

executeQuery

Parameter	Type	Default	Details
query	string	""	required

insert

Parameter	Type	Default	Details
schema	string	"doc"	required
table	string	""	required
columns	string	""
returnFields	string	"*"

update

Parameter	Type	Default	Details
schema	string	"doc"	required
table	string	""	required
updateKey	string	"id"	required
columns	string	""
returnFields	string	"*"

Common Parameters

Parameter	Type	Default	Details
additionalFields	collection	{}	keys: mode, queryParams

Parameter Details

additionalFields children:

Parameter	Type	Default	Details
mode	options	"multiple"	independently, multiple
queryParams	string	""

Example

NODE "crateDb" @crate AS "Crate Db" {
  operation: "executeQuery",
  query: {{ $json.query }},
  schema: {{ $json.schema }},
  table: {{ $json.table }},
  updateKey: {{ $json.updateKey }}
}