Schedule Workflow: Insert records into SQL Server table

  • 1 June 2020
  • 1 reply
  • 23 views

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.


1 reply

Badge +9

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/Logic/Loop/Loop.htm


 


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


 


-Jean

Reply