Sign in

Microsoft.com

Microsoft

Remove From My Forums

Getting all records out of CRM

Question
0

Sign in to vote

CRM Experts,

I would like to retrieve all records out of the products table. I know that CRM retrieves a maximum of 50 records at a time and i know there is sample code in the SDK that shows how to get more records but they are passing a value each time. I'm using Silverlight C#.

Here is my question:

1. How do you determine the number of records that are in the table using the OData service? Is it even possible? If not what is the best way to find the total number of records in my product table? Is the "All()" method supported at all?
Help please.

Friday, August 12, 2011 2:21 PM

Answers

0

Sign in to vote
Hi,

You can only get the record via SOAP FetchXML (http://inogic.blogspot.com/2011/05/how-to-get-total-results-returned.html) and you can bypass OData record retrieve limit as discussed on the following links:

http://msdn.microsoft.com/en-us/library/gg985388.aspx

http://social.microsoft.com/Forums/eu/crmdevelopment/thread/9c54f06e-d967-4fec-a1ad-006cac5f9141

Jehanzeb Javeed

http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile

If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
- Proposed as answer by Jehanzeb.Javeed Friday, August 12, 2011 7:44 PM
- Marked as answer by FutureSteel Monday, August 15, 2011 2:52 PM
Friday, August 12, 2011 7:44 PM