Sunday, January 23, 2011

Simple CRM FetchXML in C#

Need to use some FetchXML in C# to pull some data? Normally you would have to write your FetchXML, then worry about paging since you may have more than 5,000 records. Luckily, there's an easy way to speed up both of these processes.

Use this tip from Rockstar Bits & Ronald Lemmen to generate your FetchXML automatically from an advanced find:
http://rockstarbits.blogspot.com/2010/02/using-advanced-find-to-generate.html

Next, use this sample from Phil's CRM Blog which gets rid of the paging hassle:
http://blog.expertsoftware.co.uk/post/2009/03/19/Retrieving-All-Records-with-Fetch-XML.aspx

Now that you've got your results, load them into an XmlDocument for parsing and away you go!

No comments:

Post a Comment