Collection Tools Connector

The collection tools component contains actions that let you perform common tasks on collections of data (objects and arrays). You can do things like concatenate objects, filter items of lists (arrays), map functions on items, and more.

Actions

Add Key/Value to Object

Add a value to an object with the given key

Input	Comments	Default
Object
Key	My Comments
Value
Insert Path	Optionally define a path using dot notation of where to add the key/value

Add Multiple Key/Value to Object

Add multiple key/value pairs to an object

Input	Comments	Default
Object
Insert Path	Optionally define a path using dot notation of where to add the key/value
Dynamic Key/Values	Add an array of key/value pairs to the object. Please take note that the action will favor this input over the 'Key/Values' input.	`{ "someProperty": "value" }`
Key/Values	Key and value of the properties to add to the object. If provided, 'Key' and 'Value' inputs are ignored.

Aggregate

Apply aggregate function to list

Input	Comments	Default
List	Reference to a list of data to operate on
Aggregate Function	Aggregate function to apply (choose from AVERAGE, COUNT, MAX, MIN, SUM, PRODUCT, MEDIAN).
Filter Function	Filter out any elements that do not return true	(item, index) => { return true; }

Append

Append element to the end of the list

Input	Comments	Default
List	Reference to a list of data to operate on
Element	The item to append to the end of the list

Chunks

Chunk the list into lists of the specified number of elements

Input	Comments	Default
List	Reference to a list of data to operate on
Number of Elements	Number of elements to take	1

Combine Collection (Deprecated)

This version of the action is being deprecated. Please replace action with Create Object.

Input	Comments	Default
Collections	Returns an object with the specified key and corresponding collection as the value

Concatenate

Concatenate two lists together into a single list

Input	Comments	Default
List	Reference to a list of data to operate on
List	Reference to a list of data to operate on

Count

Count the number of occurrences of element in list

Input	Comments	Default
List	Reference to a list of data to operate on
Element	Reference to an element to look for

Create List

Create a new list with the given inputs

Input	Comments	Default
List Items

Create Object

Creates a new object from provided key/value pairs

Input	Comments	Default
Key & Value Pairs	Key and value pairs

De-duplicate

De-duplicate the elements of the list

Input	Comments	Default
List	Reference to a list of data to operate on

Field Value Mapping

Maps the values from two different collections and returns a key/value list where the 'key' is the value of the Key Mappings input and the 'value' is the value of the Value Mappings input

Input	Comments	Default
Key Mappings
Value Mappings

Filter

Filter elements of a list

Input	Comments	Default
List	Reference to a list of data to operate on
Filter Function	Filter out any elements that do not return true	(item, index) => { return true; }

First

Get first element from a list

Input	Comments	Default
List	Reference to a list of data to operate on

Flatten

Flatten an array of arrays into a single array

Input	Comments	Default
List	Reference to a list of data to operate on

Key Value Pair List to Object

Convert a Key Value list to an Object

Input	Comments	Default
Key/Value List

Last

Get last element from a list

Input	Comments	Default
List	Reference to a list of data to operate on

Length

Count the number of elements in list

Input	Comments	Default
List	Reference to a list of data to operate on

Map

Transform a list and its elements

Input	Comments	Default
List	Reference to a list of data to operate on
Transform (map) Function	Function to transform each element	(item, index) => { return item; }
Filter Function	Filter out any elements that do not return true	(item, index) => { return true; }
Context Data	Additional contextual data to supply to the transform and filter functions

Object to Key Value Pair List

Convert an Object to a Key Value List

Input	Comments	Default
Object

Process In Order

Ensures that payloads are processed in order across executions according to an ordering specified by a payload attribute. Returns the largest possible set of ordered payloads on the Process branch, and otherwise follows the Skip branch and returns the current item.

Input	Comments	Default
Collection ID	A value that uniquely identifies the collection that is being processed out of order.
Collection Length	The number of items in the collection. When processing is finished the interim data for the collection is removed.
Item	The current item to consider for processing.
Item Index	The integer value to consider as the index for the current item that specifies intended processing order. 0 is the first index value.

Remove

Remove all occurrences of an element from a list

Input	Comments	Default
List	Reference to a list of data to operate on
Element	Reference to an element to look for

Select Item From List by Index

Select an item by index from a list of items, supports nested lists

Input	Comments	Default
List	Reference to a list of data to operate on
Index

Sort

Sort elements using a JavaScript comparison function

Input	Comments	Default
List	Reference to a list of data to operate on	`[ { "name": "Widget", "prop": 25 }, { "name": "Thingy", "prop": 10 }, { "name": "Whatsit", "prop": 19 } ]`
Sort Comparison Function	Sort elements by the given comparison function. See https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/sort for compare function documentation.	(a, b) => { return a.prop < b.prop ? -1 : 1; }

Take First

Take first number of elements from a list

Input	Comments	Default
List	Reference to a list of data to operate on
Number of Elements	Number of elements to take	1

Take Last

Take last number of elements from a list

Input	Comments	Default
List	Reference to a list of data to operate on
Number of Elements	Number of elements to take	1

Validate JSON Schema

Validate a JSON input against a given schema, returning errors if not JSON input is not valid.

Input	Comments	Default
JSON Object	The JSON object to validate against the schema.	`{"someProperty":"value"}`
JSON Schema	The JSON schema to validate the input against.	`{ "type": "object", "properties": { "someProperty": { "type": "string" } }, "required": [ "someProperty" ] }`

Validate XML Schema

Validate an XML input against a given XSD schema, returning errors if XML is not valid.

Input	Comments	Default
XML	The XML object to validate against the schema.
XML Schema	The XSD schema to use in validation.

Actions​

Add Key/Value to Object​

Add Multiple Key/Value to Object​

Aggregate​

Append​

Chunks​

Combine Collection (Deprecated)​

Concatenate​

Count​

Create List​

Create Object​

De-duplicate​

Field Value Mapping​

Filter​

First​

Flatten​

Key Value Pair List to Object​

Last​

Length​

Map​

Object to Key Value Pair List​

Process In Order​

Remove​

Select Item From List by Index​

Sort​

Take First​

Take Last​

Validate JSON Schema​

Validate XML Schema​