in

Paul Rausch

FetchXML Rocks!!

Just kidding. 

For anyone who had the pleasure of coding against the Microsoft CRM 1.0 web services you probably remember that cumbersome FetchXML you had to write to query against the CRM object model.  Well with CRM 3.0 and the strongly typed object model it exposes I thought I was in the clear from writing anymore of that crazy stuff until the other day.  I basically needed to create a join and retrieve fields from two related CRM objects, after some research trying to use the typed object model I fame to realize Mr. FetchXML was back in town.  After an hour or so of searching trying to find the correct syntax to pass into the Fetch() method on the web service I came across this tool and 10 minutes later I was back in business.  Give it a look, its pretty sweet, you just point it to your CRM server and it will pull in all the meta data then its just a matter of selecting the entities and fields you want. 

http://www.jamesdowney.net/fetchxml.aspx

Only published comments... Jan 14 2008, 03:19 PM by prausch
Filed under: ,

Leave a Comment

(required)  
(optional)
(required)  
Add
Inetium, LLC. Disclaimer