Skip to main content
Nintex Community Menu Bar

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

  • Jan 23, 2020 3:26 PM UTC
  • 2 replies
  • 39 views
  • Translate All
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.

 

 

 

 

    2 replies

    • Anonymous
    • Jan 24, 2020 4:00 PM UTC
    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
    • s95f
    • Jan 24, 2020 4:05 PM UTC

    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
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement