Skip to main content
The Data Value command extracts data from a provider and saves it to a specified output. It can retrieve values from sources such as URL commands, Data Lists, and other commands. Located under Extract in the command palette.

​
Example

Basic Data Value command example

​
Command properties

​
Data value → data value input

Use the Data setting to choose one of the following sources for the Data Value command:
  • Data List: Uses data from a parent Data List command. Select the Data List and the child command or column from which to retrieve the data. A transformation can further customize the value.
  • Command: Uses the parent command or the parent’s parent command as the data source. A transformation can further customize the value.
  • Agent Parameter: Uses an Agent input parameter as the data source. A transformation can further customize the value.
  • Action Result: Uses an action result as the input data. Available results are:
    • Page HTML: Provides the page HTML. A transformation can further customize the value.
    • Page URL: Provides the page URL. A transformation can further customize the value.
    • Is Error: Returns false. A transformation can further customize the value.
    • Page URL File Name: Provides the file name from the page URL. A transformation can further customize the value.
    • Page as PDF File: Provides the page as a PDF file.
    • Proxy: Provides the proxy currently used by the command. A transformation can further customize the value.
    • Return Code: Provides the command status code, indicating whether the command executed successfully.
  • Static Value: Uses a fixed value entered manually. A transformation can further customize the value.
  • Script: Uses a custom Regex, JavaScript, C#, or Python script to produce static or dynamic values.

​
Capture → capture settings

Data Value capture settings Content Type: Specifies the format of the extracted data. Available types are:
  • Text: Captures content as Short Text by default. Short Text supports up to 4,000 characters.
  • Long Text: Captures content that exceeds 4,000 characters.
  • File: Captures documents, images, or other file types.
  • Integer: Captures a whole number.
  • Float: Captures a floating-point number.
  • Date: Captures date values that are not associated with a time.
  • Time: Captures time values that are independent of a date.
  • Date & Time: Captures a combined date and time as a complete timestamp.
  • Boolean: Captures a true or false value. Boolean values are stored as integer 1 or 0.
  • Big Integer: Captures a 64-bit signed integer.
  • Decimal: Captures a decimal floating-point number.
Export: Enables the content to be exported at the end of the process. This option is checked by default. When export is enabled, the following settings are available:
  1. Export Name: Defines the column name in the export schema so the data can be identified and organized in the exported file.
  2. Tracking: Controls whether command content is monitored for changes between runs. The default is Default. This option applies only when Change Tracking is enabled in the command’s export settings.
    • Default: Tracks changes.
    • Identifier: Marks the captured content as an identifier for change tracking.
    • Excluded: Excludes the captured content from change tracking.
  3. Allow Empty: Determines how empty or missing values are handled.
    • Always: Permits empty or missing values.
    • Never: Disallows empty or missing values.
    • Runtime Only: Permits empty values during runtime while enforcing restrictions at other times.
    • Percentage: Permits a specified percentage of empty values.
  4. Validation Format Style: Selects the validation and formatting applied during export.
    • None: Applies no formatting or validation.
    • Regex: Validates values against a custom pattern.
    • Date: Validates and formats values as dates.
    • Numeric Value Range: Ensures numeric data falls within a specified range.
    • JSON: Validates the data as properly structured JSON.
  5. Validation Format: Defines the pattern or structure used with the selected Validation Format Style.
  6. Display Format: Determines how validated data is presented or exported.
  7. Timezone handling: Specifies how time zones are handled during export.
    • Assume Local Time Zone: Treats times as being in the system’s local time zone.
    • Assume Universal Time Zone: Treats all times as UTC, regardless of local time.
    • Adjust to Universal Time: Converts local time to UTC.
  8. Validation error handling: Determines what happens when data validation fails.
    • Report Error: Increases the error count while retaining the row in the export.
    • Report Failure: Reports the failure.
    • Remove Data Row: Removes the entire row from the export.
    • Remove Data Row and Report Error: Removes the row and increases the error count.