Skip to main content

Aggregates

EntityDatastoreDatastore.Aggregate

Aggregates define aggregation methods used in reporting and calculations.

Use the Datastore_Aggregate endpoint to query aggregates.

Endpoints

List Aggregates

GET/v1/odata/Datastore_Aggregate

Single Aggregate

GET/v1/odata/Datastore_Aggregate({id})

Fields

Datastore Fields (inherited)

FieldTypeDescription
NameStringDisplay name
CodeStringUnique code identifier
LocalizedNameStringLocalized display name
IsDefaultBooleanWhether this is the default value

Filtering Examples

GET/v1/odata/Datastore_Aggregate?$filter=Name eq '{Name}'&$top={top}
GET/v1/odata/Datastore_Aggregate?$filter=contains(Name, '{Name}')&$top={top}
GET/v1/odata/Datastore_Aggregate?$filter=Code eq '{Code}'&$top={top}
GET/v1/odata/Datastore_Aggregate?$filter=IsDefault eq {IsDefault}&$top={top}