Count and aggregate purchase_orders
Counts, sums, averages, minimums and maximums over the purchase_orders 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/purchase_orders/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 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).
Count and aggregate vendors
Counts, sums, averages, minimums and maximums over the vendors 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).