Insert Database Record(s)

Use this action to add a new record or multiple records to a database table.

Select a database

If Profound.js has been configured for multiple connections, this allows you to select the appropriate database connection for this step. If a database is not selected, the default connection will be used.

Specify a database table

Select a database table to insert the record(s) into.

Where will record values come from?

Database record values can be specified individually, retrieved from matching fields on a screen, from a list of records, or retrieved from a work variable/property that is classified as a record.

Fill in column values

For each table column you would like to populate, select or type in a value.

Specify the list of records to process

Provide a reference to a list of records.

Number of records for each INSERT, for multi-insert

Type in a number to indicate the number of records on each INSERT request, for multi-insert.

Enter work variable name

A work variable is accessible by other steps within the same routine. Some work variables, like 'activeGridRecord' are implied and don't have to be explicitely defined by you.

Specify input variable

The API input represents the parameters attached to the API request. Parameters can be attached to the request path, query string, header, or body.

Capture results into

Capture result information into an output property or into a work variable. The captured information is an object with the following properties:

success
affectedRows
insertId
message
sqlcode

When not successful, the message and sqlcode properties can help inform the user as to why it failed.