How to get and update the value of a attribute from the XML file

[ppr (Peter Preuss)]

ID - Company_Reference_ID

 xnsWD
 [urn:com.workdayi/bsvcdadass]
 xDoc.root.Descendants(xnsWD + "ID").Where(Function (x) x.Attribute(xnsWD + "type").value.Equals("Company_Reference_ID")).first()
 [<wd:ID wd:type="Company_Reference_ID" xmlns:wd="urn:com.workdayi/bsvcdadass">CMP0061</wd:ID>]
 xDoc.root.Descendants(xnsWD + "ID").Where(Function (x) x.Attribute(xnsWD + "type").value.Equals("Company_Reference_ID")).first().value = "ABC"
 "ABC"

ID - Supplier_Invoice_ID can be managed similar

It is always about handling xml namespaces

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…

Working with the immediate panel helps us for the prototyping

Please check also your other open topics and and mark the solved ones with the solution flag. Thanks