Manipulate and manage array data.
Parameter | Description |
---|---|
Existing JSON List Or Object | The JSON list or object to which the new object will be appended. Note that nested keys are only applicable to JSON objects, not lists. If the existing JSON is a list, direct appending to the end of the list is used. Also, ensure that the nested key provided points to an existing JSON list inside the JSON object. |
JSON Object To Append | The object data to append. |
Nested Object Key | The nested object key to append the data to. This parameter can only be used when the existing JSON is an object. |
Parameter | Description |
---|---|
Variable Name | The name of the variable. |
Item | Item to add to list. |
Parameter | Description |
---|---|
First Array | The first array to compare with the Second Array . Value must be a valid array or a comma-separated list. |
Second Array | The second array to compare with the First Array . Value must be a valid array or a comma-separated list. |
Ignore Order | When checked, arrays will be considered equal even if elements appear in a different order. |
Loose Typing | When checked, enables type coercion during comparison (e.g., number 12 equals string "12" , boolean true equals string "true" ). |
Parameter | Description |
---|---|
First Array | The initial array whose elements will appear at the beginning of the result. Value must be a valid array or a comma separated list. |
Second Array | The array whose elements will be appended after the first array. Value must be a valid array or a comma separated list. |
Remove Duplicates | When checked, repeated values in the final combined array are removed. |
Parameter | Description |
---|---|
Array | The array from which to extract the specified field. Value must be a valid array or a comma-separated list. |
Field Path | The name or path of the field to extract from each array item.
[{"userId": "user123","details": {"id": "id123"}},{"userId": "user789","details": {"id": "id789"}}]
|
Skip Missing | When checked, records with missing fields will be excluded from the result. When unchecked, records with missing fields will be included with null values. |
Remove Duplicates | When checked, repeated values in the final array are removed. |
Parameter | Description |
---|---|
Variable name | The name of the original list variable |
List to append | The name of second list to append. |
Value | Name of the item to append to the list |
Filter Function
.
Parameter | Description |
---|---|
Array | The array to be filtered. Value must be a valid array or a comma-separated list. |
Filter Function | A Python function that determines which elements to keep in the array. The Filter Function is executed individually for each element in the input Array . For every element, the function should:
For example: def even(n): return n % 2 == 0 |
Parameter | Description |
---|---|
Array | The array from which to retrieve an element. Value must be a valid array or a comma-separated list. |
Index | The position of the item to get. The first item has an index of 0 . |
Parameter | Description |
---|---|
List | The JSON list to remove duplicates from. For example: The input list [1,2,2,1] will result in the output list [2,1] . |
Parameter | Description |
---|---|
Existing JSON List Or Object | The JSON list or object from which the object will be removed. Note that nested keys are only applicable to JSON objects, not lists. Also, ensure that the nested key provided points to an existing JSON list inside the JSON object. |
JSON Object To Remove | The concrete object to remove. Ensure that the provided object is equal to the desired object to remove. |
Nested Object Key | The nested object key to remove the data from. This parameter can only be used when the existing JSON is an object. |
[8,12,2,6]
will result in the output list: [6,2,12,8]
.
Parameter | Description |
---|---|
List | The JSON list to reverse. For example: The input list [1,2,3] will result in the output list [3,2,1] . |
Start Index
and End Index
.
The new array will contain elements from the source array beginning at Start Index
(inclusive) up to but not including End Index
(exclusive).
Parameter | Description |
---|---|
Array | The array to slice elements from. Value must be a valid array or a comma-separated list. |
Start Index | The index of the first element to include in the slice.
|
End Index | The index of the element after the last element to include in the slice.
|
Parameter | Description |
---|---|
Array | The array to be sorted. Value must be a valid array or a comma-separated list. |
Order | Select the sorting direction for the array. |
Comparison Function | A Python function used to extract a comparison key from each element. Used for sorting complex or mixed-type arrays. This function must return a comparable value. For example: def myFunc(item): return item[‘property’] |
Parameter | Description |
---|---|
Array | The array to be sorted. Value must be a valid array or a comma-separated list. |
Chunk Size | The maximum size of the chunks that will be created. |
Get Response As JSON Object | Select to get the result as JSON object instead of a nested array. |