PostgreSQL Delete - Studio Modeling - Current - Current - Ready - Hyland Experience - external

Hyland Experience Studio Modeling

Platform
Hyland Experience
Product
Studio Modeling
Release
Current
License

The PostgreSQL DELETE action is used to execute a delete statement against a PostgreSQL database.

The input parameters for a delete 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:

DELETE FROM flavors
WHERE flavor = {type};
Note: The { } are declared without quotations.

The output parameters from a delete statement are:

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