When reading about Dynamics CRM 2011 and ODATA queries you quickly get the idea that it's made for Silverlight and JScripts working from the inside, however I found one very useful application of the ODATA queries.
I was browsing through the trace file of an installation to figure out what wasn't working properly and there are a lot of references to user ids that I wanted to know who they belonged to. This is where the ODATA query came in very handy. I simply, well if you read my previous post simply is perhaps a bit of an exaggeration, put together a query using the ODATA endpoint from the CRM. To query a user by id the query looks something like this: http://<server>:<port>/<org>/XRMServices/2011/OrganizationData.svc/SystemUserSet?$filter=SystemUserId eq (guid'<SystemUserId>')
In real life, it could look something like this: http://crmserver:5555/MyOrg/XRMServices/2011/OrganizationData.svc/SystemUserSet?$filter=SystemUserId eq (guid'1A3B1082-F208-E011-A188-00155D0A8303')
Hope this helps someone!
Rickard Norström
Developer at CRM-Konsulterna
www.crmkonsulterna.se
