Problem with XML elements

[ppr (Peter Preuss)]

@Majlopajlo
we cannot see the deatils of your xml. Maybe you can share the sample xml file, a screenshot or using the editor format option </>

One important question is, if the XML is defining namespaces.

lets assume the xml looks like this in the structure:
xDoc:

• root
  • leg
    • e1
    • e2
  • leg
    • e1
    • e2

retrieve all legs with xDoc.Root.Descendants(“leg”).toList - retuned: List(Of XElement) xeLegs

iterate over xeLegs within a for each and setup the element retrieval ( in this demo: e1,e2)

also have a look here:

Reading XML soup response with more than 1 namespace

Hello All, I am working on project now start with call soap API and read specific attribute from response I can read all response but can not read specific attribute my response XML look like below: [image] I want to read only “value3” attribute only so I tried below but return “Object reference not set to an instance of an object.” [image] and for name space declaration [image] [image] [image] Thanks in advance

XML Extract Data

Hello! I have an XML in which I have to extract several tags I need to filter this information in order to be able to assemble it in SQL. I hope you can help me This is my XML Thanks.

Read from xml file

@Zlotzky Setting up the quick prototype: Variables: Handling Namespace: [grafik] ElementNames to Extract - Prototype reduced set: [grafik] Read In XML [grafik] Ensure: [grafik] Retrieval of private contact element (mandatory use of the Namespace within the name) [grafik] iterating over the list of elmentnames (ExtractNames) and reading element value: [grafik] Logs: [grafik] Find starter help here: Zlotzky.xaml (6.3 KB)

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …