Skip to main content

Working with lists

Accessing data in lists​

As described in Mapping data between steps you can directly access list data returned by workflow steps by using jsonpaths such as $.steps.hubspot-1.results[0].properties.email

The [0] being used here tells us that we are digging into the first object in the 'results' array.

This is the standard method of directly sending data from one system to another, if no transformation. filtering etc. is required

Manipulating lists (filtering, concatenating, extracting items etc.)​

Our List Helpers connector can be used for multiple list manipulation tasks including:

  • Adding items
  • Filtering to include / exclude items
  • Sorting
  • Plucking properties e.g. email addresses from each object
  • Remove duplicates
  • Count items

Please see our Academy List Helpers course for an interactive lab which can help you get started on working with our list helpers.

Building lists​

When building lists, List Helpers operations such as 'add item to list' and 'add multiple items to list' may meet your requirements.

However, it will sometimes be appropriate to make use of the Data Storage 'Append to list' operation.

This is because the List Helpers operations do not have data storage capacity.

The following example shows looping through an array of contacts in order to perform a minor transformation, create a new contact object and add it to a list that can be retrieved once complete:

append-to-list