XML Extract Data

[ppr (Peter Preuss)]

@Beatriz_Eugenia_Duqu

lets introduce an approach which is using datatables for configuring the extraction with the help of XPath:

Readin XML, parse to XObject (Ensure via dependency manager UiPath.WebApi.Acitivities is referenced):

Build the Extraction Config for the static part and the dynamic (lines) part:

add dynamicly the different columns to the extrac Datatable for later holding the extracted values:

Iterate of the extract config for the statics , extract the value and store it to a datarow (created with dtExtract.NewRow).

Retrieve all line elements:

• iterate now over all line elements
• create a DataRow (drExtractRow) for holding the extraction result
• transfer with one go the extraction result of the statics to the drExtractRows
  drExtractRow.ItemArray = drStaticPart.ItemArray (So we can reuse the static part again without multiple redundant extractions)
• iterate over the extraction config for the dynamics and extract the values
• finally add drExtractRows to the Datatable dtExtract

as it was an adoption from here:

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …

with the help of webtools (F12) in Browser the remaining XPath statements can be grabbed:

@ppr

So this result can be used and preprocess (e.g. removing path column, dynamic reating another structure…)

I did it as a quick prototype for you and you can finalize.

Open the XML in Chrome or Firefox and activate the Webtools (F12)
with following you can easy get the Xpath: Kopieren means Copy:

ensure also following:

Find starter help here:
StaticDynamicRetrieval_ByXpathConfig.xaml (17.9 KB)