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 or Test Step Group name, 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.

Syntax

For Excel:

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

For Data Table:

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

  • Supported Input Format:

1. Text

2. Static values/ Dynamic variables

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

Output: N/A

Use case/Example

Scenario: Fetching Test Data from an Excel Sheet.

In this scenario, users are testing a web application that requires user login credentials for various test cases. The credentials are stored in an Excel sheet. The user wants to automate the process of fetching these credentials using the “Get Param” action to specify which data to retrieve.

Input

File path = C:\Users\Abc\Sam.xlsx.Sheet4

Expected Result

It needed to fetch the data from an Excel sheet.

Output

As per scenario, using the Get Param action in Excel will fetch the data and login successfully in that application.

Last updated

Was this helpful?