XML Extract Data

[Beatriz_Eugenia_Duqu (Beatriz)]

Hello!
I have an XML in which I have to extract several tags

I need to filter this information in order to be able to assemble it in SQL.
I hope you can help me
This is my XML

Thanks.

[ppr (Peter Preuss)]

@Beatriz_Eugenia_Duqu

lets assume the specific XML Values will be extracted and stored within an intermediate format (e.g. DataTable) for a later processing.

The Element “line” is a repeating element and occurrs in the sample 2 times (Quantitiy is to grab from this)

So we would assume that the XML extraction will produce 2 record sets.

Is this understanding matching your requirements? If not please elaborate on the exact output of this sample example.

Thanks

[Beatriz_Eugenia_Duqu (Beatriz)]

@ppr

lets assume the specific XML Values will be extracted and stored within an intermediate format (e.g. DataTable) for a later processing.

The Element “line” is a repeating element and occurrs in the sample 2 times (Quantitiy is to grab from this)

So we would assume that the XML extraction will produce 2 record sets.

Is this understanding matching your requirements? If not please elaborate on the exact output of this sample example.

Thanks

If it is totally as you describe it

Thanks

[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)