Extracting XML Data from a Website

Help Studio
, ,
8

@Sisay_Dinku
The XML is defining namespaces. You can handle it as described here:

A general flow could look like this

  • Deserialze XML - out: xDoc

  • Assign Activity: xnsWD | DataType: XNamespace = the XML Namespace for the WD prefix

  • Build Datatable - dtResult, Configure the columns as it is within the XML

  • For each Actvitiy | item in xDoc.Descendants(xnsWD + “Report_Entry”) | TypeArgument: XElement

    • Add Data Row Activity:
      ArrayRow = item.Elements().Select(Function (x) x.Value).Cast(of Object).toArray
      DataTable: dtResult