Xml file reading and extracting some information from it

[ppr (Peter)]

reported file looks not as a full FilePath for a XML file

[Yoichi]

Hi,

@RAKESH_KUMAR_Tiwari

‘C:\Users\asus\OneDrive\Documents\UiPath\Mexico_XML_Extraction

Is the above Folder? if so, the first assign will be as the following.

FilePath = System.IO.Directory.GetFiles("‘C:\Users\asus\OneDrive\Documents\UiPath\Mexico_XML_Extraction","*.xml")

Note: FilePath is String array type.

Regards,

[RAKESH_KUMAR_Tiwari]

i have not saved the file to that full file path intead i have saved in desktop.

and when i go to desktop and click on shift right click copy as path it gives me below path

“C:\Users\asus\OneDrive\Desktop\xml files”

[ppr (Peter)]

you need to provide the full filepath Folderpath/filename + filetype extension

so also as mentioned by Yoichi when looping over the files contained in a directory, then use File / Directory related statements for getting the single file paths

[CheatSheet] - Filesystem APIs - News / Tutorials - UiPath Community Forum

[RAKESH_KUMAR_Tiwari]

ok, now it is reading all the files.

now i want to extract around 10 - 15 values from it.

when i open xml files using edge, it open like below.

how to traverse the elements and find suppose first value (fecha) i.e Date, and also position of each elements might change in each file of xml, i.e if fecha is in third line then it might be available on 4 or fifth line.

how to achieve it

[ppr (Peter)]

you need to handle the 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] Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</productVersion>] } xDoc.Descendants(xnsDefault + "productVersion").First().Value "123" xDoc.D…

we don’t see all details, but it could the case, that fecha is an attribute of the root element

give a try at: YourDeserializeXMLOutputVar.Attribute(“Fecha”).Value

[RAKESH_KUMAR_Tiwari]

Attribute function is not available

[ppr (Peter)]

@ppr

YourDeserializeXMLOutputVar.Attribute

it looks like you a trying to do it with the text but not with returned output of DataType XDocument.

Feel free to share with us the XML file as text file

[RAKESH_KUMAR_Tiwari]

61C611AD-6505-4653-8493-590E59E39151@1000000000XX0.xml (5.0 KB)

pls extract below values

Buyer/ Entity - In Receptor: Nombre – find out - Nombre=“FRONTIER CAR GROUP MEXICO SA DE CV”
Invoice address Domicilio / expedido en:[Spanish] – not found
Vendor Name - In Emisor: Nombre - Nombre=“ANA KAREN HERNANDEZ PEREZ”
Supplier TAX ID (vendor vat) - In Emisor : Rfc - HEPA9012159B8
Invoice Number - Serie + Folio? -=“2369” Serie=“AK”
Invoice date - Fecha comprobante Fecha - 2022-06-17T14:57:40
PO number - Su pedido - n2022-06-17T14:57:40 not found
Invoice total - Total – Total=”1173.92”

[RAKESH_KUMAR_Tiwari]

i tried to find out the first value

xmlstring.Descendants(xDefaultValues + “Emisor Nombre”)
GetDescendants { [<cfdi:Emisor Nombre=“CFE SUMINISTRADOR DE SERVICIOS BASICOS” RegimenFiscal=“601” Rfc=“CSS160330CP7”/>] }
xmlstring.Descendants(xDefaultValues + “Emisor Nombre”).First().Value

but this gives me error

[RAKESH_KUMAR_Tiwari]

Hi All,

below error

for this code

trying to find below

<cfdi:Emisor Nombre=“CFE SUMINISTRADOR DE SERVICIOS BASICOS”

kindly help

[ppr (Peter)]

handle the namespace as described above in the link. do not use the prefix from the namespace within the name as the : is causing the issue

YourXNameSpaceVar + “YourXMLElementLocalName” is to use

[RAKESH_KUMAR_Tiwari]

error - Assign: The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name.

[ppr (Peter)]

@ppr

YourXNameSpaceVar + “YourXMLElementLocalName” is to use

as mentioned

do not use :

[RAKESH_KUMAR_Tiwari]

as told removed “:”

still

[ppr (Peter)]

• Just reread the attached links
• do not mix up Elements and Attribute

You can do the explorations by using the immediate panel (as shown in the screenshots) more quick

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[ppr (Peter)]

Is it done? Can the topic be closed?
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

[RAKESH_KUMAR_Tiwari]

Hi,

need to find these two values together, how to achieve it

[ppr (Peter)]

similar to:

@ppr

give a try at: YourDeserializeXMLOutputVar.Attribute(“Fecha”).Value

xDoc - the output of a deserialize XML Activity

[RAKESH_KUMAR_Tiwari]

is my expression is right to get both values together?