Actions4
Execute Query
AI-generatedOverview
This node executes SQL query statements on an OceanBase database. It is useful for retrieving data by running custom SQL queries, such as selecting user information based on specific criteria. For example, you can use it to run a query like 'SELECT * FROM users WHERE id = ?' with parameters to fetch user details dynamically.
Use Case Examples
- Retrieve user data by ID using a parameterized SQL query.
- Run complex SQL queries to filter and aggregate data from OceanBase.
Properties
| Name | Meaning |
|---|---|
| Query | The SQL query statement to execute, which can include placeholders for parameters. |
| Options | Additional options for the query execution, including query parameters and fields to return. |
Output
JSON
json- The result rows returned from the executed SQL query, each row as a JSON object.
Dependencies
- OceanBase database connection using credentials with host, port, database, user, and password.
Troubleshooting
- Ensure the SQL query syntax is correct and matches the OceanBase SQL dialect.
- Verify that query parameters match the placeholders (?) in the SQL query and are provided in the correct order.
- Check database connection credentials and network accessibility to the OceanBase instance.
- Common error: 'Unknown operation' if an unsupported operation is selected; ensure 'Execute Query' is chosen for this operation.