Introduction to OData in Microsoft Dynamics CRM 2011

Odata is a useful way to retrieve data in CRM and works very well when using javascript.

If you are wondering what oData is this article is a good introduction

OData Protocol by example

if you want to know how to connect to the CRM Odata service then this value easily at hand, you just need to know where to find it

Settings–> Customizations –> Developer Resources

When you click on here you will then get to see your discovery service, organisation service and oData Service.

The oData service should look something like this

http://<server name:port>/Metaphorix/XRMServices/2011/OrganizationData.svc

Now you have the oData url you are at the beginning of your quest.  The first thing you should do is download the oData query tool created by MVP Rhett Clinton 

http://bingsoft.wordpress.com/2011/03/06/crm-2011-odata-query-designer-crm2011/

This article explains some of the filters you can add to oData queries

Using OData Retrieve in Microsoft Dynamics CRM 2011

This technet article is fantastic and has a lot of explanation and examples

OData System Query Options Using the REST Endpoint

another blog post, if you are still hungry for more information

CRM 2011 OData, JSON and CRM Forms

The great thing about oData is you can test the query in the internet browser, although when I did it in IE it didn’t show the full result but when I ran it in Chrome, after logging in it returned the XML data returned in the query.

About these ads

2 thoughts on “Introduction to OData in Microsoft Dynamics CRM 2011

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s