DATABASE_WRITE

Allows data to be written to external databases. Supported databases include MySQL, SQL and Postgres.

Properties

Database Connection
dbwrite_connection

A reference to the database connection record that contains the details on how to connect to the remote database service. Database connections can be defined in the project settings view. An empty value enables a custom connection string to be set.

Database Connection Template (Use DB record ID) ${}
dbwrite_connection_template

When the connection is not set, allows the connection URI to be set as a URI. This field accepts template syntax.

Collection / Table name ${}
dbwrite_collection

The database table or collection that the action will access once connected to the database.

Out Key
dbwrite_outkey

The namespace where the results of an insert action will be stored.

Record Identifier Template
dbwrite_recordIdentifierTemplate

The label that is used to identify database write logs in the Outbound Record Logs.

Fields
fields

A set of records that are used to define process data keys that are to be included when executing various actions.

Field Key
fields[].key

Where to find or set the data in the process data. Uses dot notation conventions.

Value ${}
fields[].value

The value to set in the process data. Accepts template syntax.