--- title: "Collection Tools Connector" slug: "collection-tools-connector" description: "Explore essential collection operations like adding key/value pairs, filtering, and validating JSON/XML schemas to enhance your data management skills." updated: 2026-07-17T15:43:41Z published: 2026-06-12T14:41:51Z canonical: "docs.lansweeper.com/collection-tools-connector" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.lansweeper.com/llms.txt > Use this file to discover all available pages before exploring further. # Collection Tools Connector Note on third‑party tools We aim to provide accurate and helpful details about third‑party tools, but we can’t guarantee that this information is always complete or up to date. If you notice any discrepancies, feel free to share them in the feedback section below. For the most reliable information, please always refer to the third‑party tool’s official documentation. 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](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. | |