Universal Data Lookup

Dynamically searches across Grouped, Flat, or Key-Value JSON structures

Universal Data Lookup

AI-generated

Summary

Search the provided JSON dataset (object or array) for an entry matching the given lookup value, supporting multiple dataset structures and returning either the matching item or its category with the item.

Inputs

  • Dataset (required) — The source JSON data object or array to search, which can be a grouped array (dictionary of arrays), flat array (list of objects), or key-value map (dictionary of objects).
  • Lookup Value (required) — The value to search for within the dataset (e.g., "Noir" or "style_1").
  • Structure Type (required) — The structure of the input dataset; can be set to Auto-Detect, Grouped Array, Flat Array, or Key-Value Map to guide the search logic.
  • Search Property — The property key to compare against the Lookup Value when the dataset structure is a grouped array or flat array; ignored for key-value map structures. Defaults to 'name'.
  • Return Mode (required) — Determines the returned data structure: either just the found item (Item Only) or an object containing both the category and item (Category and Item).

Output shape

a list of JSON objects, each containing either the found item alone or an object with category and item fields, corresponding to each input item searched. If no match is found for a given input, that input produces no output element.

The node auto-detects dataset structure if enabled. Search is equality-based on the specified search property or key. If no match is found, no output is produced for that input. Errors per input can optionally be output if "continue on fail" is set.

Links

Discussion