I’m spending hours on how to get “CurrentBalance” data from SSvcFinancialInfoZoneDetails in below script: <?xml version="1.0" ?> <soapenv:Envelope xmlns:soapenv=“ http://schemas.xmlsoap.org/soap/envelope/ ”> <soapenv:Body > [image] i have added XNameSpace and can get all details from…

xDoc.Descendants(NS2+“SSvcFinancialInfoZoneDetails”).First().Attribute(“CurrentBalance”).Value (NS2 = “ http://splwg.com/SSvcFinancialInfoZone.xsd ” ) as xNameSpace Result: “Current Balance $-17.76” Thank you so much

Hi @kasmosh To extract data from an XML file in UiPath, you can use one of the following approaches: Use the Read Text File activity to read the XML file as a text file, and then use a String manipulation activity to parse the data. Use the XML activities to parse the data. To do this, you will n…

Hi @Kaviyarasu_N , Thanks but this script is SOAP api response not an regular xml. I can not use the same method

@kasmosh Please check this for detailed explanation on how to extract xml data [image] XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) Community Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to han…

Hi @kasmosh The output is which format? if its in string means you can extract the data with regex function if not try to convert into string and above method. If not works please share output results with datatype Regards, Kaviyarasu N

Problem getting values xml soap (Details)

Help Studio

Anil_G (Anil Gorthi) January 3, 2023, 7:32am 4

@kasmosh

Please check this for detailed explanation on how to extract xml data

Cheers

Topic		Replies	Views
How to extract value from XML Studio studio , question , activities_panel	4	2411	March 11, 2021
Extract Element Values from SOAP XML (VB.Net / C#) Studio uiautomation , xml	28	4422	September 20, 2021
How to extract XML data from response HTTP activity Activities uiautomation , question	3	3056	February 11, 2021
Get the specific Data from XML file Studio studio , question , workflow_diff	9	3665	March 31, 2022
How to get specific information from xml Robot xml-data-extraction	3	747	June 15, 2023

Problem getting values xml soap (Details)

Related topics