List and hash formulas FAQs ​

A list in Workato is an ordered, integer-indexed collection of objects, similar to arrays in other programming languages.

You can access items in a list using indexing, starting at 0. For example, number_list[0] would access the first line item.

Yes, Workato supports negative indexes for lists. For example, number_list[-1] would access the last item in a list.

The first formula returns the first item in a list. The last formula returns the last item in a list.

A hash in Workato is a collection of unique keys and their corresponding values. Unlike lists, hashes allow you to use any object type as keys.

Lists of hashes represent complex data structures where each item in the list is a hash with multiple key-value pairs. Lists of hashes are often used for organizing and processing structured data.

You can access values in a hash using the keys. For example, line_item["item_name"] accesses the value associated with the item_name key.

Workato doesn't support a direct union (&) operand. To achieve a similar result, you can combine lists using the concat formula and then remove duplicates with the uniq formula. Learn how.

To find the difference between two lists, you can use the subtraction (-) operand. For example, list - updated_list returns the items present in list but not in updated_list.