Skip to main content
Nintex Community Menu Bar

How to consume xml file in K2 Coud to update azure SQL database data?

  • January 23, 2020
  • 2 replies
  • 2 views
  • Translate

Forum|alt.badge.img+7

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.

 

 

 

 

  • January 24, 2020
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.
Translate

  • January 24, 2020

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.


 


https://help.k2.com/onlinehelp/k2cloud/userguide/current/default.htm#Create/SmartObjects/SmOProperties.htm?Highlight=xml


 


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.


 


https://help.k2.com/onlinehelp/k2cloud/userguide/current/default.htm#ServiceBrokers/SQLServer/SQL-Server-Service.htm


 


-- Steven 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings