- Here is a sample Input XML Document
- What if you would like to add the <price> element to the entire XML document for every book node?
Directly using the Insert XML element action inserts only to the first node mentioned in the XPath query.
- For doing this, first find out the count of book nodes.
Use an XPATH on the book node.
Since there are 4 books, the count property of the Output variable ie; %XPathResults.Count% will have a count of 4 in this example.
Note: There is a XPATH function called as Count() that is normally used to find out the count of nodes.
But this function did not seem to work in the above action. Perhaps, functions are not yet supported.
- To insert an XML element on every single node, you need to start with a Counter and have it running to every single book node.
Lets call it NodeCounter.
- Iterate this counter using a While loop until it reaches the last Book node.
Remember to increment it.
- The key part is to use this counter within the Xpath so that it applies to every book node of the XML.
Example: /bookstore/book[1] selects the first book element that is the child of the bookstore element
Since this is within a loop, the counter will be applied to all the book nodes of the XmlDocument
- This is how the entire Flow looks like
- After running the process you will see the price element for every single book node.
- At the end, you will have your new Xml in the variable called XmlDocument (not yet as a xml file).
Finally, using Write XML to file action use this variable to generate your final Xml file. (Reference video for writing to file here)
