Summarize records
summarize_recordsCount, sum, average, min or max over one resource's records in one call, of any source, optionally per group. Takes the same query and filters as search_records. column is a number column from describe_resources (min and max also take a date). measures asks several figures at once, e.g. ["count", "sum", "avg"] over column, or "sum:" for another column; the answer is then values, keyed as asked. group_by is a column, week:/month:/quarter:/year:, or a list of two, e.g. ["", "month:"]. A week is named by its Monday. Groups come largest first, or in date order when a date is bucketed, at most 100.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Groups to answer. Default and most 100. | |
| query | No | ||
| column | No | What to sum, average, min or max: a column describe_resources lists. | |
| filters | No | Column filters, from the columns describe_resources lists for the resource: {"<column>": "value"}, {"<column>": ["one", "another"]}, {"<column>": {"contains": "acme"}}, {"<date column>": {"gte": "2026-04-01", "lte": "2026-06-30"}}. Operators: eq, ne, in, not_in, gte, lte, contains, null. | |
| measure | No | Default count. | |
| group_by | No | e.g. <column>, month:<date column>, or ["<column>", "quarter:<date column>"]. | |
| measures | No | Several figures in one call, in place of measure. | |
| resource | Yes | A resource key from describe_resources, e.g. invoices. | |
| connection_id | No | Omit when only one of the company's sources holds the resource; list_connections names them. | |
| modified_since | No | ISO 8601 time; only records the source changed since then. |