PostgreSQL Query

The Postgre SQL Query component in Robbot RPA allows you to execute SQL queries against a PostgreSQL database. This component is designed to retrieve data from the database based on the provided SQL query and returns the output as a JSON array (JArray).

Parameters

Query : Insert the SQL query that you want to execute against the PostgreSQL database. This parameter should contain a valid SQL statement compatible with PostgreSQL syntax. Type : String

Result : This parameter stores the output of the executed query. The result is returned as a JSON array (JArray) containing the retrieved data from the database. Type : JArray

Usage

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

Drag and drop the PostgreSQLQuery 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 PostgreSQL database into the Query parameter. Continue building your sequence or workflow by adding other components or actions that require the results of the executed query. Execute your sequence or workflow. The PostgreSQLQuery component will execute the SQL query against the PostgreSQL database and store the output in the Result parameter as a JSON array (JArray). Use the retrieved data from the Result parameter in subsequent components or actions to process or manipulate the query results as needed. By utilizing the PostgreSQLQuery component in your Robbot RPA automation, you can easily execute SQL queries against a PostgreSQL database and retrieve data for further processing or analysis within your automation workflow. The query results are conveniently stored in a JSON array format for easy handling and integration with other components or actions.