CRM sample code - Account Entity - retrieve from Account Name.

Below is the sample code which explain retrieving CRM Account details based on the Account name.

I got sample code where you can get Account entity details if you pass guid, but didnot get sample code to retrieve Accoount details by Name.

So tried to give some sample where you can get Accoount details by name.

// Add authentication code here. you can get it from CRM SDK

// Create a column set that holds the names of the columns to be retrieved.



CRMService.CrmSdk.ColumnSet colsContact = new CRMService.CrmSdk.ColumnSet();


colsContact.Attributes = new string[] {"name", "accountid","new_status" };










// Create the ConditionExpression.


CRMService.CrmSdk.ConditionExpression conditionAccount = new CRMService.CrmSdk.ConditionExpression();






// Set the ConditionExpressions Properties so that the condition is true when


// the accountid or the contact is equal to accountId.






// Pass the filter value account id


//conditionContact.AttributeName = "accountid";


//conditionContact.Operator = CRMService.CrmSdk.ConditionOperator.Equal;


//conditionContact.Values = new string[] {"3455D9C5E-B311-DF43-A561-101E0B4CD088"};






// Pass the filter value account name


conditionAccount.AttributeName = "name";


conditionAccount.Operator = CRMService.CrmSdk.ConditionOperator.Equal;


conditionAccount.Values = new string[] { companyName };






// Create the FilterExpression.


CRMService.CrmSdk.FilterExpression filterAccount = new CRMService.CrmSdk.FilterExpression();






// Set the properties of the FilterExpression.


filterAccount.FilterOperator = CRMService.CrmSdk.LogicalOperator.And;


filterAccount.Conditions = new CRMService.CrmSdk.ConditionExpression[] { conditionAccount };






// Create the QueryExpression.


CRMService.CrmSdk.QueryExpression queryAccount = new CRMService.CrmSdk.QueryExpression();






// Set the properties of the QueryExpression.


queryAccount.EntityName = CRMService.CrmSdk.EntityName.account.ToString();


queryAccount.ColumnSet = colsContact;


queryAccount.Criteria = filterAccount;






// Retrieve the contacts.


CRMService.CrmSdk.BusinessEntityCollection myRetrievedAccount = crmService.RetrieveMultiple(queryAccount);


string accountId = string.Empty;

if (myRetrievedAccount != null && myRetrievedAccount.BusinessEntities[0] != null)


{

XPathNavigator navFields = default(XPathNavigator);




CRMService.CrmSdk.account myAccount = (CRMService.CrmSdk.account)myRetrievedAccount.BusinessEntities[0];



// get the values of accoount


accountId = myAccount.accountid.Value.ToString();


myAccount.new_status.name

Error - The remote name could not be resolved - Resolved

I was working on dotnet application, which was trying to connect to CRM application thorugh CRM API.

I was getting error to connect to CRM server when I try to connect through code, but the application was opening in the browser properly.


The Error I was getting is "The remote name could not be resolved". I tried all the methods explained in different websites, but no use.

Finally, It started working after installing "ISA Client". you can download this based on your operating system.