I am reading email metadata from a mailbox using a smart object which returns list of records. Each item in the list has number of attributes pertaining to emails fetched by SmO.
This is being done by a schedules WF.
I need to insert all the items in the list into a SQL server table.
How do I design a WF which can loop through list items and insert data into SQL server table?
So if SmO fetched metadata for 10 emails, there should be 10 corresponding entries in the table.
Have you tried looking at the loop step?
Inside of the loop you can use a SmartObject to insert data into the table?