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

  • Get Param action has been enhanced to retrieve multiple data entries from the Excel sheet sequentially. The input value for the Get Param action must include the Excel sheet path, sheet name, and ADV.

  • ADV is an additional parameter that ensures parameterized fetching, dynamic row selection, and handling of special cases such as empty cells.

  • Test data in Excel was difficult to interpret due to the absence of a clear link to specific test cases. To address this, an enhancement now requires users to provide the Test Case followed by the header value and corresponding data within the Get Param action.

  • Maintaining test data was challenging as each scenario had to be recorded in a separate sheet, leading to multiple spreadsheets that were difficult to manage. With the enhancement in the Get Param action, this issue has been resolved.

  • The Test Case name and data sheet header name must be same to use additional parameter (ADV)

  • To separate Test Cases in the Excel sheet, leave one blank row at the end of each Test Case.

Syntax

For Excel:

Input Value: <file path>;<sheetname in case of excel>(Mandatory)<row count>OR<start row- end row>;ADV

Argument
Description

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:

Input Value: avoassure/<Folder Name>/<Data Table Name>

Argument
Description

avoassure/<Folder Name>/<Data Table Name> (Required)

Required Data Table path for data parameterization in Test Case

  • Supported Input Format:

1. Text

2. Static values/ Dynamic variables

3. Supported File Types: .xml, .xls, .xlsx, .csv and Avo Assure data tables

Output Value:

Argument
Description

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/LoginTests/UserCredentials) and fetches test data stored in the Avo Assure Data Table for dynamic use in automation scenarios. This helps parameterize inputs like usernames and passwords for multiple Test Cases efficiently.

PreviousEnd-ForNextStart Loop

Last updated

Was this helpful?