Ninox

Read, create and update data from Ninox

Actions10

Overview

The Ninox node's "Update" operation allows you to update an existing record in a specified table within your Ninox database. This is useful for automating data maintenance, synchronizing information from other systems, or batch-updating records based on workflow logic. For example, you might use this node to update customer details after receiving new information from another application, or to mark records as processed after completing a task.

Properties

Name	Type	Meaning
Team Name or ID	options	The ID of the team to access. Choose from a list or specify an ID using an expression. Required to identify which team's databases to work with.
Database Name or ID	options	The ID of the database to access. Choose from a list or specify an ID using an expression. Required to select the database containing the target table.
Table Name or ID	options	The ID of the table to access. Choose from a list or specify an ID using an expression. Required to specify where the record to be updated resides.
Record ID	string	The unique identifier of the record to update. Use an expression to update multiple incoming records dynamically.
Add All Fields	boolean	Whether to send all fields to Ninox (true) or only specific ones (false). If false, you must specify which fields to update using the "Fields" property.
Fields	string[]	The names of the fields to update in Ninox. Only shown and required if "Add All Fields" is set to false. Allows selective updating of record fields.

Output

The output will contain the updated record(s) in JSON format, reflecting the changes made.
The structure typically mirrors the Ninox record schema, including field names and their updated values.
Example output:

{
  "id": 123,
  "field1": "new value",
  "field2": 42,
  ...
}

No binary data is produced by this operation.

Dependencies

External Service: Requires access to the Ninox API.
API Key/Credentials: You must configure valid Ninox API credentials (ninoxApi) in n8n.
n8n Configuration: Ensure the Ninox node is properly authenticated and that the relevant team, database, and table exist.

Troubleshooting

Missing or Invalid IDs:
- Error: "Team/Database/Table/Record not found"
  Resolution: Double-check that the provided IDs are correct and that you have access permissions.
Insufficient Permissions:
- Error: "Unauthorized" or "Forbidden"
  Resolution: Ensure your Ninox API credentials have sufficient rights to update records in the specified table.
Field Validation Errors:
- Error: "Invalid field name" or "Field is required"
  Resolution: Make sure the field names match those defined in your Ninox table and that required fields are included.
Empty Fields Array:
- Error: "No fields specified" when "Add All Fields" is false
  Resolution: Specify at least one field in the "Fields" property.