With no direct access to the Dynamics 365 for Finance and Operations (D365FO) database you are relying on OData to execute your queries. A common scenario is the need to count the number of records in a table. The following URL template offers a quick way to do this:
If, for instance, I would like to count the number of customers in my D365FO instance, the URL would look like this:
A quick an easy way to count records in a table.
The $count function can obviously be combined with the $filter function if you only need to count a subset of records. By adding the following statement to the URL, the request returns the number of customers in group ’10’:
/?$filter=CustomerGroupId eq ’10’