Use this stage to execute SQL commands which can be used to manipulate and retrieve data.
Saving values to SQL
Use standard field Placeholders in your Update SQL query.
Retrieve values from SQL
This stage returns the results of the SQL query that has been executed.
They can be accessed with the placeholder:
{{stages["stage-alias-here"]|property("0")|property("ID")}}
Where “0” is the result row number and “ID” is the name of the column.
Use this in combination with an Update Metadata field to save the values back to the item.
|
|
|
|