JSON array grouper
Open JSON array grouper on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.
Tool capabilities
{
"id": "json-array-grouper",
"category": "data-tools",
"built": true,
"requirements": "At most 10,000 input records and 10 grouping paths. Up to 1,000,000 input characters, 50,000 values per JSON document and 64 nesting levels. Duplicate keys, negative zero and numbers that cannot safely retain their decimal value are rejected. Quote precision-sensitive numbers as strings. Formatting and object member order may change. Processing stays on your device. Each JSON Pointer is limited to 20,000 characters.",
"implementation": {
"fields": [
{
"key": "paths",
"label": "Grouping JSON Pointers",
"value": "[\"/category\"]",
"type": "textarea",
"help": "A JSON array of 1–10 distinct pointers. Use /address/country for a nested key and an empty pointer for the whole record."
},
{
"key": "missing",
"label": "Missing grouping fields",
"value": "Separate group",
"type": "select",
"values": [
"Separate group",
"Reject record"
]
}
],
"live": true,
"presentation": "metrics",
"note": "Group an array by one or more field values. Missing fields and null form different groups. Complex values compare by structure; object member order does not affect grouping. Records and groups retain first-seen order. Runs on your device. Up to 1,000,000 input characters, 50,000 values per JSON document and 64 nesting levels. Duplicate JSON keys, unsafe integers, negative zero and decimals that would change on JSON serialization are rejected rather than rounded. Quote precision-sensitive numbers as strings. Output whitespace and object-member order may change. Each JSON Pointer is limited to 20,000 characters.",
"experience": {
"automatic": true,
"single": false,
"inputMaxLength": 1000000,
"inputMode": "text",
"label": "JSON input",
"placeholder": "[{\"country\":\"PT\",\"score\":90},{\"country\":\"ES\",\"score\":80},{\"country\":\"PT\",\"score\":70}]",
"help": "Paste text to process locally. Review the result before downloading. Results update as you type. Up to 1,000,000 characters.",
"helpParts": [
"Paste text to process locally. Review the result before downloading.",
"Results update as you type.",
"Up to 1,000,000 characters."
],
"action": null
},
"mode": "automatic",
"interactive": false
},
"execution": "Browser interface",
"api": null,
"browser_agent": {
"supported": true,
"name": "run_current_tool",
"discovery": "WebMCP on the human page in a supporting browser",
"verification": "See audit/API-AUDIT.md; availability is not verification"
}
}Page guide
Group JSON records by one or more nested values. Keep every source record and download the grouped result.
How to use JSON array grouper
- Paste a JSON array of records.
- Enter grouping paths as a JSON array and choose how to handle missing fields.
- Review the group and record counts, then download the JSON result and report.
Useful next steps
Group by a field or a combination of fields
Paste a JSON array and choose 1 to 10 JSON Pointer paths, such as ["/country","/address/city"]. Each unique combination becomes a group with its key values, record count and original records. Groups follow first occurrence and records retain their input order.
Keep missing values distinct from null
A missing field gets a separate group by default. Choose Reject record to require all selected paths in every record. Strings, numbers and booleans remain different types. Objects compare by their contents, independent of member order, while array order matters.
Download the full grouped dataset
The output contains keys, count and records for each group, plus a processing report. Paths use ~0 for a literal tilde and ~1 for a slash. An empty pointer selects the whole record. This tool groups records; it does not sum or average their values.