Setting an extraction path for XML data

You can set an extraction path for the data to be extracted from an XML string.

  1. Open the Event Action Extract XML Collection form.
    Note: This form cannot be opened directly. To open it, you must select an Extract XML Collection event action on the AES Event Actions form and then click Edit Parameters.
  2. Click XML Template and load an XML template.
  3. In the Tree View of the Event Action Extract XML Collection Set Path 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