How to Aggregate Array Line Items after Looping Iterations

How to Aggregate Array Line Items after Looping Iterations

Contributed by: Troy Tessalone - Automation Ace - Certified Zapier Expert

About

Looping an array of line items is one thing in a Zap, but aggregating an array of line items is another in a Zap.

Arrays

Think of line items in an array like the items in an ecommerce order. (1 Order can have 1+ Items)

Use Case

You want to perform some action(s) on each line item in an array, then continue the Zap steps with the aggregated line items. (e.g. very basic example - adjusting the format of each item to be UPPERCASE)

Apps

These native Zap apps by Zapier count as 0 Tasks in Zap Runs.

• Delay
• Filter
• Formatter
• Looping
• Storage

Resources

Steps

1. Trigger: [APP] - [EVENT]
   1. UP TO YOU!
2. Action: Formatter > Text > Default Value
   1. Use a UNIX Timestamp to get a unique ID for use in following Zap Storage steps
   2. Help: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
3. Action: Looping - Create Loop from Line Items
   1. Handles arrays of line items
4. Action: Formatter > Numbers > Perform Math Operation
   1. Used so the loop iterations process sequentially in order
   2. See the help article above.
5. Action: Delay - For
   1. Delay For (minutes)
   2. Map the output from the previous Formatter step
6. Action: [APP] - [EVENT]
   1. UP TO YOU!
   2. Example: Formatter > Text > Uppercase
7. Action: Storage - Push Value onto List
   1. Adds Items to the Array
8. Action: Filter
   1. Loop Iteration is Last = true
9. Action: Storage - Get Multiple Values
   1. Use the lookup key from Step 2
   2. Will return an array with items that were processed during the loop iterations
10. Action: [APP] - [EVENT]
    1. UP TO YOU!
    2. e.g. Add Items to an Order
11. Action: Storage - Remove Value
    1. Remove the Storage Value as it’s no longer needed since the Zap Run has completed

Steps - Details

TIP

If you want to flatten the array line items, like a digest, then use this Zap action: Storage - Get List Values