MSSQL Query

The MSSQLQuery component in Robbot RPA allows you to execute a SQL query on a Microsoft SQL Server database. This component runs the specified query and returns the output as a JSON array (JArray) that can be further processed or used in subsequent actions.

Parameters

Query : Insert the SQL query you want to execute. This parameter should contain a valid SQL statement that can be understood by the Microsoft SQL Server database. Type : String

Result : Returns the output of the query execution as a JSON array. The result can contain one or more rows of data retrieved from the database based on the provided query. Type : JArray

Usage

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

Drag and drop the MSSQLQuery component into your sequence or workflow. Configure the component by providing the necessary inputs: Insert the SQL query you want to execute into the Query parameter. Continue building your sequence or workflow by adding other components or actions that depend on the query result. Execute your sequence or workflow. The MSSQLQuery component will execute the specified SQL query on the Microsoft SQL Server database and retrieve the output as a JSON array. Use the query result, which is returned as a JSON array (JArray), in subsequent components or actions to process the data or perform desired operations. By leveraging the MSSQLQuery component, you can seamlessly execute SQL queries on Microsoft SQL Server databases within your Robbot RPA automation, enabling efficient data retrieval and manipulation for your business processes.