Get Param
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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.
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
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.
File path = C:\Users\Abc\Sam.xlsx.Sheet4
It needed to fetch the data from an Excel sheet.
As per scenario, using the Get Param action in Excel will fetch the data and login successfully in that application.