Help to read XML invoices

Help Studio
, ,
1

hi people, I need to read XML files (Invoices ) from a folder and then transform to a excel format - 1 line for each invoice item

I review some videos and solutions for XML data extraction but those XML has particular structure as you see in the picture.

The image shows an XML structure of an invoice line with detailed elements such as invoiced quantity, line extension amount, pricing references, tax totals, item identification, and descriptions. (Captioned by AI)
The image shows an XML structure of an invoice line with detailed elements such as invoiced quantity, line extension amount, pricing references, tax totals, item identification, and descriptions. (Captioned by AI)981Ă—870 23.8 KB

the structure has a namespace, so this is necesary to deserialice the XML - Done

My problem is that I can not get the information from the elements
I review diferent modes, but can not get the data.
1.- Descendants

image
image858Ă—573 24 KB

2.- Finding the tag element

image
image874Ă—513 22.9 KB

both sentence retrieve 0 items

archivoXML.Descendants(xmlNS + “InvoiceLine”)
archivoXML.Root.Elements(xmlNS + “InvoiceLine”)

please any recomendation/suggestion/help?

2

Have a look here:

it will also help with the analysis of which namespace is to use. Keep in mind that multiple namespaces are defined within the XML and may be to handle for the extractions

1 Like
3

excelent, I understood and solved the issue,
thanks guy

4

Perfect, so the topic can bei closed