Array management for tailored data manipulation.
USM Content
When accessing an external API, the data often needs to be filtered or structured in the way you want it. You may need to add, remove, sort, or manipulate the data. With Array Management functions, you can customize the data to suit your needs without writing your code or modifying the backend service.
Array Management modules
In the descriptions below, bold words indicate fields in the modules.
When in doubt about a field in a module, hover over the question mark next to the field. You will get a brief description of the field function.
Add Object To Array
It enables you to append a new Object you enter to an existing Array. This is particularly useful when building or modifying arrays dynamically during workflow execution.
Ensure that the array you're adding to is structured as an array of objects, since this module is intended for arrays of objects, not simple lists or arrays of values.
Delete From Array
Remove a specified Entry from an Array. The Entry defines which object or entry should be removed, with the first entry being 1, the second being 2, and continuing sequentially.
For other array utilities, the first entry is 0, the second is 2, and so on.
Extract Field From Array
Extract a specific Key from an Array, with an array or a CSV as the Output. Use this module when creating a simplified list from complex data structures, such as generating dropdown options or preparing data for further processing.
Ensure the Key entered matches a Key contained in the Array selected.
Offset Array
Retrieve a subset of data from an existing Array, starting at a specified Offset. You must specify the Trim Size, which will be the size of the resulting array.
For example, if the original array has ten entries, Trim Size is set to 4, and Offset is set to 3, the resulting array will consist of entries 3 to 6 from the original array.
The offset is zero-based, meaning an offset of 0 refers to the first element in the array.
Pick From Array
Allows you to retrieve a random entry from an Array to use elsewhere.
Size/Length
Returns the number of entries of the defined Data. This module is practical when you need to assess the size of a dataset for iterations or conditional logic within your workflows.
Sort Object Array
Enables you to sort an Array by the value of any field in the object structure of an array. You must specify the Sort Field, which defines the object to sort by, and the Sort Order, which is ascending or descending.
Be aware that the module may have limitations when dealing with arrays that contain nested objects. In such cases, sorting may not function as expected.
Trim Array
Enables you to reduce an Array to a specific number of items. You must specify the Trim Size, which will be the size of the resulting array.
The module retains items from the beginning of the array. If you need specific items, consider sorting the array beforehand.