kanwarnitin
Scholar

Schedule Workflow: Insert records into SQL Server table

Hello,

 

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.

 

Thank you.

0 Kudos
Reply
1 Reply
JeanSmit1
Apprentice

Re: Schedule Workflow: Insert records into SQL Server table

Hi kanwarnitin,


 


Have you tried looking at the loop step?


https://help.k2.com/onlinehelp/K2Five/UserGuide/5.3/default.htm#K2-Workflow-Designer/Use/Toolbox/Log...


 


Inside of the loop you can use a SmartObject to insert data into the table?


 


-Jean

0 Kudos
Reply