How to access XML element and get value?

[Prabin_Chand]

Hello everyone!
how can i get value from xml which has this format

<applications xmlns="http://st.sss.in/STAB">
<application>
<application_type>APTPISSA</application_type>
	<application_flow_id>1007</application_flow_id>
	<application_status>APST0006</application_status>
	<operator_id>PHR.P248</operator_id>
	<institution_id>1001</institution_id>
	<agent_id>70000011</agent_id>
	<customer_type>ENTTPERS</customer_type>
   <customer>
		<command></command>CMMDEXPR
		<customer_number>998563</customer_number>
		<contract>
			<command></command>CMMDEXPR
			<contract_number></contract_number>
			<card id="card_1">
				<command></command>CMMDEXRE
                <card_number>418240****4004</card_number>
			</card>
		</contract>
	</customer>
	</application>
	
<application>
<application_type>APTPISSA</application_type>
	<application_flow_id>1007</application_flow_id>
	<application_status>APST0006</application_status>
	<operator_id>PHR.P248</operator_id>
	<institution_id>1001</institution_id>
	<agent_id>70000011</agent_id>
	<customer_type>ENTTPERS</customer_type>
   <customer>
		<command></command>CMMDEXPR
		<customer_number>407766</customer_number>
		<contract>
			<command></command>CMMDEXPR
			<contract_number>100000081625</contract_number>
			<card id="card_1">
				<command></command>CMMDEXRE
                <card_number>41824066006003445</card_number>
			</card>
		</contract>
	</customer>
	</application>
	
<application>
<application_type>APTPISSA</application_type>
	<application_flow_id>1007</application_flow_id>
	<application_status>APST0006</application_status>
	<operator_id>PHR.P248</operator_id>
	<institution_id>1001</institution_id>
	<agent_id>70000011</agent_id>
	<customer_type>ENTTPERS</customer_type>
   <customer>
		<command></command>CMMDEXPR
		<customer_number>816941</customer_number>
		<contract>
			<command></command>CMMDEXPR
			<contract_number>100000132450</contract_number>
			<card id="card_1">
				<command></command>CMMDEXRE
                <card_number>41824066014435099</card_number>
			</card>
		</contract>
	</customer>
	</application>
	
<application>
</applications>

All i want is to grab “Customer number” & “Card Number” .

Thanks in advance.

[Sudharsan_Ka]

Hi @Prabin_Chand

Checkout this

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)

Regards
Sudharsan

[Sudharsan_Ka]

Extract the Data from XML File | XML Parsing | Uipath RPA

[Prabin_Chand]

My root element has attribute.
i am not able to do it as shown in video.

[Sudharsan_Ka]

Have you checked the thread above ? @Prabin_Chand

Also check this

How to parse specific XML data in UiPath - Full Tutorial

Regards
Sudharsan

[Prabin_Chand]

yes i did watched this video too

[ppr (Peter Preuss)]

You need to handle the XML Namespaces:
XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

[Prabin_Chand]

I saw your post. but it’s little confusing.
How can i do that in my scenario ?
i’am new to UiPath

[ppr (Peter Preuss)]

As described in the above link we check straightforward element name and possible xml namespace parts by:

so we do have and can creatre the document namespace by:

@Prabin_Chand

All i want is to grab “Customer number” & “Card Number” .

We assume that you want to retrieve all Customer numbers / Card numbers

So we do loop over all application elements and then retrieve the Customer/Card numbers

For a first start help have a look here:

Typeargument of the for each activity is set to XElement
Logs:

Statements:

xnsDefault = xDoc.root.name.Namespace
item in xDoc.Root.Descendants(xnsDefault + "application")
item.Descendants(xnsDefault + "customer_number").First().value
item.Descendants(xnsDefault + "card_number").First().value

[anon87560229]

Hi @Prabin_Chand

May this help you: How To Extract The Data From A XML file – In UiPath – ExcelCult

Regards
Mohini
Happy Automation…!!!