Parameter

Type

Description

$top

Integer

Returns the first n records in a collection or if the collection has a filter, the first n records matching the filter.

$count

Boolean

Returns the number of records in a collection or if the collection has a filter, the number of records matching the filter. This value is returned in the @odata.count attribute of the response.

When used in conjunction with $top=0, it does not fetch the records associated with the query and only returns @odata.count.

$skip

Integer

Ignores the first n records in a collection or if the collection has a filter, the first n records matching the filter.

$select

String

Comma-separated list of properties that specifies a subset of properties to include in the response.

$expand

String

Comma-separated list of navigation properties to include in the response.
Navigation properties are not expanded by default, so they are not included in the response unless explicitly requested.

$filter

String

Specifies an expression that is evaluated for each resource in the collection, and only items where the expression evaluates to true are included in the response.

$orderby

String

Comma-separated list of properties and orders (asc/desc), that define the order in which resources are returned.
Each property-order pair is applied in the order in which they are supplied.

$apply

String

Allows to specify a sequence of transformations to the entity set, such as groupby, filter and aggregate.