Get Value Activity

The Get Value activity extracts specific values from elements or attributes within an XML dataset. It processes data obtained from a preceding XPath execution, enabling users to retrieve targeted information based on row and column specifications.

Field	Description	Requirement
Input dataset	The name of the output dataset from a preceding Execute XPath activity.	Required
Row	The zero-based row index from which to retrieve the element's value within the dataset.	Required
Column	The zero-based column index or an XPath expression used to locate the specific element or attribute within the selected row.	Optional
Output value	The name of the variable that will store the extracted value.	Required

Action Types & Examples

Extracted Value

Format: string
Example Result: outputValue

Implementation Examples

Field Setup - Input dataset: ${inputvalue} - Row: 4 - Column: 0 - Column: //author - Output value: outputValue

Technical Notes

The Get Value activity operates on XML datasets, typically generated by an Execute XPath activity.

When specifying the Row parameter, elements are indexed starting from 0. For example, in an XML structure where //Invoice refers to the root:
<Invoice>
  <Return_ID>135672</Return_ID>
  <Store_ID>23465</Store_ID>
  <Store_Name>BELGE</Store_Name>
  <Supplier_Name>Third Part Company</Supplier_Name>
  <Supplier_Account_No>7330028047</Supplier_Account_No>
  <Brand_ID>14235</Brand_ID>
</Invoice>
To access the <Supplier_Account_No> element, the Row value should be 4.

The Column parameter can accept either a zero-based numeric index or an XPath expression. A positive number will search by column index, while a non-numeric value (e.g., //author) will search by header information or a specific XPath.