Get Param
This is a pre-built action in Avo Assure and comes under the @Generic element, instructs the Avo Assure to access the data from an Excel file or Data Table. It helps when we are trying to data parameterize the value that are to be entered in a Test Case.
Note: Below are some of the enhancements in Get Param
Now supports fetching multiple data entries sequentially from Excel.
ADV enables dynamic row selection, handles empty cells, and supports parameterized data fetching.
Users must now include Test Case name, header, and data in the input for better linkage.
The Test Case name and header must match to use ADV.
To separate test cases in Excel, leave one blank row after each Test Case.
This enhancement reduces the need for multiple data sheets, making test data easier to manage.
Syntax
For Excel:
Input Value: <file path>;<sheetname in case of excel>(Mandatory)<row count>OR<start row- end row>;ADV
file path (Required)
Path to the source file (Excel, CSV, ) from which data is retrieved.
Sheetname in case of excel (Mandatory)
The name of the sheet within the Excel workbook from which to read data
row count (Optional)
Number of rows to read starting from the top (excluding headers, if any). Use this to fetch a fixed number of rows from the beginning.
start row - end row (Optional)
Fetches data starting from the specified start row to the end row
ADV (Optional)
Additional parameter for Data parameterization to retrieve data from the excel file in dynamic way.
For Data Table:
Note: With the new enhancement, there's no need to type the path. A table icon appears when the Get Param action is selected, allowing you to easily choose the required table and column. By clicking on the icon, a small popup appears where you can see the Data Table folders and column names from Test Data Management.
Output Value:
N/A
Not Applicable
Example 1
The Get Param action takes the value from the Input Value column (e.g., C:\TestData\Credentials.xlsx;LoginSheet;2-4) and retrieves specific rows containing login credentials for automated test execution. This keyword helps parameterize test data from Excel for various Test Cases.
Example 2
The Get Param action takes the value from the Input Value column (e.g., C:\TestData\Credentials.xlsx;LoginSheet;2;ADV) and retrieves a specific range of data rows in advanced mode. This allows users to fetch structured test data with more control, ideal for parameterizing complex test cases in automation.
Example 3 For Data Table
The Get Param action takes the value from the Input Value column (e.g., avoassure/Avo Bank/User Credentials) and fetches test data directly from the Avo Assure Data Table. There's no need to provide the file path.
Last updated
Was this helpful?