Overview
The Undb node for n8n allows you to interact with the Undb API, specifically to create new records in a specified table. The "Record: Create" operation is used to insert a new row into a chosen table, either by mapping input data automatically or by defining each field manually. This node is useful when you need to automate data entry into Undb from other systems, such as syncing form submissions, importing data from spreadsheets, or integrating with other business tools.
Example scenarios:
- Automatically add new customer information to an Undb table when a signup occurs.
- Import rows from a Google Sheet into Undb.
- Log events or transactions from another application directly into Undb.
Properties
| Name | Meaning |
|---|---|
| Authentication | Select the authentication method for connecting to Undb. Options: - Api Token - Auth Api Token |
| Table Name or ID | The ID of the table where the record will be created. You can select from a list or specify an ID using an expression. |
| Data to Send | Choose how to provide the data for the new record: - Auto-Map Input Data to Fields: Use this if your input properties match the destination field names. - Define Below for Each Field: Set values for each field. |
| Fields to Send | (Shown only if "Define Below for Each Field" is selected) Specify one or more fields and their values to include in the new record: - Field Name: The name of the field. - Field Value: The value to set. |
Output
- The output will contain the JSON representation of the newly created record as returned by the Undb API.
- Typical structure includes all fields of the created record, such as IDs, timestamps, and any custom fields you provided.
- No binary data is produced by this operation.
Example output:
{
"id": "rec12345",
"createdAt": "2024-06-01T12:34:56Z",
"field1": "value1",
"field2": "value2"
}
Dependencies
- Requires access to the Undb API at
https://demo.undb.com. - An API token or Auth API token must be configured in n8n credentials under the appropriate authentication method.
Troubleshooting
- Invalid operation error: If an unsupported operation is selected, the node will throw an error like
Invalid operation create. Ensure you have selected a valid operation. - Authentication errors: If the wrong credentials are used or missing, the node may fail to connect. Double-check that the correct API token is set up in n8n.
- Table not found: If the specified Table Name or ID does not exist, the API will return an error. Verify the table ID or use the dropdown to select a valid table.
- Field mismatch: When using "Auto-Map Input Data to Fields," ensure your input property names exactly match the destination field names in Undb.