Modify SQL Data
Insert/Update/Delete data in structured schema
Parameters¶
| Label (internal name) | Type | Default | Description |
|---|---|---|---|
| Schema Variable Name (var) | string | DbDescriptor | Name of the variable where schema is stored. |
| Table Name (tableName) | string | Default table name used for manipulating rows. Free SQL queries can use other defined tables names | |
| Input Data (input) | string | $ | Use JSONPath to select input data from .Vars or .JsonBody (as a slice) |
| Free SQL query (global_sql) | textarea | Free SQL Query. It is fed with the input data first value if there is one. | |
| Per-Row Command (command) | Possible Values Below | SQL Command to apply on each row of input data | |
| • Insert Row (insert) | command | ||
| • Upsert Row - Update on insertion conflict (upsert) | command | ||
| • Update - specify WHERE clause below (update) | command | ||
| - Keys (keys) | string | List of keys to use for updating, if input value does not have a primary key | |
| - Additional Where (where) | string | Additional where clause to restrict update data, use {{.Vars.Row.FieldName}} to access current loop value. | |
| • Delete Row (delete) | command | ||
| - Keys (keys) | string | List of keys to use for updating, if input value does not have a primary key | |
| - Additional Where (where) | string | Additional where clause to restrict update data | |
| • Free SQL query (sql) | command | ||
| - SQL (free) | textarea | Free SQL Query |