fredag 7 september 2012

More ODATA thoughts

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