Reading UBL cac, cbc namespaces

[Basak_Demirel_Kacmaz (Başak Demirel Kaçmaz)]

Hello guys,
I am trying to reading xml folder and taking the tax amount and transfering to excel.

Any help will be appreciated

[ppr (Peter Preuss)]

Have a look here, on how to handle namespaces

Read from xml file

@Zlotzky Setting up the quick prototype: Variables: Handling Namespace: [grafik] ElementNames to Extract - Prototype reduced set: [grafik] Read In XML [grafik] Ensure: [grafik] Retrieval of private contact element (mandatory use of the Namespace within the name) [grafik] iterating over the list of elmentnames (ExtractNames) and reading element value: [grafik] Logs: [grafik] Find starter help here: Zlotzky.xaml (6.3 KB)

[Basak_Demirel_Kacmaz (Başak Demirel Kaçmaz)]

Thanks for help, trying immediately.

[ppr (Peter Preuss)]

Other examples as well:

Parse a SOAP XML

@benjamin.9052 find attached Demo Game XAML: SOAP_SearchByIDType.xaml (6.3 KB) working with corrected / adopted XML: test.xml (862 Bytes) Implementing following: retrieving all IDTypes Showing a input dialog and let user select the IDType to search for seraching the corresponding ID Message Box with the retrieved ID Value

De-serializing XML (Soap response)

@Pradeep.Robot Following up the communications from messages find some further starter help: XML Namespaces can confuse sometimes. But with following it can be overcome and analysed. After deserializing into an XDoc following statement can be used for exploration in the watch Box / Immediate Box while debbuging: [grafik] playing with the index the element of interest can be checked if its dealing with any Namespace or not with the LINQ XML methods we can use the Descendants(“SubCollection”)…

and more are additional available

[Basak_Demirel_Kacmaz (Başak Demirel Kaçmaz)]

Thank you for your help.
I need specific item like “cbc:InvoicedQuantity”
How can I achieve?

[ppr (Peter Preuss)]

the provided resource would clear it.

• defines namespace variables
• implement the extraction

Otherwise share your XML with us, in case of further help is needed

[ppr (Peter Preuss)]

A rough Quick implementation:

 xDoc.Root.Descendants(xnsCAC + "InvoiceLine").First().Element(xnsCBC + "InvoicedQuantity").Value
 "4.00000"
 xDoc.Root.Descendants(xnsCAC + "InvoiceLine")(1).Element(xnsCBC + "InvoicedQuantity").Value
 "13.00000"
 xDoc.Root.Descendants(xnsCAC + "InvoiceLine").Count
 2

However go through the provided resources and you will get implemented your case with this help very quickly

[Basak_Demirel_Kacmaz (Başak Demirel Kaçmaz)]

thanks for help