Get Data

This is prebuilt action located under the @Generic element, instructs the Avo Assure to retrieve the data from databases table and save the result in dynamic variable.

Syntax

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

Argument	Description
<DB IP/instance name/DB file path> (Required)	Specifies the database server location, instance identifier, or database file path
<DB port> (Required)	Required port number to connect database.
<DB username> (Required)	Require username credential for database access.
<DB Password> (Required)	Require password credential for database access.
<DB name> (Required)	Required name of the database to connect.
<Query> (Required)	Required SQL or Non SQL query to be executed.
<DB Number> (Required)	Database Number serves as a unique identifier for a specific database connection.
<collection/warehouse> (Optional)	Required the specific data container within the database to target.
<querytype/schema> (Optional)	Defines the nature of the query or specifies the database schema to be used.

Click below link to get more information about Supported Database in Avo Assure

Supported Technologies

Note:

When using a Non-SQL Query to run a specific action, the user must provide either the collection name or the warehouse name in the input syntax.

Output Value:

Argument	Description
<Dynamic Variable> (Required)	This variable holds the data fetched from the database.​
<Dynamic Variable> (Optional)	This variable stores the status as True or False

Example Retrieve data from a database using the Get Data Action

The Get Data(DB) action takes the database connection details and a query from the Input Value column. It connects to the specified database (using parameters- DB IP, port, credentials, etc.), executes the query, and stores the result in the {DB_Data} variable. The execution status is stores in the {Status} variable, with the following possible values:

• True – if data is successfully retrieved

• False – if the data retrieval fails or no records are returned

Note: If user want to display the stored data then they can use display variable value action and in the input value column user can give value in array format {Variable name [row number][Column number]}.