Welcome to an article on how to update XML in SharePoint 2013 and Office 365 using Nintex Workflows. This article will display the action “Update XML” and how to configure.
Using this action you can update the XML and extract the updated file as attachment in your format you want which we will see on the configuration part of the workflow. Let’s see the implementation of this functionality.
- Create a list, Dev Testing.
- Click on the LIST tab on the Top ribbon and click on Nintex Workflows.
- You will see the following screen, to create a new workflow.
- Click on “Create new workflow”.
- You will come to the design phase of the Nintex workflows.
- Add the action, “Update XML” either by right click on the workflow or by dragging and dropping from the left toolbox.
- Now let’s configure it.
- When you double click on the action the following screen opens up.
- XML source: Here provide the source of the file where the xml has been stored on the site.
- XPath query: Provide a path to retrieve nodes in an XML file.
- Selected node(s) action: You can select node action as how do you want to update the xml.
- – Replace Node Contents: By replacing the content of the node.
- – Add Child Node: By adding a child note
- – Set Node Text: By setting a node with the text value.
- Value: Add in the value that you want to get updated.
- Store result in: You can store the updated XML as an attachment or to use a URL to a specific library or list.
- Result XML: Here you can specify a variable to store the content of the XML also.
- Now we have configured our workflow, let’s go and publish it to use it.
- Click on Publish on the left corner of the ribbon of Nintex Designer.
- You will see the following screen:
- Give your workflow a name.
- Choose your task list where it should store the tasks, It will be Workflow Tasks by default.
- Choose your history list where it should store the history logs, It will be Workflow History by default.
- Start Options:
- – You can either start your workflow manually.
- – Or you can start your workflow automatically when an item is created. In our case we will make it as Start when items are created.
- – Or you can start your workflow automatically when an item is modified.
- Click on Publish.
- Your workflow will get published.
The values which you received and store in the variables can be updated to a list item so when you run this workflow, it will create a new item with all the values of the variables updated on the list as an item.
Hence all the values under the nodes in the xml can be updated and extracted to the list attachments thereby making it easy to update the data in one xml or multiple xml thereby relieving you of lot of efforts.
So in this article we saw how to update XML in SharePoint 2013 and Office 365 using Nintex Workflows, we will see more new articles on the actions of Nintex Workflows in the other parts of the article. Till then, keep learning!