Read XML wich different tags

[Felipe_Moura]

Hi,

My automatation are read many XML files. There is some tags can change. The exemple are below.

case 1:

case 2:

case 3:

in that 3 cases i want the get that value in “orig” but the way change.

this is my expression
currentXElement.Element(“imposto”).Element(“ICMS”).Element(“ICMS40”).Element(“orig”).Value

my doubt is:

how to make an expression to take any situation ICMS40, ICMS00, ICMS61? (there may be more variations, always ICMSXX)

[ppr (Peter Preuss)]

there are many options to have a more open retrieval like:

YourXDocumentVar.Root.Descendants("orig").First().Value

or

currentXElement.Element("imposto").Element("ICMS").Elements().First().Element("orig").Value

or

currentXElement.Element("imposto").XPathSelectElement("//ICMS/*/orig").Value

[Felipe_Moura]

@ppr

currentXElement.Element("imposto").Element("ICMS").Elements().First().Element("orig").Value

thx ppr. There expression below work well
currentXElement.Element(“imposto”).Element(“ICMS”).Elements().First().Element(“orig”).Value

[ppr (Peter Preuss)]

@Felipe_Moura
Perfect so the topic can be closed by

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…