Max Tool
The Max Tool finds the row(s) with the maximum value: of a key in an array of objects, or of the values themselves in an array of values.
It is useful for workflows that need to identify the highest value in tabular or structured data, such as finding the top customer, largest transaction, or latest date.
- Inputs
- Outputs
- Node Type
rows¹ (array): Array of objects, or of values (numbers, dates, text, booleans), to search.key¹ (string): The key/property name to find the maximum value by. Needed for an array of objects only; a key no object has is an error.requireToolUse(boolean, user config): Require tool use (forces the LLM to always call this tool; default: true)Note: When enabled, the node will retry tool calls up to the number of times set in Max Tool Retries in the AI Data Processing Node.

(1) Provided by the AI Data Processing Node as a result of processing it's input.
- Array of the rows (or values) that have the maximum value.
- If multiple rows share the maximum value, all are returned. Rows with no value (the key missing,
null, blank text) are left out.
How values compare: as booleans (
falsebeforetrue), dates or numbers when every value is one, else as text. Numbers written as text ("1800", as CSV columns hold them) count as numbers. Dates are2024-01-02,2024/1/2,01/02/2024or1/2/24(month first), or text with a month name and a 4-digit year (Jan 2, 2024), each with a time or not; labels such asItem 1are text.
Example Output:
[
{
"customer": "Alice",
"total_spend": 120.50,
"orders": 3
}
]
ai-tooltoolSubtype:max