Value Selector

Specifies how to extract a value from each record identified by the record selector in a Web Service Lookup.

• For JSON records, enter a JSONPath expression.
• For XML records, enter an XPath expression.
• If left blank, the entire record is used as the value (i.e., the record is a scalar value).
• Multiple paths can be specified, separated by commas, to extract and combine several values from each record.

The path(s) are evaluated for each record returned by the record selector. If multiple paths are provided, the extracted values are joined using the 'Delimiter' property.

Examples:

• JSONPath: $.name extracts the name property from each record.
• XPath: ./ID extracts the <ID> element from each record.
• Multiple paths: $.firstName, $.lastName extracts and combines both names.

> Tip: Use the diagnostic output to verify that your path expressions are extracting the intended values.

When multiple paths are specified in the 'Path' property, the extracted values are joined together using this delimiter.

• The default delimiter is a comma (,).
• Enter any string to use as a separator (e.g., ;, |, or a space).
• This property is only visible when two or more paths are specified.

Example:

• If 'Path' is $.firstName, $.lastName and 'Delimiter' is (space), the result will be John Smith.

> Note: If only one path is specified, the delimiter is ignored.

Maps the extracted value directly to a Data Field in your data model.

• Select a field to automatically store the extracted value in your data model.
• If left blank, the value will appear as a column in the lookup results but will not be stored in any field.
• Use this property to automate data population and enable validation or downstream processing.

When a target field is specified, the value selector will use the field's data type and formatting rules. If the 'Path' property is left blank, the entire record is used as the value for the field.

> Tip: Ensure the extracted value matches the expected data type of the target field for best results.

Specifies a custom name for the column in the lookup results table.

• Enter a name to display this value as a column in the results.
• If left blank, the column will use the field name (if mapped) or the path expression.
• Useful for clarity when displaying results that are not mapped to a Data Field, or when you want to override the default column name.

Example:

• If extracting a value with path $.customerId but want the column to display as "Customer Number", set 'Alias Name' to Customer Number.

> Tip: Use alias names to make results tables more readable, especially when extracting values not mapped to fields.