JSON CRUD icon

JSON CRUD

Perform CRUD operations on JSON data (perfect for Excel data)

Actions6

Delete

AI-generated

Summary

Delete records from JSON data either by specifying matching conditions or by row index.

Inputs

  • Delete Mode (required) — Choose between deleting records by matching conditions or by specific row indices.
  • Row Index (required) — Specify the 0-based row indices to delete. Supports single (e.g., 0), range (e.g., 0-5), or multiple indices (e.g., 0,2,4). Shown only if 'Delete Mode' is 'By Row Index'.
  • Delete Conditions (required) — Set one or more conditions that records must match to be deleted. Each condition includes a field name, operator, and optionally a value. Shown only if 'Delete Mode' is 'By Condition'.
  • Condition Logic (required) — Specify how multiple delete conditions are combined: 'AND' (all conditions must match) or 'OR' (any condition matches). Shown only if 'Delete Mode' is 'By Condition'.
  • Case Sensitive — Determine if string comparisons for conditions should be case sensitive. Defaults to false. Shown only if 'Delete Mode' is 'By Condition'.

Output shape

a list of items with the specified records removed

If 'By Row Index' mode is selected, the records at the specified indices are removed from the input items. If 'By Condition' mode is selected, all records matching the conditions (based on case sensitivity and condition logic) are removed. Input items without matching conditions remain. No new records are added.

Examples

Example 1: Delete records where the 'status' field equals 'inactive' (case-insensitive)

Set 'Delete Mode' to 'By Condition', add a condition with Field Name='status', Operator='Equals', Value='inactive', Condition Logic='AND', and disable Case Sensitive.

Example 2: Delete records at row indices 0, 2, and 4

Set 'Delete Mode' to 'By Row Index' and specify '0,2,4' in 'Row Index' field.

Links

Discussion