Extracting Data from XML file having tags in format <SAP:Retry>

[anjasing (Anjali)]

Hi, I’ve this XML File which has tags as SAP:Stack and while I am passing value as below it’s giving me issue

Var = xDocError.Descendants(“SAP:Stack”).toList

Issue: Assign: The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name.

P.S.>> It has all tags in the same format only
for e.g. SAP:Retry; SAP:Stack etc

Please help!

[ppr (Peter Preuss)]

@anjasing
You need to handle the XML Namespaces as described here:

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</…

[anjasing (Anjali)]

Below is the XML content. Can you please help here?

==================XML Content ===============

<SAP:Error xmlns:SAP=“http://sap.com/30” >

SAP:CategoryXIProxy</SAP:Category>

SAP:AdditionalText/

SAP:StackError during proxy </SAP:Stack>

SAP:RetryM</SAP:Retry>

</SAP:Error>

========================================
I’ve tried but it’s giving issue. If you can help here!

[ppr (Peter Preuss)]

please share the XML as text file or use the </> from editor for properly sharing the snippet. Thanks

[anjasing (Anjali)]

xml.txt (428 Bytes)

Thank you so much for helpingg…

[ppr (Peter Preuss)]

As mentioned above:

• Handle the XMLNamespace and we can retrieve e.g:

[anjasing (Anjali)]

Thank you so much…for the help … It really helped a lot.