Update or Insert Database Record

This action updates a database record. However, if the database record does not exist, a new record is created instead.

Open

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 update or insert the record into.

Selection criteria expression

Provide a WHERE-clause expression to identify the records. Use the dropdown to create the expression without having to write code manually.

Question marks (?) in the expression are used to identify dynamic values, which are also referred to as selection parameter values. For each question mark, you will be prompted to provide a selection parameter value, where you can select or manually type dynamic content.

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.

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.