Overview
The Undb node for n8n allows you to interact with the Undb API, specifically to retrieve multiple records from a specified table and view. The "Record" resource with the "Get Many" operation is designed to fetch batches of records, making it useful for data synchronization, reporting, or integrating Undb data into other workflows.
Common scenarios:
- Importing large datasets from Undb into another system.
- Automating reports by fetching filtered records from a specific view.
- Periodically syncing Undb tables with external databases or spreadsheets.
Example:
You might use this node to pull all customer records from an "Orders" table in Undb, filtered by a particular view (e.g., "Active Orders"), and then process them further in your workflow.
Properties
| Name | Meaning |
|---|---|
| Authentication | Selects the authentication method for connecting to Undb. Options: "Api Token", "Auth Api Token". |
| Table Name or ID | Specifies the target table in Undb. You can choose from a list or provide an ID using an expression. This property is required. |
| View Name or ID | (Optional) Specifies the view within the selected table to filter which records are retrieved. You can choose from a list or provide an ID using an expression. Only shown for the "Get Many" operation. |
Output
The output consists of a collection of records retrieved from the specified table (and optionally, view). Each item in the output array will have a json field containing the record's data as key-value pairs corresponding to the fields in Undb.
Example output:
[
{
"json": {
"id": "rec123",
"Name": "Alice Smith",
"Email": "alice@example.com",
// ...other fields
}
},
{
"json": {
"id": "rec124",
"Name": "Bob Jones",
"Email": "bob@example.com"
}
}
]
Note: The actual fields depend on your Undb table schema.
Dependencies
- External Service: Requires access to the Undb API at
https://demo.undb.com. - Authentication: You must provide valid credentials for either "Api Token" or "Auth Api Token" (configured in n8n Credentials).
- n8n Configuration: Ensure that the appropriate credentials are set up in your n8n instance under the names "undbApi" or "undbAuthApi".
Troubleshooting
- Invalid Operation Error: If an unsupported operation is selected, the node will throw an error like
Invalid operation getMany. Ensure you select a valid operation. - Missing Table/View: If the "Table Name or ID" or "View Name or ID" is incorrect or missing, the node may fail to retrieve records. Double-check these values.
- Authentication Errors: If credentials are missing or invalid, you'll receive authentication errors. Make sure the correct credential type is selected and configured.
- API Connectivity Issues: Network problems or incorrect base URL configuration can cause connection failures.