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.