XML Node to Dataset Action

Declaration

<AMXMLNODEITERATOR XPATH="text" RESULTDATASET="theDataset" />

See Also

Create XML Node Action, Delete XML Node Action

Description

Creates a dataset of node values, node attribute values or unique XPaths from the selected node. The dataset's Value property contains the selected values.

Practical Usage

See Description.

Parameters

General Tab

XPath Expression

Text, Required
MARKUP: XPATH="sum(//price/text())"

Specifies the Xpath Expression from the current XML document to use to evaluate a value.

Create the dataset of node values

Text, Required
MARKUP: RESULTDATASET="theDataset"

Specifies the name of the dataset to in which to populate with the node values.

Session Name

Text, Optional - Default "XMLSession1"
MARKUP: SESSIONNAME="FirstXMLSession"

Specifies the session name to identify the in-memory XML document to use in subsequent XML steps. This allows several in-memory XML documents to be active simultaneously.

Populate dataset with

Text, Required - Default - Text value of each node
MARKUP: VARVALUETYPE="XpathValue"

Specifies the type of information to populate the dataset with.

The available options are:

Notes

Custom Description

This action includes the Description tab for entering a custom step description.

More on setting custom step description

Standard Error Handling Options

This action also includes the standard Error Causes and On Error failure handling options/tabs.

More on Error Handling Options

Variables and Expressions

All text fields allow the use of expressions, which can be entered by surrounding the expression in percentage signs (example: %MYVARIABLE%, %Left('Text',2)%). To help construct these expressions, you can open Expression Builder from these fields by pressing F2.

More on variables
More on expressions

More on the expression builder

Example

NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.

<AMXMLNODEITERATOR XPATH="sum(//price/text())" RESULTDATASET="theDataset" VARVALUETYPE="XpathValue" />