XML Value Selector

Defines a return value to be captured from each XML node matched by the Record Selector.

Remarks

XML Value Selectors define which values to extract from each XML node (record) matched by the Record Selector in an XML Lookup.

How to Configure

• Path:
  Enter an XPath expression (relative to the record node) to select the value you want to extract.

  • You can select an attribute (e.g. @transaction_id) or a child element (e.g. Customer/Name).
  • If you select an attribute, its value will be returned. If you select an element, the inner text of that element will be returned.

• Target Field:
  Choose the Grooper field where the extracted value should be stored.

  • If you set a Target Field, the value will be mapped directly to that field.

• Alias Name:
  Optionally, provide an alias to use as the column name in the results.

  • If no Target Field is set, the Alias Name (or Path) will be used as the column name.

Tips

• Use the Path editor for syntax highlighting and code completion when entering XPath expressions.
• You can add multiple value selectors to extract several values from each record node.
• If both Target Field and Alias Name are blank, the Path will be used as the column name.

Example

Suppose your XML record looks like this:

You could configure value selectors as follows:

• Path: @transaction_id, Target Field: InvoiceNumber
• Path: Customer/Name, Target Field: CustomerName
• Path: Total, Target Field: InvoiceTotal

This will extract the invoice number, customer name, and total for each matched invoice node.

Properties

Name	Type		Description
Path	String	►	The XPath expression (relative to the record node) used to select the value to extract from each XML record. EditorPath Editor Enter an XPath expression to select either an attribute (e.g. @transaction_id) or a child element (e.g. Customer/Name). If you select an attribute, its value will be returned. If you select an element, the inner text of that element will be returned. The Path is evaluated for each record node matched by the Record Selector in the parent XML Lookup. Examples: @transaction_id (selects the value of the transaction_id attribute) Customer/Name (selects the inner text of the <Name> element inside <Customer>)
Target Field	Data Field	►	The Grooper field where the extracted value will be stored. ConverterTarget Field Converter Select a target field to map the extracted value directly to a Grooper field. If set, the value will be assigned to this field for each record. If left blank, you can use the Alias Name property to specify a column name for the extracted value. Tip: Only single-instance fields available in the current data context will be listed.
Alias Name	String	►	An optional alias to use as the column name for the extracted value in the results. If no Target Field is set, the Alias Name (or Path, if Alias Name is blank) will be used as the column name in the results table. Use this to provide a user-friendly or descriptive name for the extracted value. Example: If Path is Customer/Name and Alias Name is CustomerName, the results table will use CustomerName as the column header.

See Also

Data Field

Used By

XML Lookup