Get the specific Data from XML file

[Suvera_Software]

Hai i want extract specific Data from XML file, I am new to XML automation please help me out to solve this. If possible plase share ur uipath xaml file.it would be helpful for me
i share my .xml file here ,i want to extract “ES-Bristol-Myers Squibb Company-BMS-2017-001223” this text from the above xml file.

Thank u

[ridvanucok]

Hi @Suvera_Software ,
You have not attached the sample xml file to the topic. You can use the Deserialize XML activity to extract data from XML.

Deserialize XML

[Gokul001 (Gokul Balaji)]

Hi @Suvera_Software

Have a look on the thread

How To Extract The Data From A XML file – In UiPath

Regards
Gokul

[Suvera_Software]

ICHICSR-EVHUMAN_10007014175XML.xml (63.7 KB)

[Suvera_Software]

Here the xml file looks some how different from normal xml file, thats why i facing difficulty to extract that particular data.

[ppr (Peter Preuss)]

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

find starter help here:
ppr_XMLBox_Suvera_Software_V2.xaml (7.5 KB)

[ushu (Usha kiranmai)]

Please go through below post

Extract Data from XML

Dear Experts, We have some barriers in extracting data from XML, Our sequence contains HTTP request, deserialize XML and its result. But we only need to extract every “ObjectID” and “ProjectID” containing in that XML. Let me know how can I extract all the contain data field from XML. Thanks for your help. PJC.txt (1.7 MB)

[Suvera_Software]

Thank you for ur help @ppr

[Suvera_Software]

Thank You for ur response,it was more helpful for me @ushu

[Suvera_Software]

Thank u guys @ridvanucok @Gokul001