Extract Data From Deserialized XML file

[Ying_Zhu]

Hey guys, i have touble extract data under , i use
xmlrez.Element(soapenv+“Envelope”).Element(soapenv+“Body”).Element(“CallBranchOut”).Element(“DataFromTFS”).Value and give the data below without error,

but when i try to move on to the data, i keep receiving error like ‘Assign: Object reference not set to an instance of an object.’

xmlrez.Element(soapenv+“Envelope”).Element(soapenv+“Body”).Element(“CallBranchOut”).Element(“DataFromTFS”).Elements(“Documents”).Elements(“Document_Record”).Elements(“Available”).Value.ToString

not sure which part goes wrong that con’t return the details

[Gokul001 (Gokul Balaji)]

Hi @Ying_Zhu

Check out this blog

How To Extract The Data From A XML file - In UiPath - ExcelCult

Regards
Gokul

[Ying_Zhu]

hi, i’ve checked but not sure what goes wrong in my code

[Sudharsan_Ka]

Hi @Ying_Zhu

Have you checked this ?

Reading XML files - Deserialize XML activity

Find following starter help: [grafik] typeArguments of the different fore each are set to XElement: item = xDoc.Root.Descendants("node") item.Attribute("id").Value item2 = item.Elements("property") "Name: " & item2.Attribute("name").Value attrName = {"ref","value"}.Where(Function (x) item2.Attributes.Any(Function (a) a.Name.LocalName.Equals(x))).First() attrName + ": " + item2.Attribute(attrName).Value Log: [grafik]

Deserialize XML

This should help: How to iterate and read xml documents The key is to use For Each loops to get all similar elements. Sample here [image]

Regards
Sudharsan

[ppr (Peter Preuss)]

From your input

@Ying_Zhu

Element(soapenv+“Envelope”).

we would assume, that a SOAP xml with typically defined XML Namespaces is to handle

The details / XML Namespace definitions we cannot derrive form your snippet. Also the xml snippet and the code snippet are not matching (Element Structures)

So we recommened:

• Analysing / Handling XML Namespaces:
  XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

Prototypings:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

feel free to share with us the XML as Textfile and let us know your detailed extraction needs

[Ying_Zhu]

@ppr

ow your detailed extraction needs

soap_xml.txt (1.6 KB)
Hi ppr, thanks for your help, txt file of xml from UiPath is attached, the detail data i need to extract is Status, DOCDATE1, DOCNUMBER1, DOCNUMBER2

<SOAP-ENV:Envelope xmlns:SOAP-ENV=“http://schemas.xmlsoap.org/soap/envelope/” xmlns:SOAP-ENC=“http://schemas.xmlsoap.org/soap/encoding/”>
SOAP-ENV:Body


list R55U03B501_PXPKG SUCCESS YES pdf 14-81847883-1 2021-09-30 00:00:00 A OK SMOG REPAIR & REGISTRATION 46590 CALHOUN ST CUSTOMER FINANCIAL SERVICES 38729845 71277470 70018 R55U03B501_PXPKG ]]>

</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

[ppr (Peter Preuss)]

Please confirm that the shared XML is of this format:

escaped XML as values. If so, then we would first decode the value, parsing and Xml processing it.

[Ying_Zhu]

Yeah the request is html encoded, but the result format within SoapUI looks fine, not sure why in UiPath the format changed.

[ppr (Peter Preuss)]

Going ahead:

Name/ Namespace Check

So we can do a Quick Access:

Crosscheck returned Value

So when again Parsing the XML we can access:

[ppr (Peter Preuss)]

@Ying_Zhu

but the result format within SoapUI looks fine, not sure why in UiPath the format changed.

It is about the handling the CDATA Part

But with a second Deserialize XML it can be handled as show cased above

[Ying_Zhu]

hi thanks, but i’m not sure i fully understand, how do we do the second deserial xml here? sorry i’m pretty new to this

[ppr (Peter Preuss)]

as shown we can do it on codel

Assign Activity:
xDoc2 | DataType: XDocument = xDocument.Parse(xDoc.Descendants("DataFromTFS").First().Value)

Or you are using a second Deserialize XML Activity

xDoc is the outcome from the first Deserialize XML

[Ying_Zhu]

got it, thank you so much