group
AggregateGroups an array of objects into a single object keyed by a field value. Each key maps to an array of the records that share that value. Equivalent to GROUP BY in SQL.
Syntax
group:fieldfieldField name to group byUse cases
| Use case | Description | URL | |
|---|---|---|---|
| Repos by language | Bucket a user's repos by programming language. | https://httpip.es/api/pipe/fetch:https://api.github.com/users/octocat/repos|group:language | |
| Todos by completion status | Split todos into two buckets: done and not done. | https://httpip.es/api/pipe/fetch:https://jsonplaceholder.typicode.com/todos|group:completed | |
| Posts grouped by author | Organise all posts into per-author arrays for easy lookup. | https://httpip.es/api/pipe/fetch:https://jsonplaceholder.typicode.com/posts|group:userId | |
| Count groups after grouping | Group then count the resulting keys to see how many distinct groups exist. | https://httpip.es/api/pipe/fetch:https://api.github.com/users/octocat/repos|group:language|keys|count |