Actions30
- Schema Actions
- Record Actions
- File Actions
Schema → Update
AI-generatedOverview
This node operation updates a record in a Ninox database schema. It is useful for scenarios where you need to modify existing data entries in Ninox tables programmatically, such as updating customer information, inventory details, or any other record-based data. The node supports updating specific fields or all fields of a record and can optionally perform an upsert operation to insert a new record if the specified record ID does not exist.
Use Case Examples
- Updating a customer record with new contact details.
- Modifying an inventory item's quantity and price.
- Upserting a record to ensure data consistency by creating it if it doesn't exist.
Properties
| Name | Meaning |
|---|---|
| Ninox Team | The ID of the Ninox team to access, selectable from a list, URL, or direct ID input. |
| Ninox Database | The ID of the Ninox database to access, selectable from a list, URL, or direct ID input. |
| Ninox Table | The ID of the Ninox table to access, selectable from a list, URL, or direct ID input. |
| Record ID | The ID of the record to update. This is required to specify which record to modify. |
| Upsert | Boolean flag to insert a new record if the specified record ID does not exist, enabling update or create behavior. |
| Add All Fields | Boolean flag to send all fields to Ninox or only specific ones when updating. |
| Fields | List of specific field names to send data for when 'Add All Fields' is false. |
| Request Options | Settings for batching, SSL certificate validation, proxy usage, and request timeout to control the HTTP request behavior. |
Output
JSON
recordId- The ID of the updated record in Ninox.success- Indicates whether the update operation was successful.data- The updated record data returned from Ninox.
Dependencies
- Ninox API with authentication credentials
Troubleshooting
- Ensure the Record ID is provided and valid; missing or incorrect IDs will cause update failures.
- Verify Ninox Team, Database, and Table IDs are correct and accessible with the provided credentials.
- If upsert is enabled, check that the API supports creating new records when the ID does not exist.
- Network issues or incorrect proxy settings can cause request failures; verify connectivity and proxy configuration.
- Timeouts may occur if the server is slow or unresponsive; adjust the timeout setting accordingly.
Links
- Ninox REST API Documentation - Official API documentation for Ninox, useful for understanding endpoints and data structures.
- Ninox n8n Node GitHub Repository - Source code and additional information about the Ninox node for n8n.