{"id":"json-array-group-count","version":"1.0.0","description":"Group an array of JSON objects by exact keys and return the count.","supported_operations":["json array group count","count json array by keys","frequency map json array"],"unsupported_operations":["group by expression","other aggregations"],"semantics":["Groups objects into an array of records. Each record has the join keys and a \"count\" key representing the number of matches.","Output array is ordered by the first appearance of each key tuple.","Missing or null keys are grouped together and treated as the string 'undefined' or 'null'."],"limits":{"max_array_items":10000,"max_output_items":10000,"max_keys":32},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["array","keys"],"properties":{"array":{"type":"array","maxItems":10000,"items":{"type":"object"}},"keys":{"type":"array","minItems":1,"maxItems":32,"uniqueItems":true,"items":{"type":"string","minLength":1}},"count_name":{"type":"string","minLength":1,"maxLength":64,"default":"count"}}},"output_schema":{"type":"object","additionalProperties":false,"required":["result","groups_count"],"properties":{"result":{"type":"array","items":{"type":"object"}},"groups_count":{"type":"integer"}}},"examples":[{"input":{"array":[{"id":1,"v":"A"},{"id":2,"v":"B"},{"id":1,"v":"C"}],"keys":["id"]},"output":{"result":[{"id":1,"count":2},{"id":2,"count":1}],"groups_count":2}}],"execute_url":"/v1/tools/json-array-group-count/versions/1.0.0/execute"}