List Helpers 3.0
List Helpers can perform quick manipulations to an array of data.
OverviewCopy
When you are dealing with one or more lists / arrays 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.
Important notesCopy
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.
Data typesCopy
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.
OperationsCopy
Add item to listCopy
Allows you to add an individual item to a pre-existing list.
Note that the operation doesn't store any data - it just adds to a list and then "forgets" the information.
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.
ChunkCopy
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)
ConcatenateCopy
Joins two lists together
ContainsCopy
Checks your list for specified item
Returns:
True if found
False if not
Count itemsCopy
Counts how many items are in your list
Delete items from listCopy
Allows you to remove items you specify from a list
DifferenceCopy
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.
FilterCopy
Allows you to filter your list for items for specific values
Find object in listCopy
FirstCopy
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
IntersectionCopy
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.
Iterative transformCopy
Goes through the fields available and alters them as requested (capitalize, camelCase etc.)
JoinCopy
Joins all the list items into a singular string
LastCopy
Returns the last item within a list
USER TIP: If you wish to return the opposite, please check out the First operation above.
PluckCopy
A list of values is created from the item property referenced. Useful for extracting e.g. all email addresses for every contact in a list.
Remove duplicatesCopy
Removes all duplicates from a list. Can be used for removing both simple items and objects
Rename keysCopy
Updates the name of a particular field
ReverseCopy
Reverses the order of a list
Rotate first itemCopy
Puts the first item in a list at the bottom
Simple sortCopy
Sorts a list in ascending or descending order
SliceCopy
Creates a new list based on a section of your current list
Sort objectsCopy
Allows you to put your items in ascending or descending order
ZipCopy
Takes two lists and combines them with key / value pairs created for each item