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:

The Get Param action allows you to fetch test data efficiently from Excel or internal data tables.

  • It supports retrieving multiple data entries sequentially from Excel.

  • The ADV option enables dynamic row selection, handles empty cells, and supports parameterized data fetching.

  • Users must provide the Testcase name, header, and data in the input for proper linkage.

  • The Testcase name and header must match to use the ADV option.

  • To separate Testcases in Excel, leave one blank row after each test case.

  • The local option allows specific Test Step Groups (TSGs) to use their own internal data table instead of the one defined in the execution configuration.

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> OR (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.

Note: Below is the screenshot of the how to use ADV in Excel

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?