Data Extraction from SOAP envelop Environment xml file

Help Activities
, , , , ,
1

Hi could anyone help me out in Extraction data from xml file

Sample file: chauffeurAek040812NOV214810Nov21025746.XML (6.2 KB)
500](upload://tKc9BHDpQQ1hPHb92CugxgE8ytV.png)

Need extract certain fields represented with numbers which is shown below image

image
image731×886 43.5 KB

2

@Soundarya_Guduri
The XML is defining namespaces which needs to get handled as described here:
XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

grafik

Just a few retrieval samples:
grafik

Looping over all PNR elements

grafik
grafik558×663 38.5 KB

Retrievals from a PNR within a loop

grafik
grafik748×601 87.3 KB

grafik

And some text parsing we can do with Regex for example:

grafik
grafik847×254 10.1 KB

or String Methods:
grafik

3

thank you for your response
Let me workout it and i ll know you the status

4

could you please provide the xaml

5

find starter help here:
ppr_SOAPXMLBox_SoundaryaGuduri.xaml (7.8 KB)

Working with the immediate panel:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

6

Thanks a lot @ppr it is very helpful to my project … :slightly_smiling_face:

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.