How to read Xml Data File in Ui Path

Help
, ,
1

How to read Xml Data File in Ui Path and How to search particular Elements are values there are not in xml file if it is not thers some values writing in xml file .

If it is Possible
Let me Know.

2

@Logesh_Kumar,

Welcome to our Community!.

Check this custom activity, implementation guidelines will be there in the portal.
https://go.uipath.com/component/xml-conversion-activities

3

Hi sarathi125 sir,
I am not converting Xml to datatable or csv I want Read That Xml File and find the Elements values in xml

4

Hi @Logesh_Kumar

Welcome to our community!

Go through this it might be helpful

5

Hi prakaz25 sir,

image

Next I need to search from Xml so what to do

6

go through this thread Read XML files and get data - Namespaces

7

You can access value from xml like
getxmloutput.element(“name”). tostring
If structure is nested then
Getxmloutput.element(“root”). element (“child”). element (“name”). tostring

8

Hi sandeep13 sir,

Getxmloutput.element(“component”). element (“header”). element (“publicationMeta”). element (“publisherInfo”).tostring
Message Box: Object reference not set to an instance of an object.

How can i solve this sir

9

could you share xml file or screenshot?

10

Hi sandeep13 sir,
Find Below Attachment

cft2cftm20140013.xml (84.2 KB)

11

try this

Getxmloutput.element(“component”). element (“header”). element (“publicationMeta”). element (“publisherInfo”).value

12

Hi sandeep13 sir,

image

Message Box: Object reference not set to an instance of an object.

13

@Logesh_Kumar

image
image774Ă—239 6.04 KB

its works but when i remove addtional value from xml file
like
image
image823Ă—202 6.75 KB

14

Hi sandeep13 sir,
Thank You sir,
But My Requirement

xmlns:wiley=“http://www.wiley.com/namespaces/wiley/wiley”
This Component tag have this to i search if this sentence hear no problem if not hear means i put that text i replace that text

If I check The Component tag have that text if not have i put that text
xmlns:wiley=“http://www.wiley.com/namespaces/wiley/wiley”

15

Hi sandeep13 sir,

image
image977Ă—66 4.07 KB

How to find the type value and sort values in title element

16

@Logesh_Kumar
using Attribute method
XMLDoc.Element(“component”).Attribute(“Title”).ToString

17

Hi sandeep13 sir,

I try many, but coming Errors,

getXmloutputTxt.Element(“titleGroup”).Element(“title”).Attribute(“sort”).ToString
getXmloutputTxt.Element(“titleGroup”).Attribute(“title”).ToString
getXmloutputTxt.Element(“component”).Attribute(“Title”).ToString

18

@Logesh_Kumar

i print level attribute of publicationMeta element
XMLDoc.Element(“component”).Element(“header”).Element(“publicationMeta”).Attribute(“level”).Value

19

@Logesh_Kumar

it’s working but as i said i remove additional value

XMLDoc.Element(“component”).Element(“header”).Element(“publicationMeta”).Element(“titleGroup”).Element(“title”).Attribute(“type”).Value

20

Hi sandeep13 sir,
Now it’s working Fine
That Attribute Value I replace The Text How