GET /api/database/views/grid/{view_id}/aggregation/{field_id}/
Computes the aggregation of all the values for a specified field from the selected grid view. You must select the aggregation type by setting the type GET parameter. If filters are configured for the selected view, the aggregation is calculated only on filtered rows. You need to have read permissions on the view to request an aggregation.
Servers
- /
Path parameters
| Name | Type | Required | Description |
|---|---|---|---|
field_id |
Integer | Yes |
The field id you want to aggregate |
view_id |
Integer | Yes |
Select the view you want the aggregation for. |
Query parameters
| Name | Type | Required | Description |
|---|---|---|---|
include |
String | No |
if |
type |
String | No |
The aggregation type you want. Available aggregation types: count, empty_count, not_empty_count, unique_count, min, max, sum, average, median, decile, variance, std_dev, distribution |
How to start integrating
- Add HTTP Task to your workflow definition.
- Search for the API you want to integrate with and click on the name.
- This loads the API reference documentation and prepares the Http request settings.
- Click Test request to test run your request to the API and see the API's response.