CrmService oCrmService = new CrmService();
oCrmService.Url = "http://<<CRMSERVER>>:5555/MSCrmServices/2007/CrmService.asmx";//**CHANGE THIS TO YOUR CRM SERVER**//
oCrmService.UseDefaultCredentials = true;
CrmAuthenticationToken token = new CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = "<<CRM ORG NAME>>"; //**CHANGE THIS TO YOUR ORG NAME**//
oCrmService.CrmAuthenticationTokenValue = token;
//retrieve query related to current marketing list
string dynamicMarketingList = "LIST_TEST"; //**CHANGE THIS TO YOUR LIST NAME**//
QueryExpression query = new QueryExpression();
query.ColumnSet = new AllColumns();
ConditionExpression listnameCondition = new ConditionExpression();
listnameCondition.AttributeName = "listname";
listnameCondition.Operator = ConditionOperator.Equal;
listnameCondition.Values = new String[] { dynamicMarketingList };
FilterExpression filterList = new FilterExpression();
filterList.Conditions.Add(listnameCondition);
query.EntityName = "list";
query.Criteria = filterList;
// Execute the query
RetrieveMultipleRequest req = new RetrieveMultipleRequest();
req.Query = query;
req.ReturnDynamicEntities = true;
RetrieveMultipleResponse res
= (RetrieveMultipleResponse)oCrmService.Execute(req);
if (res.BusinessEntityCollection.BusinessEntities.Count > 0)
{
DynamicEntity myList = (DynamicEntity)res.BusinessEntityCollection.BusinessEntities[0];
if (myList.Properties.Contains("query"))
{
//Now get fetchXML
string fetchXMLQuery = (string)myList["query"];
//Convert fetchXML to Query Expression
FetchXmlToQueryExpressionRequest conversationRequest = new FetchXmlToQueryExpressionRequest();
conversationRequest.FetchXml = fetchXMLQuery;
FetchXmlToQueryExpressionResponse conversationResponse =
(FetchXmlToQueryExpressionResponse)oCrmService.Execute(conversationRequest);
//run this fetchXML/query express to to get desired result
RetrieveMultipleRequest reqMR = new RetrieveMultipleRequest();
req.Query = conversationResponse.Query;
req.ReturnDynamicEntities = false;
RetrieveMultipleResponse resMS
= (RetrieveMultipleResponse)oCrmService.Execute(req);
//now check the count and cast the entity as per your list type (i.e. account, contact ior lead)
if (resMS.BusinessEntityCollection.BusinessEntities.Count > 0)
{
MessageBox.Show("found " + resMS.BusinessEntityCollection.BusinessEntities.Count.ToString() + " records !!");
}
}
}
above is code for this using CRM 4.0 end points, please study above code and use as per your requirement..
hope this helps..
MayankP
My Blog
Follow Me on Twitter
retrieve dynamic marketing list members
