Count and aggregate invoices
Counts, sums, averages, minimums and maximums over the invoices you may list, grouped, computed in the database. Takes the same permission as listing them, and sees the same rows (your organization's, never a soft-deleted one).
Authorization
bearerAuth Authorization for API
In: header
Path Parameters
Your app's unique id. Find it in the console under the app's Settings, or in the URL of any app page.
uuidQuery Parameters
A JSON spec, URL-encoded. measures: up to 12 of { op: count|count_distinct|sum|avg|min|max, column, as } (column is optional for count). groupBy: up to 8 of { column, truncate: year|quarter|month|week|day|hour } or { column, bucket: <size> }. filters: the list's where language. having: { <as>: { $gt: n } }. sort: "<as> DESC". limit: at most 1,000 groups. A reference groups by its <name>_uid; redacted columns cannot be grouped, measured or filtered.
Response Body
application/json
application/json
application/json
application/json
curl -X GET "https://example.com/497f6eca-6276-4993-bfeb-53cbbbba6f08/autocrud/invoices/aggregate?spec=%7B%22groupBy%22%3A%5B%7B%22column%22%3A%22status%22%7D%5D%2C%22measures%22%3A%5B%7B%22op%22%3A%22count%22%2C%22as%22%3A%22n%22%7D%5D%7D"{ "rows": [ {} ], "meta": { "groups": 0, "matchedGroups": 0, "hasMore": true, "truncated": true, "limit": 0 }}Count and aggregate approval_thresholds
Counts, sums, averages, minimums and maximums over the approval_thresholds you may list, grouped, computed in the database. Takes the same permission as listing them, and sees the same rows (your organization's, never a soft-deleted one).
Count and aggregate payments
Counts, sums, averages, minimums and maximums over the payments you may list, grouped, computed in the database. Takes the same permission as listing them, and sees the same rows (your organization's, never a soft-deleted one).