Overview
This node allows you to create a new row in a specified table within a NocoDb project (or base). It supports multiple API versions of NocoDb and different authentication methods. The node is useful when you want to insert structured data into your NocoDb tables programmatically as part of an automation workflow.
Common scenarios include:
- Automatically adding new records from form submissions or other data sources.
- Inserting rows based on processed data from previous nodes.
- Uploading files as binary data attached to specific columns in the new row.
For example, you could use this node to add a new customer record with details like name, email, and profile picture into a "Customers" table whenever a new signup occurs.
Properties
| Name | Meaning |
|---|---|
| Authentication | Choose the authentication method: either using an API Token or a User Token. |
| API Version | Select the version of the NocoDb API to use: Before v0.90.0, v0.90.0 Onwards, or v0.200.0 Onwards. This affects endpoint URLs and request formats. |
| Workspace Name or ID | (Only for API v0.200.0 Onwards) Select or specify the workspace where the base resides. |
| Base Name or ID | (API v0.90.0 Onwards and v0.200.0 Onwards) Select or specify the base/project containing the target table. |
| Project ID | (Before API v0.90.0) Specify the project ID where the table exists. |
| Table Name or ID | Select or specify the table where the new row will be created. |
| Data to Send | Choose how to provide the data for the new row: - Auto-Map Input Data to Columns: Automatically map incoming JSON fields to table columns by matching names. - Define Below for Each Column: Manually specify each column's value. |
| Inputs to Ignore | (When using Auto-Map mode) Comma-separated list of input fields to exclude from being sent to NocoDb. Leave empty to send all. |
| Fields to Send | (When using Define Below mode) Add one or more fields specifying: - Field Name: The column name. - Is Binary File: Whether the field contains binary data. - Field Value: The value to set (if not binary). - Take Input From Field: The binary property name containing file data (if binary). |
Output
The node outputs an array of JSON objects representing the newly created rows. The structure depends on the API version:
- For older API versions, the output includes the original data plus assigned IDs.
- For newer API versions, the output reflects the full response from NocoDb including any additional metadata returned after creation.
If binary data was uploaded as part of the row creation (e.g., file attachments), the node handles uploading these files separately and stores references in the respective fields.
No direct binary output is produced by this node; binary data is uploaded to NocoDb storage and referenced in the JSON output.
Dependencies
- Requires access to a NocoDb instance with appropriate API credentials (either API token or user token).
- The node uses HTTP requests to NocoDb REST API endpoints, which vary depending on the selected API version.
- For binary file uploads, multipart/form-data POST requests are made to NocoDb's storage upload endpoints.
- The node expects proper configuration of credentials in n8n to authenticate API calls.
Troubleshooting
- Error creating rows: Could be due to invalid table or project/base IDs, incorrect API version selection, or insufficient permissions. Verify all IDs and credentials.
- Binary file upload failures: Ensure the binary property specified exists and contains valid file data. Also check that the API version supports the used upload endpoint.
- Empty or missing output: Confirm that input data is correctly mapped or defined. If using auto-map, ensure input field names exactly match column names.
- API errors with status 404 or 400: Usually indicate resource not found or bad request. Double-check table and project IDs, and the format of data sent.
- Continue on Fail behavior: If enabled, errors during row creation will be captured in the output instead of stopping execution, allowing partial success.
Links and References
- NocoDb Official Documentation
- NocoDb API Reference
- n8n Expressions Documentation (for dynamic parameter values)