Actions8
- Table Actions
- Endpoint Actions
- Pipeline Actions
- Query Actions
- Script Actions
Overview
This node integrates with the UbuntuFabric platform to retrieve data from a specified database table. The "Table" resource with the "Get" operation allows users to fetch rows from a chosen table by specifying its name or ID. This is useful for scenarios where you want to extract structured data stored in UbuntuFabric tables for further processing, analysis, or integration with other systems.
Practical examples include:
- Extracting user records from a customer database table.
- Retrieving transaction logs for reporting purposes.
- Accessing configuration or metadata stored in custom tables.
Properties
| Name | Meaning |
|---|---|
| Table Name or ID | Choose a table from a dropdown list or specify its ID using an expression. This determines which table's rows will be fetched. |
Output
The output of this node is a JSON array representing the rows retrieved from the specified table. The relevant data is found under the json property of each item, specifically within the results property of the API response. Each element corresponds to a row in the table, with fields matching the table's columns.
No binary data output is produced by this node.
Dependencies
- Requires an active connection to the UbuntuFabric platform via an API key credential.
- The node uses the base URL
https://app.ubuntufabric.io/for API requests. - Proper permissions on the UbuntuFabric account to access the specified table are necessary.
Troubleshooting
Common issues:
- Invalid or missing table name/ID: Ensure the table exists and the identifier is correct.
- Authentication errors: Verify that the API key credential is valid and has sufficient permissions.
- Network connectivity problems: Check internet connection and firewall settings.
Error messages:
- "404 Not Found": The specified table does not exist or is inaccessible. Confirm the table ID/name.
- "401 Unauthorized": Authentication failed. Recheck the API key credential.
- "500 Internal Server Error": Temporary server issue; retry after some time or contact support.
Links and References
- UbuntuFabric API Documentation (for detailed API usage)
- n8n Expressions Documentation (for using expressions in properties)