Get Param

This is a pre-built action in Avo Assure under the @Generic element. It instructs Avo Assure to access data from an Excel file or Data Table. It is useful when you want to parameterize the data values to be entered in a Test Case.

Information about ADV parameter in Get Param Action

The ADV (Advance) parameter is used in the Get Param action when applying data parameterization in Avo Assure. It helps you to manage and execute test cases efficiently when working with large or multiple datasets stored in a single Excel sheet.

Purpose and Usage

  • The ADV option is used when there are multiple data sets related to multiple test cases stored in one Excel sheet.

  • It is helpful when testing the same test cases across different environments (for example, QA, UAT, or Production).

  • By using ADV, Avo Assure can dynamically pick the right data set during execution, reducing the need to maintain multiple Excel files.

Creating the Excel Sheet for Using ADV Parameter

  1. When adding the test data of multiple test cases in a single Excel sheet, make sure to segregate the test data by defining their names as the header values. Note: Ensure the header values and test case names are the same so that they can be identified easily during execution in Avo Assure

  1. When adding the test data of multiple test cases that are linked together in an end-to-end flow within a single Excel sheet, provide the header value as the name of the end-to-end flow. Note: This helps Avo Assure identify and use the correct set of data for the entire end-to-end flow during execution.

Syntax

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

Argument
Description

<file path> (Required)

Provide the location of the Excel or CSV file from which the data needs to be fetched.

<Sheet name in case of excel> (optional)

Provide the sheet name from the Excel file to read the data.

<row count> (Optional)

Provide the number of rows to fetch from the beginning of the file.

<start row - end row> (Optional)

Provide the range of rows to fetch data from specific rows in the file.

ADV (Optional)

Use ADV parameter to fetch data dynamically during test execution.

local (Optional)

Use local parameter when the file is stored locally on your machine.

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;;ADV) and retrieves a specific range of data rows in advanced mode. It allows users to fetch structured test data with greater control, making it useful 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 Data Table. It is not required to provide the file path.

Note: You don’t need to enter the path manually. When you select the Get Param action, a table icon appears that allows you to choose the required table and column.

Example 4

The Get Param action takes the value from the Input Value column (e.g., C:\Users\Downloads\ABC.xlsx;Sheet1;;;local) and retrieves test data from the specified Excel sheet. When you use the local parameter, the current Test Step Group (TSG) uses its own internal data instead of the one from the execution configuration.

Note: The local action is not case-sensitive (you can use local, Local, or LOCAL).

PreviousEnd-ForNextStart Loop

Last updated

Was this helpful?