Export Data

This is prebuilt action in Avo Assure which is located under the @Generic element category. It instructs Avo Assure Client to execute a specified query from the input and export the result to an external file.

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: <File Path>;<Sheet name>(Optional)

Note:

• File path: The user specifies the file location where they want to export the data.

• Sheet name: The user gives sheet name of an excel sheet.

Use case/Example

Scenario:

Consider a scenario where user is testing an e-commerce application, where user inputs sales data on the website, which is stored in the database. To generate monthly reports the Export Data action used by Avo Assure. This action retrieves relevant order, customer, and product information from the database for a specific date range. It allows to easily extract and review the sales data without needing to query the database manually.

Expected Result

The Export Data action needs to execute query from input and stores the result in External files.

Output

The Export Data action performed and saves the results in specified excel sheet.