How to extract multiples records in same XML file (with namespaces)?

[Jean_Piere_Ochoa]

Hi everybody,

I have a xml file, on this file i need to get multiples Description values. My problem is that tag is the same for the all values so when i invoke the method always get the first value. Example, Take a look at picture for more details.

Could you help me please.

Thanks in advance.

[Yoichi]

Hi,

The following steps might help you.

1. Get all cac: InvoiceLine Elements as IEnumerable using Descendants method.

2. Iterate above collection and get cbcID Element and cbc:Description in each cac:InvoiceLine Element (using Descendants method etc).

3. If nescessary, it might be good idea to use Dictionary to link ID and Description

If you can share your whole xml file,I might be able to comment more details.

Regards,

[ppr (Peter Preuss)]

@Jean_Piere_Ochoa
For working with XML having namespaces have a Look Here

XML Parse

Hi @mikamol Find the attached sample Main.xaml (8.1 KB) that is showcasing following: Retrieving all Field elements Retrieving all Id elements (Parent is Field) Retrieving the particular Answer Value for a particular Id As this XML is defining the namespace:` xmlns="urn:abou:documents:ka:Case The Root element Name is not Case it is: e.g. urn:abou:documents:ka:Case:Case So the namespace part is to take into account Solved with using namespace manager Kindly note the order from a XML Docu…

The steps given from @Yoichi are covering the Main actions for your scenario

ADDED: Link to some analysis techniques for XML Namespaces:

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</…

[Jean_Piere_Ochoa]

Hi @Yoichi Thanks for answer me,

My .xml file attach here.

Data.xml (803 Bytes)

i already get the first ID value (i attach my project here)

Main.xaml (14.0 KB)

but i need to get all descriptions like the previous imagen though a loop (for each activity, for example) and for that, my condition or key is “cbc: ID”. For example, if exist three ID values (ID: 1, ID: 2 and ID: 3) i need to get the three description values from “cbc: Description”.

Thanks for advance.

[Jean_Piere_Ochoa]

Hi @ppr
Your response was very useful, it works!
Cheers.

Thanks so much.

[Jean_Piere_Ochoa]

@ppr
The “Function (e)” is new for me. When can i use that? how it works? Do you have a link about that?

Thanks!

[ppr (Peter Preuss)]

@Jean_Piere_Ochoa
Its about LINQ
Where Method got a defined Function/Lambda that is defining what to do. The Syntax Function (e) is defining this and e is a variable name for this defined function representing the item that is processed in the function.
To get more information about this topic have a look here: LINQ Method Syntax

ADDED: Link to LINQ Learning catologue

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[Jean_Piere_Ochoa]

Thanks @ppr.

We keep us in touch