How to Retrieve Contact Connection and Connection Roles CRM 2013 using C#

(0) Share

Report

Posted on by prasy

Hello All,

I am working on Custom Workflow activity using C# , I need to retrieve Contact Connection data and Contact Connection Roles.

the connection form has some Connected To fields and Role To fields which i need to add to another Entity Dynamically

please help

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

So what's not clear for you? How to retrieve connections for particular contact?

Was this reply helpful? Yes No
prasy 65 on at

Like (0)

Report
Yes, i did tired using the below code but it is not working

var query = new QueryExpression("connection"); query.Criteria.AddCondition(new ConditionExpression("record1id", ConditionOperator.Equal, parentId)); query.ColumnSet = new ColumnSet(true); var results = service.RetrieveMultiple(query);

I get below error

Unhandled Exception: Microsoft.Crm.CrmException: Unexpected exception from plug-in (Execute): xyzCustom.Connectionassign: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at Microsoft.Crm.Sandbox.SandboxCodeUnit.Execute(IExecutionContext context)
at Microsoft.Crm.Workflow.Services.ProxyCustomActivity.Execute(CodeActivityContext executionContext)

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Try to use something like:

var query = new QueryExpression("connection");

query.Criteria.AddCondition(new ConditionExpression("record1id", ConditionOperator.Equal, parentId));

query.ColumnSet = new ColumnSet(true);

var results = service.RetrieveMultiple(query);

In resulting query record2id, record2roleid will contain information about connected records.

Was this reply helpful? Yes No
prasy 65 on at

Like (0)

Report

Thanks Andrii Butenko,

so, from below code how can i get contact name and Contact connection Role

May be i am looking the results in wrong way...to retrieve contact name and contact Role connection

if (results.Entities.Any())

{

foreach (Entity en in results.Entities)

{

if (en.Contains("record2id"))

{

///How to get contact name and contact role

}

}

}

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

So to get name and role you should use something like

var name = en.GetAttributeValue<EntityReference>("record2id").Name;

var role = en.Contains("record2roleid") ? en.GetAttributeValue<EntityReference>("record2roleid").Name : null;

Was this reply helpful? Yes No
prasy 65 on at

Like (0)

Report

Thanks Andrii Butenko. it worked.

Was this reply helpful? Yes No

Community site session details

How to Retrieve Contact Connection and Connection Roles CRM 2013 using C#

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

How to Retrieve Contact Connection and Connection Roles CRM 2013 using C#

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates