Get PS Variables
Description
Get PS Variables reads the values of existing PS (Process Studio) variables and converts them into workflow fields with specified data types, formats, and precision. This step is the counterpart to Set PS Variable — use it when you need to bring variable values back into the data stream for processing, output, or conditional logic. It is especially useful in workflows where variables were set in an earlier step or a parent process and now need to be used as row-level field data for downstream operations like filtering, calculations, or writing to output.
Configurations
| Field Name | Description |
|---|---|
| Step Name | Name of the step. This name has to be unique in a single workflow. |
| Field values (Tabular): | |
| Variable | Specify the variable which needs to be converted to a field. |
| Field name | Specify a new field name to contain the variable value. Note: When the variable value will be converted to field the specified type, format and other attributes will be taken into consideration. |
| Type | Specify the type of the field by picking from the list as below. Number, String, Date, Boolean, Integer, Big Number, Binary Timestamp, Intenet Address. |
| Format | Specify the format of the field. |
| Length | Specify the length of the field. |
| Precision | Specify the precision of the field. |
| Currency | Specify the currency of the field. |
| Decimal | Specify the number of decimals for the field. |
| Group | Specify the Group of the field. |
| Trim type | Specify the Trim type of the field from the following, - None - left - right - both |
| Secret | Select Y or N to set the secret status of the variable. The step applies the setting based on the data source. - Incoming data (runtime override): If the referenced PS variable is marked as Secret in the PS Variables tab, the output field is automatically marked as Secret. The Secret field displays Y and cannot be changed. - Default values: The Secret setting controls any static value entered in the Default Value field. - Y: Protects the default value. The step displays a masked input dialog, encrypts the value in the saved workflow, and masks it (displays ********) during runtime.- N: Keeps the default value visible as plain text. - Note: - Workflow boundaries: The secret status is retained when passing data to parent workflows using the Set Workflow Result step. The step encrypts the data before sending it to the server. - Lost protection on rename: Renaming a secret column using the Rename Fields step removes the secret status and exposes the data as plain text. - Lost protection on modification: If a secret field is modified in an earlier step (for example, using a Calculator step to create "Token: " + secretField), the result is treated as a new field and is no longer protected. |
| Common Buttons | |
| Buttons | |
| OK | On click of this button. It will check the field values. If any required field values are missing then it will display validation error message. If all the required field values are provided then it will save the field values. |
| Get PS Variables | Click this button to fetch PS Variables. |
| Cancel | On click of this button, it will cancel the window and does not save any values. |