Aggregates

Entity›Datastore›Datastore.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)

Field	Type	Description
Name	String	Display name
Code	String	Unique code identifier
LocalizedName	String	Localized display name
IsDefault	Boolean	Whether 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}

Custom Query

Build your own OData query against Datastore_Aggregate. Open Run and edit the whole request inline — swap the entity set, change the $filter, or add $expand, $select, $orderby, $top, $skip. Type $ for suggestions; use ↺ Reset to restore this example.

GET/v1/odata/Datastore_Aggregate?$top=10