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).
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/vendors/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 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).
Create, change or delete many approval_thresholds at once
Up to 500 approval_thresholds in one request and one transaction: every row is checked exactly as its single-row write is (the same permission, validation and limits), and one refused row refuses the batch, names the row by its position (`details.index`), and writes nothing. Send exactly one of `create`, `update` or `delete`. Rows are named by uid; there is no write by condition. An `Idempotency-Key` makes the batch safe to send again.