SQL Server Insert - Studio Modeling - Current - Current - Ready - Hyland Experience - external

Hyland Experience Studio Modeling

Platform
Hyland Experience
Product
Studio Modeling
Release
Current
License

The SQL Server INSERT action is used to execute an insert statement against a SQL Server database.

The input parameters for an insert statement are:

Parameter Type Required Description
query String Required The query to execute against the database
metadata JSON Optional The list of parameters to pass to the query

The metadata parameter can be used to pass variables into the query parameter.

For example, if the contents of metadata are:

{
"type" : "mint"
}

This can be used in the query parameter as:

INSERT INTO flavors (flavor)
VALUES ({type});
Note: The { } are declared without quotations.

The output parameters from an insert statement are:

Parameter Type Required Description
result Integer Optional The number of rows in the database that were affected by the statement