Xml file with xmlns value

[dla (David Laosa)]

Hi, I’m working with an xml file showed in the image above:

As you can see, the Element (second line) has an xmlns value.

I’m trying to obtain the value of the Element . These are the steps of my develope:

1. Assign to a variable called xDoc (XDocument Type) the value XDocument.Load(“My xml file”)

2. Assign to a variable called ElementCollection (system.collection.generic IEnumerable of XElement) the value xDoc.Descendants("Jv-Ins-Reinsurance ")

3. For each elem in ElementCollection, Write Line elem.value

The problem is that I’m not obtaining any value in ElementCollection and, If I delete the attributes of Jv-Ins-Reinsurance, it works perfectly. But I need to mantain this attributes

Can you help me, please?

I,ve tried to upload the xml file but I couldn’t because I’m a new user.

Thank you all¡¡

[Yoichi]

Hi,

Can you try the following steps.

First, define System.XML.Linq.XNamespace type variable (Let’s say xns) and set namespace which is defined the element in xmlns attribute to it.

xns = "http://xxxxxxxxxx"

Then the following will work.

xDoc.Descendants(xns+"Jv-Ins-Reinsurance ")

Regards,

[ppr (Peter Preuss)]

Some illustrations to @Yoichi mention

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…

[dla (David Laosa)]

Hi,

First of all, thank you very much for your answer.

I’m getting crazy… so I need help from people like you…

I’ve attached a .rar file with the .xml file and the .xaml process I’m traying to do.

I need to get the value of the Element “Cedent Reference” marked in yellow in the image above

With this value, I’ll get another value from a Data Table and I had to replace the text “Please advise” (rounded in red in the image) with the value obtained in Data Table

But I’m not being able to get the first value and I think the problem is the namespaces in the root line.

As you can see in the xaml, I’m getting one only element and I don’t know if I’m doing something wrong.

Please, can you give me some help?

Thank you in advance!!

David (a novice RPA Developer)

(Attachment PRUEBA XML.rar is missing)

[dla (David Laosa)]

Sorry, I attached a .rar file and it`s not allowed.

I`m attaching now a .7z file

Thanks!

PRUEBA XML.7z (47.1 KB)

[Yoichi]

Hi,

One of the roughest ways is to use “ReinsurerReference” directly, as the following.

If there is possibility there are multiple ReinsurerReference element (including parent element), need to get TechAccount elements first, then Contract elements, finally ReinsurerReference element.

Regards,

[dla (David Laosa)]

Thank you again Yoishi,

But I’m afraid that it doesn’t work.

As you can see above, no results obtained in my output panel

[Yoichi]

Hi,

In my environment it works well. Can you check the xml is same as the attached one?

And, for now, can you try the following sample as it is?

PruebaXML2.zip (4.0 KB)

Regards,

[dla (David Laosa)]

Yes, it works!!!

The problem was in the .xml file as you told me.

Thanks a lot!!

David