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
B
Forum|alt.badge.img+7
  • BB33
  • Novice
  • 16 replies

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.

 

 

 

 

    Did this topic help you find an answer to your question?

    2 replies

    A
    • Anonymous
    • 0 replies
    • 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
    S
    • s95f
    • 5 replies
    • 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


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    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