Advanced List Processing

Table of Contents

Learn more about how you can format lists for display, search and join, pluck to process a subset of the data pills in a list, perform arithmetic operations (sum, average etc), charting operations on lists and process HTTP requests.

List processing operations reviewed in this webinar

How to format lists for display

  • Useful when you want to send a report using email/SMS or other messaging applications (e.g. Slack)

How to search for specific elements in the list and reference them using pluck

  • How to search using where
  • Using Simple and compound search criteria
  • Using pluck to reference specific data pills
  • How to reference the first, second, Nth value in the list from the start and from the back

How to use arithmetic operations to calculate sum and average

  • How to use sum to compute the total value of line items e.g. total invoice value, total order value etc
  • How to compute average value for a element in the list using SUM and LENGTH

Overview of lists generated by HTTP requests

  • Simple lists
  • Nested Lists

Click here for the example recipe used in the Webinar

Please send your questions and suggestions to support@workato.com. Click here to register for an upcoming product hour

 

 

Was this post useful?

Get the best of Workato straight to your inbox.

Table of Contents