Count: returns an integer value that equals the total count of records found in the collection. This command requires no parameters and takes precedence over all other commands.
OrderBy: returns the collection in an order based on the input parameters. The input is a string with comma delimiters and uses a similar string parsing method as select. The order by parameter also supports ascending (asc) and descending (desc) options as part of each column parameter.
EX: http://localhost/test?$orderby=name asc, age desc
OData queries can be combined as follow:
EX: http://localhost/test?$filter=((num1 gt 0) and (name ne ‘abc’) and (required eq true) and (count lt 0.1) or (id eq ‘123’) and contains(time, ‘0’) and startswith(code, ‘456’) or “endswith(code, ‘789’))&top=10…