Select
Input
✳️ Any (JSON)
Ouptut
✳️ Any (JSON) (Passthrough)
and / or
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.
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.
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, please see the Filter and Variable Reference documentation.
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 |
| 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 |
| Whether or not to enable append mode. The default is Discard other properties (Append mode off). |
Iteration Array | Array |
| 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: |
🅾️ Iteration Output Property | Text |
| Specify the property name to write the resulting iteration array to. Required if the Iteration Array is specified. |
