ODATA Cheat Sheet for Dynamics 365 and Common Data Service (CDS)

Download your ODATA Cheat Sheet here. Dynamics 365 and Common Data Service Web APIs both use ODATA to query and return data. ODATA is a simple REST-based API that allows the return of JSON objects matching the query parameters, but despite the documentation provided, there exists no concise quick reference for building your ODATA queries.

If you work with Microsoft products on the web, sooner or later you will have to interface with ODATA. Whether it’s through the advanced settings on a Power Automate flow or inside your own application, ODATA is used in all of Microsoft’s most important applications.

This means Sharepoint, Outlook.com, Dynamics 365, Common Data Service, Salesforce, MySQL, PostgresSQL, Excel Online and anything that uses an On-Premises Data Gateway. If you are interfacing with data in a Microsoft product, you’re going to need to know ODATA.

We’ve built a cheat sheet / quick reference guide for ODATA $filter so that you can quickly and easily know exactly what is available to build out your query quite quickly. Enter your email address at the end of this post to subscribe to our newsletter and get the ODATA cheat sheet delivered to your inbox.

Here’s what’s included:

A list of every query parameter available. $filter, $select, $top, $apply, $expand

All of the simple filter operators which are most supported across different implementations. (With examples!)

CDS and D365 specific filter functions that are available only on these APIs. (Including a link to those not covered (mostly redundant))

You’ll learn:

• What ODATA parameters are available.
• What the simple filters are with examples of how to use them
• The simple functions that are supported across multiple APIs
• CDS and Dynamics 365 specific functions available only with the Dynamics 365 and Common Data Service APIs