JSON CRUD icon

JSON CRUD

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

Actions6

Create

AI-generated

Summary

Add new JSON data records to the existing input items by appending or prepending them.

Inputs

  • Data to Add (required) — JSON data to add as new records; supports raw JSON objects/arrays or entire nodes dragged in from the panel.
  • Position — Determines whether to append the new data to the end or prepend it to the beginning of the existing items. Options: 'Append' or 'Prepend' (default 'Append').

Output shape

a list of JSON items including the original items plus the added entries in the specified position

If the input items are an array, the data is converted to item format (array of {json: ...}). 'Data to Add' can be a single object or an array of objects. Throws an error if 'Data to Add' cannot be parsed as JSON.

Examples

Example 1: Add a new JSON record by appending it to existing items

Set 'Data to Add' to the JSON object to insert, and 'Position' to 'Append'. The output includes all original items plus the new record at the end.

Example 2: Add multiple records by prepending

Set 'Data to Add' to a JSON array of objects, and 'Position' to 'Prepend'. The output will have the new records first, followed by the original items.

Links

Discussion