Actions8
Overview
This node integrates with the Xano API to perform bulk updates on rows within a specified table by their IDs. It is designed to efficiently update multiple records in one operation, which is useful when you need to modify large datasets without making individual update calls for each row.
Common scenarios include:
- Updating status fields for many records simultaneously.
- Correcting or appending data across multiple entries in a database table.
- Synchronizing external data sources with your Xano backend in bulk.
For example, if you have a "Users" table and want to update the "subscriptionStatus" field for several users at once, this node allows you to specify all changes in one request, improving performance and reducing API calls.
Properties
| Name | Meaning |
|---|---|
| Workspace Name or ID | Select or specify the workspace where the target table resides. This scopes the operation to the correct environment in Xano. |
| Table Name or ID | Select or specify the table containing the rows you want to update. |
| Configuration Method | Choose how to provide the update data: - Field Builder: Use the UI to add multiple items, each with fields and new values. - JSON Input: Paste a JSON array representing rows to update directly. |
| Items to Bulk Update | (Shown if using Field Builder) Add multiple items to update. Each item contains multiple fields with: - Field Name or ID: The specific column to update. - New Value: The value to set for that field. |
| Items (JSON Array) | (Shown if using JSON Input) Provide a JSON array where each object represents a row to update. Field names must match the table schema exactly. |
Output
The node outputs JSON data representing the result of the bulk update operation. Typically, this includes confirmation of updated rows or details about any errors encountered during the process.
If binary data were involved (not indicated here), it would be summarized accordingly, but this node focuses on JSON content updates only.
Dependencies
- Requires an active connection to the Xano API via an API key credential configured in n8n.
- The node depends on the Xano workspace and table structure; these must exist and be accessible with the provided credentials.
- Uses internal methods to load options dynamically for workspaces, tables, and fields based on user selections.
Troubleshooting
- Invalid Workspace or Table ID: Ensure the workspace and table IDs or names are correct and accessible with your API credentials.
- Field Name Mismatch: When using JSON input, field names must exactly match those defined in the Xano table schema; otherwise, updates will fail.
- Empty or Malformed JSON: If using JSON input, verify the JSON array syntax is correct and not empty.
- API Authentication Errors: Check that the API key credential is valid and has sufficient permissions.
- Partial Updates Fail: If some rows fail to update, check individual field values for type mismatches or validation rules enforced by Xano.