JSON Data Processing: Parse, Filter, Aggregate

Question

## Problem

Given nested JSON records, parse them, filter by conditions, and aggregate results (sum/group-by).

## Example
```
records -> total amount per category where status='active'
```

## Constraints
- Handle missing/malformed fields

## Approach
Defensive parsing; group-by with a map. Reported HubSpot OA pattern.