Limitations of OData EndPoint in CRM 2011

1) The $format and $inlinecount operators are not supported. $filter, $select, $top, $skip, $orderby are supported.

2) Maximum 6 expansions are allowed using $expand operator. Querying a multi-level relationship property is not supported i.e. One level of navigation property selection is allowed.

3) Page size is fixed to max 50 records however it can be changed by doing changes in advanced configuration settings but it is not recommended.

4) When using with distinct queries, we are limited to the total (skip + top) record size = 5000. In CRM the distinct queries does not use paging cookie and so we are limited by the CRM platform limitation to the 5000 record.

5) Conditions on only one group of attributes are allowed. A group of attribute refers to a set of conditions joined by And/Or clause.

6) Arithmetic, datetime and math operators are not supported.

7) Order by clause is only allowed on the root entity.

8) Only Create, Retrieve, Update and Delete actions can be performed on entity records.

Messages that require the Execute method cannot be performed.

Associate and Disassociate actions are performed as updates.

9) Authentication is only possible within the application; Use of the REST endpoint is effectively limited to JScript libraries or Silverlight Web Resources.

10) The OData protocol is not fully implemented in CRM 2011. Some system query options are not available.