List Helper 2.1
The List Helper performs quick manipulations to an array of data.
When you are dealing with one or more lists of data, the List Helpers connector provides a range of operations to help you manage and manipulate your listed data as required.
You can combine data from multiple sources, sort it, extract certain values, find common items, create batches for processing...the "list" goes on!
See our operation summaries below for more ideas and information on your potential list and data manipulation options.
The List Helpers operations are primarily for dealing with pre-existing lists of data coming from other services (via workflow triggers or connectors)
If you wish to create a list from scratch the most common operation to use is the Append to List operation found in the Data Storage connector.
List Helper TemplatesCopy
Below are some relevant templates you may wish to use or learn from. The full range can be found in our Templates Library.
Templates demonstrate pre-configured best practices / common use cases as well as examples of how to use this connector and how best to integrate it with others.
IMPORTANT! Please make sure you read the notes and instructional sections on this page before using any of these templates. A basic understanding of this connector's capabilities will help avoid potential pitfalls during your own build process.
Your returned itemsCopy
Note that the List Helper will always return its results in the form of an array INSIDE of an object.
You will need to form a level of extraction to the results in order play with the array results themselves.
Note you can select a number of type formats whenever you are adding an item to a list.
This is not applicable to every property / operation but is very common and great for multiple use cases.
Add item to listCopy
Allows you to add an individual item to a pre-existing list
USER TIP: If you wish to add several items, please see Add multiple items to list below.
Add multiple items to listCopy
Allows you to add multiple items to a pre-existing list
USER TIP: If you wish to join two 'complete' sets of lists together, please see Concatenate below.
Creates smaller list sets from the original.
You will then need to use the Loop Connector to loop through each batch (which will often need to be sent to a sub-processing workflow to manage the scale and complexity of your data processing)
Joins two lists together
Checks your list for specified item
True if found
False if not
Counts how many items are in your list
Delete items from listCopy
Allows you to remove items you specify from a list
Allows you to compare two lists
Returns only the items that do not exist within the second
USER TIP: If you want to create a list of the duplicates found within both lists, use Intersection instead.
Allows you to filter your list for items for specific values
Find object in listCopy
Returns the first item found within your list
USER TIP: If you wish to return the opposite, please check out the Last operation below.
Get item by indexCopy
Allows you to numerically select the item you want to return
Get list of page numbersCopy
Divides your list into separate pages
Get unique items by keyCopy
Builds a new list of items based on the Key reference
For two given lists this operation returns only the items that exist in BOTH lists.
USER TIP: If you want to create a list consisting of the unique items found, use Difference instead.
Goes through the fields available and alters them as requested (capitalize, camelCase etc.)
Joins all the list items into a singular string
Returns the last item within a list
USER TIP: If you wish to return the opposite, please check out the First operation above.
A list of values if created from the item property referenced
Ensures no duplicate items exist
IMPORTANT!: This operation can only remove simple items from an array. It can't remove objects based on a particular field in that object being unique. If this is your requirement then please see the Useful scripts: Removing duplicate objects page for a potential answer.
Updates the name of a particular field
Reverses the order of a list
Rotate first itemCopy
Puts the first item in a list at the bottom
Sorts a list in ascending or descending order
Creates a new list based on a section of your current list
Allows you to put your items in ascending or descending order
Takes two lists and combines them into one item with corresponding properties