Hi,
I have requirement to update data on daily basis in azure SQL database table.
I will get xml on daily basis from Optiva system and i want to read it and based on data, update SQL data.
Page 1 / 1
Hello,
You should be able to implement a Workflow that calls to the Optiva system. Then you can set this up on a Schedule via the Workflow Scheduler to do this every day.
You should be able to implement a Workflow that calls to the Optiva system. Then you can set this up on a Schedule via the Workflow Scheduler to do this every day.
Hello,
To add to this, you will want to use the multivalue smartobject property to consume the XML and allow for it to be properly utilized in K2. I have included some documentation that covers the SmartObject properties.
As for the SQL part, if this is an external database to K2 you will want to use a service broker in order to communicate with the database. I will also include some documentation below regarding that.
-- Steven
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.