Extract Collective Data from XML

[soorya_prasad]

Hi,

I need to extract some data from the XML string.
Below is the xml output. From this I need to fetch the LineNumber, StockCode for all the responses. We have Row xmlns=“namepsaceURL”. So I could not extract the required. Please help me with some solution team.

Thanks,
Soorya

[ppr (Peter Preuss)]

@soorya_prasad
Have a look here on how to handle namespaces for extraction

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)