Select

Input	Ouptut
Any (JSON)	Any (JSON) (Passthrough), and/or Plus Filtered Dataset of Changes (object/array)

Summary

The select action has two modes. Depending on the mode selected, the Select action will operate on the entire dataset, or just a tabular dataset array.

Note: The expressions in the Select column definitions are case-sensitive. Be sure to inspect the previous action’s output to ensure that your property names are correctly cased.

Standard Mode

The select action, in standard mode, allows you to modify the dataset on the pipeline in almost any way.

You can add new properties, rename existing properties, hard-code new or existing values, and remove properties that are no longer needed.

Array Mode

The select action, in array mode, will iterate over a tabular dataset array and manipulate each object (“row”) in the array (“table”). Similar to standard mode, you can add properties (dynamic or hard-coded), rename properties, remove unwanted properties, and more.

Warning! Array mode expects a tabular dataset - that is, it expects an array of objects, where each object has the same column names. If the input array property does not meet these requirements, the action will fail.

Array Mode Templates

In array mode, you can reference the entire input object with the input keyword. Additionally, specifically in array mode, you can reference the current object/row with the item keyword.

For example, to divide a numeric field by 100, you might enter {{ item.myNumber / 100 }} into a select value.

For more information, see the Filter and Variable Reference.

Keeping or Discarding Other Data (Append Mode)

If Keep Other Properties is selected, the Select action will output all previous input data that it receives, in addition to the results of the Select action.

• In Array Mode, append will write the new array to the property you specify in the Iteration Output Property field.
• In Standard Mode, append will write any new defined properties to the root of the data context object, overwriting any properties/objects that may have existed before.

If Discord Other Properties is selected, then the Select action will output only the properties that you define in this step.

• In Array Mode, append will write only the new array to the property you specify in the Iteration Output Property field. The resulting data context will have only one item in it - the array item you specified.
• In Standard Mode, append will write any defined properties to the root of the data context object and pass only those properties to the next action.

Properties

Name	Type	Templatable	Notes
Columns	List	Yes	Specify the columns to map as well as their values. Column names must be statically configured, but values can be templated. For more flexibility, you may use the Execute JS action instead.
Append	Select	No	Whether or not to enable append mode. The default is Discard other properties (Append mode off).
Iteration Array	Array	Yes	If provided, will cause the Select action to iterate and transform the contents of the array, instead of the root data context object. Provide a JSON array of objects from a previous step, such as the Fetch IQA Data action, e.g. in the format: {{ input.myIqaOutput }}
Iteration Output Property	Text	No	Specify the property name to write the resulting iteration array to. Required if the Iteration Array is specified.