{"id":"json-array-group-by","version":"1.0.0","description":"Group an array of JSON objects by exact keys.","supported_operations":["json array group by","group json array by keys","bucket json objects"],"unsupported_operations":["group by expression","aggregation functions"],"semantics":["Groups objects into an array of group records. Each group record has the join keys and a \"group\" key containing the matching objects.","Matches objects based on strict equality of the specified keys.","Output array is ordered by the first appearance of each key tuple.","The grouped items within each group retain their original relative order.","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}},"group_name":{"type":"string","minLength":1,"maxLength":64,"default":"group"}}},"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,"group":[{"id":1,"v":"A"},{"id":1,"v":"C"}]},{"id":2,"group":[{"id":2,"v":"B"}]}],"groups_count":2}}],"execute_url":"/v1/tools/json-array-group-by/versions/1.0.0/execute"}