How to fetch the
marketing lists associated with a campaign or campaign activity in
Dynamic 365 CRM?
Within Dynamics 365 CRM,
there are a number of entities that have N:N relationships. One of these is the
CampaignItem entity that connects Campaigns, Marketing Lists, Products and
Sales Literature.
I have created a generic
method below in C# with detail explanations.
Here is how I am invoking
my method
EntityCollection DynamicMarketingLists =
GetManytoManyRelationShip(CampaignActivityId,
"list",
"listid",
"campaignactivitylist_association",
"campaignactivity",
"subject",
_service);
Here is method definition
private
EntityCollection GetManytoManyRelationShip(
Guid
entityBGuid,
string
offenceEntityName,
string
offenceColumnSet,
string
relationShipName,
string
legalEntityName,
string
legalColumnSet,
IOrganizationService
_service)
{
QueryExpression
query = new QueryExpression(offenceEntityName);
ColumnSet
cols = new ColumnSet();
cols.AddColumn(offenceColumnSet);
cols.AddColumn("listname");
query.ColumnSet = cols;
Relationship
relationship = new Relationship(relationShipName);
RelationshipQueryCollection
relationshipColl = new RelationshipQueryCollection();
relationshipColl.Add(relationship,
query);
RetrieveRequest
request = new RetrieveRequest();
request.RelatedEntitiesQuery
= relationshipColl;
request.Target = new
EntityReference(legalEntityName, entityBGuid);
request.ColumnSet = new
ColumnSet(legalColumnSet);
RetrieveResponse
response = (RetrieveResponse)_service.Execute(request);
return
response.Entity.RelatedEntities[relationship];
}
Thanks.
Vipin Jaiswal
Vipinjaiswal12@gmail.com
