How to extract multiples records in same XML file (with namespaces)?

[ppr (Peter Preuss)]

@Jean_Piere_Ochoa
For working with XML having namespaces have a Look Here

XML Parse

Hi @mikamol Find the attached sample Main.xaml (8.1 KB) that is showcasing following: Retrieving all Field elements Retrieving all Id elements (Parent is Field) Retrieving the particular Answer Value for a particular Id As this XML is defining the namespace:` xmlns="urn:abou:documents:ka:Case The Root element Name is not Case it is: e.g. urn:abou:documents:ka:Case:Case So the namespace part is to take into account Solved with using namespace manager Kindly note the order from a XML Docu…

The steps given from @Yoichi are covering the Main actions for your scenario

ADDED: Link to some analysis techniques for 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</…