Value Selector

Defines a value to extract from each record in a web service response, and optionally map it to a Grooper field.

Remarks

A Value Selector specifies how to extract a single value from each record identified by the Record Selector in a web service lookup.

• Use the Path property to define how to locate the value within each record (using JSONPath or XPath).
• Use Target Field to map the extracted value directly to a Grooper field.
• Use Alias Name to customize the column name in the results table.

Multiple value selectors can be added to extract several values from each record. This enables you to build a complete mapping from the web service response to your data model.

Typical uses:

• Populate Grooper fields with data from a web service.
• Extract additional values for review or validation.

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

Properties

Name	Type		Description
Path	String	►	A JSONPath or XPath expression that selects a value from each record. For JSON records, enter a JSONPath expression. For XML records, enter an XPath expression. Leave this property blank if the entire record is the value you want to extract (i.e., the record is a scalar value). Examples: JSONPath: $.name extracts the name property from each record. XPath: ./ID extracts the <ID> element from each record.
Target Field	Data Field	►	The Grooper field to populate with the extracted value. ConverterTarget Field Converter Select a field from your data model to automatically store the extracted value. If left blank, the value will appear as a column in the lookup results but will not be stored in any field. Use this to map web service data directly to your Grooper fields for automation and validation.
Alias Name	String	►	An optional alias to use as the column name in the results table. Enter a custom name to display this value as a column in the lookup 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 Grooper field.

See Also

Data Field

Used By

Web Service Lookup