How to use $count in OData? How to get total count in OData?

 The $count query option in OData is used to request the total count of the items in a collection without returning the items themselves. This can be useful when you only need to know the total count of the items in a collection and don't need to retrieve the items themselves.

To use $count in OData, you need to include it as a query parameter in the URL of the request. Here's an example:

Suppose you have an OData service that exposes a collection of customers, and you want to retrieve the total count of customers in the collection. You can make a GET request to the following URL:

ruby
https://example.com/odata/Customers/$count

This URL includes the $count query option, which means that the response will include only the total count of customers in the collection.

Note that the $count query option can be used in combination with other query options, such as $filter and $orderby, to further refine the query result. For example, if you want to retrieve the total count of customers who live in a specific city, you can make a GET request to the following URL:

bash
https://example.com/odata/Customers?$filter=City eq 'Seattle'&$count=true

This URL includes the $filter query option to filter the customers who live in Seattle, and the $count query option to retrieve the total count of customers who meet the filter criteria.