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, [image] but when i try to move on to the data, i keep receiving error like ‘Assign: Object r…

Going ahead: Name/ Namespace Check [grafik] So we can do a Quick Access: [grafik] Crosscheck returned Value [grafik] So when again Parsing the XML we can access: [grafik]

Hi @Ying_Zhu Check out this blog [image] How To Extract The Data From A XML file - In UiPath - ExcelCult Some business processes may consume the XML as an input/output to exchange data to/from a web server. When receiving data from a web server, the data is always a string. Let’s explo…

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

Hi @Ying_Zhu Have you checked this ? [image] Reading XML files - Deserialize XML activity Activities Find following starter help: [grafik] typeArguments of the different fore each are set to XElement: item = xDoc.Root.Descendants("node") item.Attribute("id").Value it…

From your input [image] 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…

[image] 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/envelo…

Please confirm that the shared XML is of this format: [grafik] escaped XML as values. If so, then we would first decode the value, parsing and Xml processing it.

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

[image] 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 [grafik] But with a second Deserialize XML it can be handled as show cased above

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

as shown we can do it on codel Assign Activity: xDoc2 | DataType: XDocument = xDocument.Parse(xDoc.Descendants("DataFromTFS").First().Value) [grafik] Or you are using a second Deserialize XML Activity [grafik] xDoc is the outcome from the first Deserialize XML

Extract Data From Deserialized XML file

Help Studio

Sudharsan_Ka (Sudharsan Ka) October 11, 2023, 3:08pm 4

Hi @Ying_Zhu

Have you checked this ?

Regards
Sudharsan

Topic		Replies	Views
Get the specific Data from XML file Studio studio , question , workflow_diff	9	3623	March 31, 2022
Deserialize XML from SOAP output Help studio , xml , soap_request , studiox_training	40	5407	January 15, 2020
Extract Element Values from SOAP XML (VB.Net / C#) Studio uiautomation , xml	28	4394	September 20, 2021
Deserialize XML from SOAP Activities activities , web , question	4	1562	November 9, 2022
Deserialize XML Help studio	12	21174	June 15, 2018

Extract Data From Deserialized XML file

Related topics