Get Param

This is a pre-built action in Avo Assure and comes under the @Generic element. It instructs the Avo Assure client to access the data from an excel sheet. It helps when we are trying to data parameterize the value that are to be entered in a test case.

Syntax

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

• 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.