How to read Xml Data File in Ui Path

Help
, ,
21

i didn’t get you
you want replace the string??
using replace method of String
value.replace(oldvalue,new value)

1 Like
22

Hi sandeep13 sir,

I want replace the string

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

This query getting one value That value i replace to some text

1 Like
23

XMLDoc.Element(“component”).Element(“header”).Element(“publicationMeta”).Element(“titleGroup”).Element(“title”).Attribute(“type”).Value.ToString.Replace(“oldtext”,“newtext”)

1 Like
24

Hi sandeep13 sir,

If I check Particular Element inside particular attributes If it is There means Exit and not There is Insert that values in That Xml file

If It is Possible sir ?

25

@Logesh_Kumar
yes you can, you need to explore Add, AddAnnotation method.

26

Hi sandeep13 sir,

How To add in Particular Element in Add some text I am trying But Not Getting sir

image
image501×537 12.2 KB

27

Hi,

I want to check whether a XML tag/element is present in the XML file or not.
How can i achieve this.

I have read the XML file in to string using Deserilization operation and looped the to get all the similar kind of tags.

item.Element(“reporttype”)

I want to check whether this tag is present in the XML file or not.

Kindly help me.

28

item.Element(“reporttype”).value

when i use this its showing object reference is not set to an instance of an object.

So i want to check whether this tag is present in the XML or nor before doing further operation.

29

@chandan.pandurangaiah
give a try on check it with the element count like yourXdocVar.Root.Descendants(“reporttype”).toList.Count

If it is not working as expected, so just create a new topic for your case and share some sample xml data with us. We will support you

1 Like
30

Hello, I ask you, how can I read this xml if the header has an attribute

image
image841×138 8.24 KB

I have installed only with Electronic Invoice, placing all the text of the label, but it does not work.
What I can do?
I need to extract the name of the issuer

31

Hi @sandeep13,

I have tried using your methods, that you have mentioned. But the same thing is working when there is no “:” present in xml node.

I have a xml, which is having “:” in the node name. While using this error coming as,

“The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name.”

How to fix this?

For your reference - I have added two Ui Path for your reference.

  • File 01 - Working As there is no “:” in the node name : TestXML_01.zip (14.5 KB)
  • File 02 - Not Working as there is “:” in the node name : TestXML_02.zip (5.1 KB)
1 Like
32

Hello Ashish,
In this video, extract data from XML with a node that contains “:”

23:50 Deserialize XML
25:15 How to extract Data from XML Nodes
27:40 How to extract Data from XML Attributes
Thanks,
Cristian Negulescu

33

Sure @Cristian_Negulescu … Let me get through it and will update if I need any help on this.

1 Like
34

Hi sandeep

I am using the expression but it says Object reference not set to an instance of an object. Could you please help me on this