Icon

Perform Table Operation

Add the Perform Table Operation action to make changes to table service attributes, table global attributes or table people attributes. For example, this is useful to process certain data that is first available after other actions in the workflow are completed (e.g. a Set Person Attributes and Identifiers action).

Configuration

Item

Explanation and Tips

Action Name

Optionally specify a friendly name for the action. This name must be unique in the workflow.

Attribute category

Specify if changes apply to a table service attribute, a table global attribute or a table people attribute.

Table attribute

Select the table attribute to perform the Operation on.

Select row

Set a new selected table row, based on a match between a specific table column and column value.

  • In the using value field, specify the column value. You can specify values manually, via attributes or functions, or a combination.

Add row

Add rows to the table columns.

  • The added row becomes the "current selected row". This means you can add another action to the service and refer to this row. However, if you specify an invalid value, the service workflow loses the "current selected row" and you have to set it again, before you can refer to it.

Edit row

Edit a table row, based on a match between a specific table column and column value. You can also edit the current selected row.

  • Select the columns that contain the values you want to change. When the action is executed, only the selected columns are changed with the specified values.

Delete row

Remove a table row, based on a match between a specific table column and column value. You can also remove the current selected row.

Filter table

Filter the table of the selected attribute to create a subset of data for this specific service workflow.
For detailed information, see Configure a filter for a table attribute.

  • This action adds an exception to the workflow. This allows you to specify what should happen when for example a specified row cannot be found. For global attributes, exceptions can also occur when two services try to update the same global attribute (e.g. service A deletes a record and service B tries to update that same record that now no longer exists.
See also