Execute a SQL Query using an ODBC connection
Execute a query using an ODBC connection.
Application
Inputs (what you have)
| Name | Description | Data Type | Required? | Example |
|---|
| ODBC Connected Account | The credentials for the ODBC connection | Connected Account | Yes | |
| SQL Query | The SQL query to execute | Text (Long) | Yes | SELECT * FROM users; |
Outputs (what you get)
| Name | Description | Data Type | Required? | Example |
|---|
| Server message | Message from the server regarding the executed query | Text (Long) | No | |
| Output JSON | Execution results from the SELECT query | Text (Long) | No | |
| Total number of rows | Number of rows returned as part of the query | Number | No | |
Outcomes
| Name | Description |
|---|
| Success | This status is selected if the job has successfully completed. |
Requirements