Get Data Securely

This is prebuilt action in Avo Assure which is located under the @Generic element category. It instructs Avo Assure Client to retrieve data from database table specified in input and store result in output variable with Input password in encrypted text.

Note: DB password must be encrypted with AES encryption.

Syntax

Input: <DB IP/instance name/DB file path>; <DB port>; <DB username>; <DB Encrypted 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 an authentication application and needs to login authorized user in authentication application. For this scenario Get Data Securely action used by Avo Assure. It securely retrieves a customer's payment details for a refund request. Application runs an encrypted password query to access the data, ensuring it is protected during transaction. It ensures only authorized personnel can view sensitive information and secure retrieval of sensitive customer data.

Expected Result

The Get Data Securely action needs to retrieve Data from databases specified in the input value.

Output

The Get Data Securely action performed and saves result (Secure Data) in the {result} output variable.