Skip to main content

Collection Tools Connector

Collection Tools Common collection operations

Actions

Add Key/Value to Object

Add a value to an object with the given key

InputCommentsDefault
Object
KeyMy Comments
Value
Insert PathOptionally 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

InputCommentsDefault
Object
Insert PathOptionally define a path using dot notation of where to add the key/value
Dynamic Key/ValuesAdd 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/ValuesKey and value of the properties to add to the object. If provided, 'Key' and 'Value' inputs are ignored.

Aggregate

Apply aggregate function to list

InputCommentsDefault
ListReference to a list of data to operate on
Aggregate FunctionAggregate function to apply (choose from AVERAGE, COUNT, MAX, MIN, SUM, PRODUCT, MEDIAN).
Filter FunctionFilter out any elements that do not return true(item, index) => { return true; }

Append

Append element to the end of the list

InputCommentsDefault
ListReference to a list of data to operate on
ElementThe item to append to the end of the list

Chunks

Chunk the list into lists of the specified number of elements

InputCommentsDefault
ListReference to a list of data to operate on
Number of ElementsNumber of elements to take1

Combine Collection (Deprecated)

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

InputCommentsDefault
CollectionsReturns an object with the specified key and corresponding collection as the value

Concatenate

Concatenate two lists together into a single list

InputCommentsDefault
ListReference to a list of data to operate on
ListReference to a list of data to operate on

Count

Count the number of occurrences of element in list

InputCommentsDefault
ListReference to a list of data to operate on
ElementReference to an element to look for

Create List

Create a new list with the given inputs

InputCommentsDefault
List Items

Create Object

Creates a new object from provided key/value pairs

InputCommentsDefault
Key & Value PairsKey and value pairs

De-duplicate

De-duplicate the elements of the list

InputCommentsDefault
ListReference 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

InputCommentsDefault
Key Mappings
Value Mappings

Filter

Filter elements of a list

InputCommentsDefault
ListReference to a list of data to operate on
Filter FunctionFilter out any elements that do not return true(item, index) => { return true; }

First

Get first element from a list

InputCommentsDefault
ListReference to a list of data to operate on

Flatten

Flatten an array of arrays into a single array

InputCommentsDefault
ListReference to a list of data to operate on

Key Value Pair List to Object

Convert a Key Value list to an Object

InputCommentsDefault
Key/Value List

Last

Get last element from a list

InputCommentsDefault
ListReference to a list of data to operate on

Length

Count the number of elements in list

InputCommentsDefault
ListReference to a list of data to operate on

Map

Transform a list and its elements

InputCommentsDefault
ListReference to a list of data to operate on
Transform (map) FunctionFunction to transform each element(item, index) => { return item; }
Filter FunctionFilter out any elements that do not return true(item, index) => { return true; }
Context DataAdditional contextual data to supply to the transform and filter functions

Object to Key Value Pair List

Convert an Object to a Key Value List

InputCommentsDefault
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.

InputCommentsDefault
Collection IDA value that uniquely identifies the collection that is being processed out of order.
Collection LengthThe number of items in the collection. When processing is finished the interim data for the collection is removed.
ItemThe current item to consider for processing.
Item IndexThe 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

InputCommentsDefault
ListReference to a list of data to operate on
ElementReference 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

InputCommentsDefault
ListReference to a list of data to operate on
Index

Sort

Sort elements using a JavaScript comparison function

InputCommentsDefault
ListReference to a list of data to operate on
[
{
"name": "Widget",
"prop": 25
},
{
"name": "Thingy",
"prop": 10
},
{
"name": "Whatsit",
"prop": 19
}
]
Sort Comparison FunctionSort 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

InputCommentsDefault
ListReference to a list of data to operate on
Number of ElementsNumber of elements to take1

Take Last

Take last number of elements from a list

InputCommentsDefault
ListReference to a list of data to operate on
Number of ElementsNumber of elements to take1

Validate JSON Schema

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

InputCommentsDefault
JSON ObjectThe JSON object to validate against the schema.{"someProperty":"value"}
JSON SchemaThe 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.

InputCommentsDefault
XMLThe XML object to validate against the schema.
XML SchemaThe XSD schema to use in validation.