Actions8
Overview
The node integrates with the Xano API to perform bulk creation of rows in a specified table within a workspace. It is designed to efficiently insert multiple records at once, which is useful for batch data imports, syncing external datasets, or populating tables with large amounts of structured data.
Typical use cases include:
- Importing CSV or JSON data into a database table.
- Creating multiple entries from form submissions or API responses.
- Automating bulk updates where new rows need to be added regularly.
This operation supports two input methods: a user-friendly field builder UI for specifying each row's fields and values, or direct JSON input for advanced users who prefer to paste raw JSON arrays representing multiple rows.
Properties
| Name | Meaning |
|---|---|
| Workspace Name or ID | Select or specify the workspace where the target table resides. This defines the scope for the table operations. |
| Table Name or ID | Select or specify the table within the chosen workspace where rows will be created. |
| Configuration Method | Choose how to provide the rows to create: - Field Builder: Use the UI to add multiple items, each with multiple fields and their values. - JSON Input: Paste a JSON array where each object represents a row. |
| Items to Create | (Shown if using Field Builder) Add one or more items, each containing multiple fields. For each field, select the field name and enter its value. |
| Items (JSON Array) | (Shown if using JSON Input) Paste a JSON array where each object corresponds to a row to create. Field names must match the table schema exactly. |
| Allow ID Field | Boolean flag indicating whether the input can include the ID field for rows. If enabled, you can specify IDs explicitly; otherwise, IDs are auto-generated by the system. |
Output
The node outputs JSON data representing the results of the bulk row creation operation. Each item in the output corresponds to a created row and typically includes the newly created row's data as returned by the Xano API.
If the node supports binary data output (not indicated here), it would represent any file attachments or binary content associated with the created rows, but this operation focuses on JSON data only.
Dependencies
- Requires an active connection to the Xano API via an API key credential configured in n8n.
- The node depends on the availability of the specified workspace and table within the Xano environment.
- Proper permissions on the API key to create rows in the target table are necessary.
Troubleshooting
- Invalid Workspace or Table ID: Ensure that the workspace and table IDs or names are correct and accessible with the provided API credentials.
- Field Name Mismatch: When using JSON input, field names must exactly match those defined in the table schema. Otherwise, the API may reject the request.
- ID Field Usage: If "Allow ID Field" is false but IDs are included in the input, the operation may fail or ignore those IDs.
- API Rate Limits or Quotas: Bulk operations might hit API limits; monitor usage and consider splitting large batches.
- Malformed JSON Input: When using JSON input, ensure the JSON array is valid and properly formatted.
Common error messages usually relate to authentication failures, invalid resource references, or schema mismatches. Verifying credentials, workspace/table existence, and input formatting typically resolves these issues.