Actions8
- Table Actions
- Endpoint Actions
- Pipeline Actions
- Query Actions
- Script Actions
Overview
This node allows users to create a new SQL query within the UbuntuFabric platform by specifying a query name and the SQL statement itself. It is useful for automating the creation of reusable SQL queries that can be executed later or integrated into data pipelines. For example, a user might create a query to select all records from a specific table or to join multiple tables for reporting purposes.
Properties
| Name | Meaning |
|---|---|
| Query Name | The name assigned to the new SQL query being created. |
| SQL Query (View) | The actual SQL statement text that defines the query logic (e.g., SELECT * FROM my_table;). |
Output
The node sends a POST request to the endpoint responsible for creating SQL queries in the backend system. The output will typically contain the response from this API call, which may include details about the newly created query such as its ID, status, or confirmation message. The exact structure depends on the API response but generally includes JSON data confirming successful creation.
No binary data output is involved.
Dependencies
- Requires an active connection to the UbuntuFabric platform.
- Needs an API key credential configured in n8n to authenticate requests.
- The node makes HTTP POST requests to the
/api/database/tables/create-sql-query/endpoint of the UbuntuFabric API.
Troubleshooting
Common issues:
- Missing or invalid API credentials will cause authentication failures.
- Invalid SQL syntax in the "SQL Query" property may result in API errors.
- Network connectivity problems can prevent the node from reaching the UbuntuFabric API.
Error messages:
- Authentication errors usually indicate missing or incorrect API keys; verify credentials.
- Validation errors from the API may point to malformed SQL or missing required fields; check the query syntax and ensure the "Query Name" is provided.
- Timeout or network errors suggest connectivity issues; confirm internet access and API availability.
Links and References
- UbuntuFabric Documentation (general platform info)
- SQL syntax references (depending on the database used in UbuntuFabric)