Setting an Extraction Path for XML Data

To set an extraction path for the data to be extracted from an XML string:

  1. Open the Event Action Extract XML Collection form.
  2. Click either Path or Property Map.
  3. In the Tree View of the Event Action Set Extract XML Collection form, locate a real or example node under which the data resides (or will reside) for the rows to be extracted.
  4. Click to select the node.

    Do not select any value under the node.

    The equivalent XML Path Language (XPath) expression is displayed under Current Selected Path.

  5. If the data to be extracted is a single row comprised of values under this particular node in the XML, click Set Current Path as Extraction Path to Select Single Row.

    You could, for instance, extract data under the third of a repeating series of identically named nodes. The Current Selected Path is copied to the Extraction Path with a number in square brackets at the end. For example, to extract data under the third of a repeating series of nodes, the Extraction Path would end in [3].

  6. If the data to be extracted is a set of rows comprised of values under this particular node and all the identically named nodes adjacent to it (that is, in series under the same parent node in the XML), click Set Current Path as Extraction Path to Select Collection.

    The Current Selected Path is copied to the Extraction Path without square brackets at the end.

  7. Click OK.
Related topics