In order to fetch XML node value in UiPath I followed below steps. I read the XML file using Read file utility . Deserialized the XML using Deserialize XML activity. in Execute Xpath activity I used the output variable of Deserialize XML as input and below given Xpath. “Records-Set/record[A = …

Slightly old thread, but thought I would just put some details in here to help those searching. using below statement in Execute xpath utility helped me at last :slight_smile: “string(/Records-Set/record[A = '”+var1.ToString+“’][B=’”+var2.ToString+“’]/Leadtime)” If the XML looks the same <Reco…

hi @KT1993 Check the below posts Activities - Deserialize XML The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, …

Thanks Ashwin but I already went through all these posts but they could not help me out :frowning:

hi @KT1993 cHECK THIS POST THIS SURELY WILL HELP YOU [image] Get certain attributes value from XML file Help Hi, Im not too familiar with XML. Here’s the part of the XML-document: [Sieppaa] I would like to get the value of the ‘native’ attribute in the ‘callid’ -elem…

[XML] [XMLUI] [output] if I use below stateement in Assign activity I can fetch the value of all the attributes under element records as shown in the msgbox screenshot above but instead I just need the value of Leadtime and with a condition where A=“abc” Copper_DecisionTable_XML.Root.Element(“recor…

hi @KT1993 use this xpath in execute xpath //record[@A][@B][@leadtime] or use individually //record[@A] Thanks Ashwin S

Thanks Ashwin :slightly_smiling_face: using below statement in Execute Xpath utility is working fine for me. “string(/Records-Set/record[A = ‘abc’][B=‘123’]/Leadtime)” though I have a new challange now , to make this Xpath dynamic . can anyone help me with the syantx for dynamic Xpath… I used t…

hi @KT1993 try to use * instead of var1 and var2 Thanks Ashwin S

@AshwinS2 var1 and Var2 are the name of the variables which will be used to pass the values into statement at runtime. how can repalcing them with * would work ?

using below statement in Execute xpath utility helped me at last :slight_smile: “string(/Records-Set/record[A = '”+var1.ToString+“’][B=’”+var2.ToString+“’]/Leadtime)”

Hi , Please find below tutorials, [UiPath Tutorials For Beginners - XML Parsing] [Uipath Tutorials For Beginners XML Validations part-2] Thanks, Karthik.

Fetch XML node value (with condition on other node values) using Execute Xpath utility in UIPath

Help

AshwinS2 (Ashwin S) April 24, 2018, 1:40pm 2

hi @KT1993

Check the below posts

Thanks
Ashwin S

Topic		Replies	Views
Need help in XML parsing Off-Topic Discussions	2	1539	January 18, 2019
Get a specific node/content from XML Studio activities , question , xml	5	4550	July 12, 2022
Get certain attributes value from XML file Help	11	12881	March 15, 2019
XPATH return result - Object Help	9	8658	January 18, 2018
Setting Xml Node Value using UiPath Studio	3	1526	February 25, 2020

Fetch XML node value (with condition on other node values) using Execute Xpath utility in UIPath

Related topics