Actions24
- Team Actions
- Database Actions
- Table Actions
- Record Actions
- Query Actions
- File Actions
- Changes Actions
Record → Upsert
AI-generatedSummary
Upsert records in a specified Ninox table within a database and team, by providing records as JSON. It updates existing records or inserts new ones based on the input data.
Inputs
- Team Name or ID (required) — Select the Ninox team (workspace) by name or ID, or use an expression to specify it.
- Database Name or ID (required) — Select the database inside the chosen team by name or ID, or specify it via expression.
- Table Name or ID (required) — Select the target table inside the specified database by name or ID, or specify it with an expression.
- Records JSON (required) — Provide a JSON array representing the records to upsert. Each record should be a JSON object with its fields and values.
Output shape
a JSON array of the upserted records as returned by the Ninox API, with each item corresponding to an input record.
The input 'Records JSON' parameter accepts either a single record object or an array of record objects; internally, the node adds an '_upsert' flag to each object for the API. The API response is returned as-is for each input item. Errors in individual items can either stop execution or continue with error details, depending on the node's error handling settings.
