JSON CRUD icon

JSON CRUD

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

Actions6

Read

AI-generated

Summary

Read and retrieve JSON data from input items using different modes: filter records by specified conditions, sort records by a field and order, search records by keyword in specific or all fields, limit the number of records with an offset, or read specific cells by row indices and field names.

Inputs

  • Read Mode (required) — Select the mode to read data: 'filter' to filter records by conditions, 'sort' to sort records by a field, 'search' to search by keyword, 'limit' to limit number of records with offset, or 'cell' to read specific cells like Excel.
  • Filter Conditions — When 'Read Mode' is 'filter', specify one or more conditions that records must satisfy. Each condition includes a field name, an operator (equals, contains, greater than, etc.), and an optional value. Also specify whether conditions combine with AND or OR logic, and if string comparisons are case sensitive.
  • Sort Field (required) — When 'Read Mode' is 'sort', set the field name to sort by.
  • Sort Order (required) — When 'Read Mode' is 'sort', set the sort order to ascending or descending.
  • Search Field — When 'Read Mode' is 'search', the specific field to search. Leave empty to search all fields.
  • Search Value (required) — When 'Read Mode' is 'search', the keyword or phrase to search for in the field(s).
  • Case Sensitive (search) — When 'Read Mode' is 'search', whether the search is case sensitive.
  • Limit — When 'Read Mode' is 'limit', maximum number of records to return.
  • Offset — When 'Read Mode' is 'limit', number of records to skip before starting to return results.
  • Row Index — When 'Read Mode' is 'cell', specify row indices to read (0-based). Supports single index (e.g. '0'), ranges (e.g. '0-5'), multiple indices (e.g. '0,2,4'), or combinations thereof.
  • Field Names — When 'Read Mode' is 'cell', comma-separated list of field names to read from the specified row(s). Leave empty to read all fields.

Output shape

a list of JSON items matching the read criteria

The output shape depends on the chosen 'Read Mode': for 'filter', 'search', 'sort', or 'limit', it returns a filtered or sorted list of items; for 'cell', it returns items corresponding to specified rows and fields. Filtering supports multiple conditions with configurable logic and case sensitivity. Searching supports searching in a specific field or all fields. Limiting supports offset and count. If no conditions or parameters are specified, the node returns all input items unchanged.

Examples

Example 1: Filter items where 'status' equals 'active' and 'age' is greater than 30.

Set Read Mode to 'Filter', add two filter conditions with 'status' equals 'active' and 'age' greater than '30', condition logic to 'AND', and case sensitivity as needed.

Example 2: Sort items by 'lastName' in descending order.

Set Read Mode to 'Sort', specify 'Sort Field' as 'lastName', and 'Sort Order' as 'Descending'.

Example 3: Search for records containing keyword 'urgent' in any field.

Set Read Mode to 'Search', leave 'Search Field' empty to search all fields, set 'Search Value' to 'urgent', and set case sensitivity as needed.

Links

Discussion