Aggregate

Combine a field from many items into a list in a single item

Usage and specifics

Use Aggregate to extract a field from each item and obtain one list of values. For a total or average, use Summarize instead.

With manual input { "contacts": [{ "email": "[email protected]" }, { "email": "[email protected]" }] }, set source to input.contacts, field to email, outputField to emails and operation to append.

Expected output:

{
  "emails": ["[email protected]", "[email protected]"],
  "count": 2
}

The result property name depends on outputField. With this configuration, use {{ nodes.aggregate1.emails }}, adapting the technical name; no items property is added automatically.

append preserves values in a list. concat converts them to text and joins them without a separator: here, the result would be [email protected]@example.test. This mode does not flatten arrays or add a comma or newline. First check the format accepted by your destination.

Technical type : aggregate. Runtime : nodulz.

Credentials and prerequisites

This node defines no dedicated external credential. Remote sources or execution targets may still need their own access credentials.

See the credentials guide if a remote source or execution target requires access.

Parameters

Names below are technical keys. Defaults are not a ready-to-run configuration: complete fields required by your operation. Paths containing [] describe list items; some fields depend on the selected mode.

Initial configuration

Initial catalog configuration example, to adapt before running. Keep secrets in credentials.

{
  "source": "",
  "field": "",
  "outputField": "aggregated",
  "operation": "append"
}

Verification

Check the output field name, number of values and their type. With an empty source and append, expect an empty list and count: 0. Also test a contact without email: this node does not validate required fields, which should be checked upstream.

See also : Expressions and data, Executions, Node catalog.