This action updates a database record. However, if the database record does not exist, a new record is created instead.
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.