Ninox icon

Ninox

Complete Ninox API integration with all available endpoints

Record → Upsert

AI-generated

Summary

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.

Discussion