JSON CRUDInstall

Summary

Update records in JSON data by specifying either matching conditions or precise cell positions.

Inputs

• Update Mode (required) — Choose between updating records by matching conditions or by specifying cells by row index and field name.
• Update Conditions — One or more conditions to identify records to update; includes field name, operator, and value. Used when Update Mode is 'By Condition'.
• Condition Logic — Logical operator (AND/OR) to combine multiple conditions.
• Case Sensitive — Whether string comparisons in conditions are case sensitive.
• Fields to Update — Fields and their new values to set on records matching the conditions. Supports multiple fields.
• Row Index (required) — Zero-based row indexes to update when using 'By Cell Position' mode; supports single, ranges, or multiple indices.
• Field Name (required) — Field name of the cell to update when using 'By Cell Position'.
• New Value (required) — New value for the specified cell in 'By Cell Position' mode; supports expressions.

Output shape

a list of JSON records

Returns all input records with updates applied according to the selected update mode. For 'By Condition' mode, only records matching the conditions are modified; for 'By Cell Position', specified rows and field get updated. Values are parsed intelligently into appropriate types (numbers, booleans, dates, etc). If a condition field does not exist in any record, an error is thrown.

Links

• n8n community nodes installation guide