Get Data
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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)
<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
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:
<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]}.
