Microsoft Dynamics CRM (Archived)

How to retrieve multiple records from an entity in crm using c#

(0) Share

Report

Posted on by Samhitha

I am trying to retrieve records from case entity in crm.

How can I do that?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

prt33k 6,907 on at

Like (1)

Report

Hi Samhita,

You need to write a plugin/custom action/workflow to use C# to extract multiple record.

However in what sceanrio you want to extract record - Are you trying yo update the case or you just want to show the record in some Grid?

Was this reply helpful? Yes No
Samhitha 65 on at

Like (0)

Report

first i need to show in grid, and then i will use that to update the record

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi!

internal static List<Entity> GetAllContacts(IOrganizationService service)
{
var pageNumber = 1;
var pagingCookie = string.Empty;

var result = new List<Entity>();
EntityCollection resp;
do
{
var query = new QueryExpression("contact") { ColumnSet = new ColumnSet("emailaddress1", "lastname") };

#region Add conditions to query

query.Criteria.AddCondition(new ConditionExpression("statecode", ConditionOperator.Equal, 0));

query.Criteria.AddCondition(new ConditionExpression("emailaddress1", ConditionOperator.NotNull));

query.Criteria.FilterOperator = LogicalOperator.And;
#endregion

query.PageInfo = new PagingInfo
{
PageNumber = 1,
Count = 5000
};
if (pageNumber != 1)
{
query.PageInfo.PageNumber = pageNumber;
query.PageInfo.PagingCookie = pagingCookie;
}

resp = service.RetrieveMultiple(query);
if (resp.MoreRecords)
{
pageNumber++;
pagingCookie = resp.PagingCookie;
}

result.AddRange(resp.Entities.ToList());

} while (resp.MoreRecords);

return result.ToList();
}

Hope this helps

Vlad

dynamicalabs.com

Disclaimer: Any post on this page provided "as is" without warranty of any kind and is for educational and information purposes only. We disclaim any liability arising from any reliance placed on any post

Was this reply helpful? Yes No
Samhitha 65 on at

Like (0)

Report

Thanks for your answer, but i am trying to do without organization service i.e by using web api

Was this reply helpful? Yes No
Verified answer

VermaNitin 455 on at

Like (1)

Report

Hi Samhitha,

It seems that you are trying to show records in a custom HTML (grid).

The best approach depends on your CRM version, you can use SOAP/WebApi depending on your CRM version to fetch the records and then modify the response to render in the grid.

Hope it helps!

Many thanks,

Nitin Verma

Was this reply helpful? Yes No
Samhitha 65 on at

Like (1)

Report

thank you

Was this reply helpful? Yes No
Suggested answer

Tanmay G 10 on at

Like (0)

Report

Hi Samhitha,

Using Xrm.WebApi.retrieveMultipleRecords in JScript you can fetch the case entity records in CRM. You can refer to below MSDN link which explains the same with an example.

https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/xrm-webapi/retrievemultiplerecords

Hope this help!

Thanks and Regards,

Tanmay.

Was this reply helpful? Yes No