How to loop over a collection of objects

I have an IPA flow that collects employee data from multiple SQL queries. I have stored the data in an object called oEmployees with a key of the employee number: oEmployees[empnum].

Now I need to loop over the oEmployees object and send an email to each employee. What is the best way to loop over an object to send an email using the Email node? My initial thought is the For Each loop but not sure how to setup the looping statement.

Shawn Van Sluys

0712050809193544.doc

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

jreese

Could you read through the oEmployees object using the Data Iterator node?

Legacy Contributor

Update: I was not able to get the Data Iterator node to work (or maybe I was doing it incorrectly). However I did find an alternative way.

1) I had the original object of arrays as object oEmployees[empnum]

2) I added an assign node with javascript to build an array of 'key' (empnum) data with the following code:

var employeesKeyArray = [];

for (var key in oEmployees)

{

if (oEmployees.hasOwnProperty(key))

{

employeesKeyArray.push(key);

}

}

3) I added a ForEach loop with Select Option of "Array" and Array Input of <!employeesKeyArray>. This then loops through each of the individual records in the original oEmployees object.

Not sure this is the best or most efficient way but it works for me and runs quickly.

If anyone has any other suggestions please let me know.

Otherwise, hope this also helps someone else in the future.

Shawn Van Sluys

Copyright © 2025 Infor. All rights reserved.