Pitfalls
No Aggregates
Understand the current limitations around data aggregation natively in the Monospace API.
At present, Monospace does not support aggregate functions (e.g., COUNT, SUM, AVG, MIN, MAX) in the data query API.
The Pitfall
Aggregate and group-by parameters are accepted by the API query parser but are silently ignored. You cannot natively group or summarize data via the REST API yet.
Mitigation
For now, you will need to fetch the raw data and perform aggregations on the client side, or create a custom endpoint/hook if needed. Aggregation support is on the roadmap and will be released soon!
One exception: the number of items matching a query is available via the meta=totalCount parameter on list reads — see Get the Total Count.