Read from xml file

[Zlotzky (Goran)]

I would need some help extracting contact information from an xml file.
The xml looks like this

and set a flow as follows

where the for each item
xdocXML.element(“Values”).elements(“br-kontakt-privat”)

[ppr (Peter Preuss)]

@Zlotzky
your xml is defining a namespace.

have a look here for an example on how to handle namespaces

Extract Data from XML

@Htwe_Ko_Ko_Wynn your XML is defining several namespaces which is to handle for the retrieval find starter help here: GetElements_Namespace-ATOM.xaml (7.4 KB) Preview to the logs: [grafik]

Extracting XML Attribute value

@akshayajeyachandran find a demo here: XMLWithNameSpace_GetAttribute.xaml (5.0 KB) working with following demo xml: demoNamespaceGetAttribute.xml (166 Bytes) have alook on how the namespace is defined and be used for the element / Attribute retrieval

Not able to fetch one item from RSS Feed XML file - XML Namespace

@sachinns looking at the returned RSS Data I encountered that the namespace definitions are returned. So it differs from rss returned by the Link. However it made it more clear to the implementation media:thumbnail - the element thumbnail is defined under a particual namespace with the prefix media adding a variable of type XNamespace with the namespace value allows to access the element thumbail with following syntax: [grafik] as mentioned working with local name would look like this: [gr…

[Zlotzky (Goran)]

I never managed to solve it. I attach the xml file here if anyone has the opportunity to check it out
XML_CaseUipath.xml (1.7 MB)

[ppr (Peter Preuss)]

@Zlotzky
Setting up the quick prototype:

Variables:
Handling Namespace:

ElementNames to Extract - Prototype reduced set:

Read In XML

Ensure:

Retrieval of private contact element (mandatory use of the Namespace within the name)

iterating over the list of elmentnames (ExtractNames) and reading element value:

Logs:

Find starter help here:
Zlotzky.xaml (6.3 KB)

[Zlotzky (Goran)]

huge thanks, now I get it!