List JSON icon

List JSON

List all keys and values stored in the JSON Vault

List JSON

AI-generated

Overview

This node lists all keys and values stored in a JSON Vault within the workflow's static data. It is useful for inspecting or extracting data from a centralized JSON storage during workflow execution. For example, it can be used to retrieve configuration settings, user data, or any structured JSON data stored in the vault.

Use Case Examples

  1. Extract all keys and values from the JSON Vault to use in subsequent workflow steps.
  2. Retrieve only the keys from the JSON Vault to dynamically generate options or validate data.
  3. Output the entire JSON Vault object for backup or logging purposes.

Properties

Name Meaning
Output Format Determines the format of the output data. Options include returning only keys, keys with their values, or the full vault object.
Include Nested Keys Whether to include nested keys in the output, e.g., keys from nested objects represented in dot notation like 'users.admin.settings'.

Output

JSON

  • vault - The complete JSON Vault object when output format is 'vault'.
  • keys - List of keys in the vault, either top-level or including nested keys depending on the 'Include Nested Keys' setting.
  • count - Count of keys or items returned.
  • items - Array of objects with 'key', 'value', and 'isNested' properties when output format is 'full' (keys and values).
  • totalKeys - Total number of top-level keys in the vault when output format is 'vault'.
  • totalKeysNested - Total number of keys including nested keys when output format is 'vault' and nested keys are included.
  • success - Indicates whether the operation was successful.
  • error - Error message if the operation failed (present only on failure).

Troubleshooting

  • If the JSON Vault is empty or not initialized, the node returns an empty vault object with zero keys.
  • Errors during processing individual items will be caught; if 'Continue On Fail' is enabled, the node will output the error message for that item and continue processing others.
  • If the JSON Vault changes during execution, the node attempts to restore it to its original state to avoid data corruption.

Discussion