Get Data

This is prebuilt action in Avo Assure which is located under the @Generic element category. It instructs the Avo Assure Client to retrieve the data from databases table and subsequently stored it in the output variable.

Syntax

Input: <DB IP/instance name/DB file path>; <DB port>; <DB username>; <DB password>; <DB name>; <Query>; <DB Number>; <collection/warehouse>(Optional); <querytype/schema>(Optional)

Output: <Dynamic Variable>;<Dynamic Variable>(Optional)

Use case/Example

Scenario: Consider a scenario where user is testing

Consider a retail application where users frequently input customer details such as name, email, phone number, and relevant order details while placing orders. It is crucial to ensure that the data entered through the application interface is accurately stored in the backend MSSQL database. For this scenario the Get Data (DB) action used by Avo Assure. It automates the process of retrieving and validating this data directly from the database.

Expected Result

The Get Data action needs to retrieve the data from database and stores result in output variable.

Output

The Get Data action performed and saves the result ( Data from query) in the {Result} output variable.