Execute Powershell Script
Description
Use the step to execute PowerShell Script. Write the script using value to generate output fields by using the specific syntax in the console. These generated fields can be used in subsequent steps at runtime.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 2 | Fail if error? | Enforces strict error checking. If checked, the step fails immediately when any error occurs. If unchecked, the step fails only if an error occurs and no standard output is produced. For example, Suppose the step extracts data from a file. If checked, even a small error (such as a missing column) causes the step to fail. If unchecked, the step fails only if an error occurs and no data is extracted. If some data is extracted despite the error, the step continues. |
| Left Pannel | ||
| 1 | Get Input Fields | Click and select the input fields from the list to add in console. |
| 2 | Write to Console: | |
| 2.1 | Write Value to Console | Click to write output values to console in given syntax. Syntax to write value: Write-Host "<<>>FieldName::FieldValue<<>>" |
| Right Pannel | ||
| 1 | Powershell Script Tab | A console to write value or use input fields in Powershell Script. |
| Tabular Fields | The Fields table displays a list of output fields extracted from script. It also allows users to add metadata such as descriptive names for each field. | |
| 1 | Field Name | Displays name of the fields extracted from the script. for example, from Write-Host "<<>>FieldName::FieldValue<<>>" |
| 2 | Rename to | Optional new name for the field. Used when you want to display or reference the field using a different name. |
| 3 | Type | Select the data type of the field. Following are the type and available supported formats: Supported types are: - String - Date: Supported formats: - yyyy-MM-dd - dd/MM/yyyy - MM/dd/yyyy - dd-MMM-yyyy - yyyyMMdd - dd-MM-yyyy - yyyy/MM/dd - dd.MM.yyyy - MMM dd, yyyy - dd MMM yyyy - Boolean - Integer - BigNumber - Binary - Timestamp: Supported formats: - yyyy-MM-dd HH:mm:ss - yyyy-MM-dd'T'HH:mm:ss - yyyy-MM-dd'T'HH:mm:ss.SSSX - MM/dd/yyyy HH:mm:ss - dd-MMM-yyyy HH:mm:ss - Internet Address |
| 4 | Length | Specifies the length of the field: - Number: Total number of significant digits - String: Maximum number of characters - Date: Length of the printed date output |
| 5 | Precision | Specify the number of digits to display after the decimal point. This applies only to numeric types. - Number: Defines floating-point precision. - Other types: This setting is not used. |
| 6 | Replace value ‘Fieldname’ or ‘Rename to’ | Select Y (Yes) to find an existing field in the input stream that matches Fieldname and replaces its value. Select N (No) to add a new field to the output stream. |
| Action Button | ||
| 1 | Get Output Fields | Click Get Output Fields to see all output field details in table. When the Get Output Fields is clicked, the tool scans the entire script and looks for statements in the following format: Write-Host "<<>>FieldName::FieldValue<<>>" It parses these statements, extracts the FieldName, and populates the Fields table accordingly. |