> For the complete documentation index, see [llms.txt](https://docs.avoautomation.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avoautomation.com/avo-assure/actions/generic/loops-and-condition-operations-1/get-param.md).

# Get Param

This is a pre-built action in Avo Assure under the **@Generic** element type. Avo Assure uses this action to access data from an Excel file or Data Table, making it is useful when you want to parameterize data values that need to be entered in a Test Case.

{% hint style="info" %}
**Note**:&#x20;

* You cannot use a dynamic variable for the Data Table path. Select the Data Table using the table icon.
* To learn more about how to use Data Parameterize in test case, [click here](https://docs.avoautomation.com/avo-assure/create-and-execute-tests-with-design-studio/working-with-test-case-section/features-in-test-case-section-1/data-parametrization.md).
  {% endhint %}

### Syntax

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

| Argument                                           | Description                                                                                                                                                                                                                                                                         |
| -------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p>\<file path><br>(Required)</p>                  | Provide the location of the Excel or CSV file from which the data needs to be fetched.                                                                                                                                                                                              |
| <p>\<sheetname in case of excel><br>(optional)</p> | Provide the sheet name from the Excel file to read the data.                                                                                                                                                                                                                        |
| <p>\<row count><br>(optional)</p>                  | Provide the number of rows to fetch from the beginning of the file.                                                                                                                                                                                                                 |
| <p>\<start row - end row><br>(optional)</p>        | Provide the range of rows to fetch data from specific rows in the file.                                                                                                                                                                                                             |
| <p>ADV<br>(optional)</p>                           | <p>Use ADV parameter to fetch data dynamically during test execution.<br>To learn more about how to use the <a href="https://docs.avoautomation.com/avo-assure/actions/generic/loops-and-condition-operations-1/get-param/adv-parameter.md">ADV parameter</a><strong>.</strong></p> |
| <p>local<br>(optional)</p>                         | Use local parameter when the file is stored locally on your machine.                                                                                                                                                                                                                |

**Output Value:**

| Argument | Description    |
| -------- | -------------- |
| N/A      | Not Applicable |

#### Example 1: Retrieving a Specific Data Range from an Excel File

In this example, we explain how to retrieve specific rows of test data from an Excel file.

* **Action**: Get Param
* **Input Value**: C:\TestData\Credentials.xlsx;LoginSheet;2-4
  * The first argument (**C:\TestData\Credentials.xlsx**) specifies the Excel file path.
  * The second argument (**LoginSheet**) specifies the worksheet name.
  * The third argument (**2-4**) specifies the row range from which to retrieve data (rows 2 to 4).
* **Output Value**: The retrieved data is available for use in the Test Case.
* **Logical Explanation**: The **Get Param** action fetches the value from the **Input Value** column and retrieves data from rows 2 to 4 of the LoginSheet worksheet in the specified Excel file. This allows users to parameterize test data, such as login credentials, for automated test execution.

<figure><img src="https://2174257472-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8QZzXZMIJSStKAzDSTu%2Fuploads%2Fb5YYTeZPs5OKvmHNJBNH%2Fimage.png?alt=media&amp;token=37ca004b-5327-4e91-a08e-cdae08e2372f" alt=""><figcaption></figcaption></figure>

#### Example 2: Retrieving a Specific Data Range in Advanced Mode

In this example, we explain how to retrieve test data from an Excel file using advanced mode.

* **Action**: Get Param
* **Input Value**: C:\TestData\Credentials.xlsx;LoginSheet;;ADV
  * The first argument (**C:\TestData\Credentials.xlsx**) specifies the Excel file path.
  * The second argument (**LoginSheet**) specifies the worksheet name.
  * The fourth argument (**ADV**) specifies advanced mode for retrieving test data.
* **Output Value**: The retrieved data is available for use in the Test Case.
* **Logical Explanation**: The **Get Param** action fetches the value from the **Input Value** column and retrieves test data from the specified Excel worksheet in advanced mode. This allows users to retrieve structured test data with greater control for automated test execution.

<figure><img src="https://2174257472-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8QZzXZMIJSStKAzDSTu%2Fuploads%2FKDKiT4iDpq1d6amD2wz9%2Fimage.png?alt=media&amp;token=8f18e1c1-3aa9-483c-8d41-135888723c24" alt=""><figcaption></figcaption></figure>

#### Example 3: Retrieving Test Data from Avo Data Table

In this example, we explain how to retrieve test data directly from an Avo Data Table.

* **Action**: Get Param
* **Input Value**: avoassure/Avo Bank/User Credentials
  * The first argument (**avoassure**) specifies the Avo Assure workspace.
  * The second argument (**Avo Bank**) specifies the project name.
  * The third argument (**User Credentials**) specifies the Data Table name.
* **Output Value**: The retrieved data is available for use in the Test Case.
* **Logical Explanation**: The **Get Param** action fetches the value from the **Input Value** column and retrieves test data directly from the specified Avo Data Table. You do not need to provide an Excel file path because the action accesses the selected Data Table directly.

{% hint style="info" %}
**Note**: You can select the required Data Table and column using the table icon that appears when you select the **Get Param** action.
{% endhint %}

<figure><img src="https://2174257472-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8QZzXZMIJSStKAzDSTu%2Fuploads%2FHRFSB1asvblhRR2NQpRE%2Fimage.png?alt=media&amp;token=bd014dcf-f1d6-48a4-a8e3-67832af263b3" alt=""><figcaption></figcaption></figure>

#### Example 4: Retrieving Test Data from an Excel File Using a Local Parameter

In this example, we explain how to retrieve test data from an Excel worksheet using the local parameter.

* **Action**: Get Param
* **Input Value**: C:\Users\Downloads\ABC.xlsx;Sheet1;;;local
  * The first argument (**C:\Users\Downloads\ABC.xlsx**) specifies the Excel file path.
  * The second argument (**Sheet1**) specifies the worksheet name.
  * The sixth argument (**local**) specifies the local parameter.
* **Output Value**: The retrieved data is available for use in the Test Case.
* **Logical Explanation**: The **Get Param** action fetches the value from the Input Value column and retrieves test data from the specified Excel worksheet. The local parameter ensures that the current Test Step Group (TSG) uses its own internal data instead of the data defined in the execution configuration.

{% hint style="info" %}
**Note**: The local parameter is not case-sensitive. You can use local, Local, or LOCAL.
{% endhint %}

<figure><img src="https://2174257472-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fk8QZzXZMIJSStKAzDSTu%2Fuploads%2FHq6yO6O6bqHG1M0v1PjM%2Fimage.png?alt=media&amp;token=a27bf3c2-d572-424b-beec-96b0c7af225a" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**Note**: You cannot use a dynamic variable for the **Data Table** path. Select the **Data Table** using the table icon.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.avoautomation.com/avo-assure/actions/generic/loops-and-condition-operations-1/get-param.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
