MySQL Query

The MySQLQuery component in Robbot RPA allows you to execute SQL queries against a MySQL database. This component runs the specified SQL query and returns the output of the query as a JArray object. You can use this output to retrieve and process the results of the query in your automation workflow.

Parameters

Query : Insert the sql query. Type : String

Result : Returns the output of the SQL query as a JArray object. The JArray object can be further processed or used in subsequent components or actions in your automation workflow. Type : JArray

Usage

To use the MySQLQuery component in your Robbot RPA project, follow these steps:

Drag and drop the MySQLQuery component into your sequence or workflow. Configure the component by providing the necessary inputs: Insert the SQL query that you want to execute against the MySQL database into the Query parameter. Continue building your sequence or workflow by adding other components or actions that depend on the output of the SQL query. Execute your sequence or workflow. The MySQLQuery component will execute the specified SQL query against the MySQL database and retrieve the output. Use the output of the SQL query, which is returned as a JArray object, in subsequent components or actions to process or utilize the query results as needed. By incorporating the MySQLQuery component into your Robbot RPA automation, you can easily execute SQL queries against a MySQL database and leverage the query results for further data processing or actions within your automation workflow.