ColumnSet Problem with CRM Null Value Custom Fields

(0) Share

Report

Posted on by Ashraf Abu-Abdou

110

Hello,

I have one particular custom field I created on CRM that I could not retrieve by ColumnSet. I read that a column could not be retrieved if it had null values. Is there a workaround to retrieve all the custom values on CRM including those fields that have null values?

Here is the portion of the code where I tried in order to retrieve the custom field "new_PrimaryContacthasEmail". I am using early bound:

// Retrieve record of primary contact
Guid primaryContactId = retrievedAccount.PrimaryContactId.Id;
ColumnSet contactCols = new ColumnSet(true);
Contact retrievedContact = (Contact)service.Retrieve("contact", primaryContactId, contactCols);
try
{

if (retrievedContact.EMailAddress1.CompareTo(string.Empty) == 0)
{
retrievedIncident.new_PrimaryContacthasEmail = false;
}
else
{
retrievedIncident.new_PrimaryContacthasEmail = true;
}

service.Update(retrievedIncident);
}
catch (Exception e)
{
Console.WriteLine("An error occurred: '{0}'", e);
}

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (2)

Suggested answer

Bhaargavi Bodapati 115 on at

Like (0)

Report

Hi Ashraf,

You could try entering name of the field as a string instead of using the early binding.

Contact retrievedContact = (Contact)service.Retrieve("contact", primaryContactId, new ColumnSet(<fieldName>));

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

There is no way to get CRM to retrieve columns if they have a null value; this is just the way CRM works. You can query the CRM metadata if you need to identify all columns, but the early-bound process does this for you anyway

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Please try as follows:

Guid primaryContactId = retrievedAccount.PrimaryContactId.Id; ColumnSet contactCols = new ColumnSet(true); Entity retrievedContact = service.Retrieve("contact", primaryContactId, contactCols); try { if (!retrievedContact.Attributes.Contains("emailaddress1")) { retrievedIncident.new_PrimaryContacthasEmail = false; } else { retrievedIncident.new_PrimaryContacthasEmail = true; } service.Update(retrievedIncident); } catch (Exception e) { Console.WriteLine("An error occurred: '{0}'", e); }

Please let us know.

If you found the answer helpful, please mark as Verified

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Ashraf Abu-Abdou 110 on at

Like (0)

Report

Hi Bhaargavi,

The problem remains. The field could not be retrieved. I could retrieve other custom fields but not this one: "new_PrimaryContacthasEmail"

Was this reply helpful? Yes No
Ashraf Abu-Abdou 110 on at

Like (0)

Report

Hi Francesco,

I still get the error with "new_PrimaryContacthasEmail" despite it is created and published on CRM

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ashraf,

you need to update reference to crm service each time you add/remove an entity/attribute, please refer to following page:

https://msdn.microsoft.com/en-us/library/gg327844.aspx

Hope it helps.

Please let us know.

If you found the answer helpful, please mark as Verified

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Ashraf Abu-Abdou 110 on at

Like (0)

Report

I run the code generation tool after I add or remove any entity/attribute on CRM. Still the problem remains

Was this reply helpful? Yes No
Ashraf Abu-Abdou 110 on at

Like (0)

Report

David,

So querying CRM metadata has the same outcome as the early bound process when it comes to trying to retrieve null value custom fields?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Please note new_PrimaryContacthasEmail is set, not retrieved, could i miss something?

Let me know.

Was this reply helpful? Yes No
Ashraf Abu-Abdou 110 on at

Like (0)

Report

Francesco,

Kindly refer to the image above. The field could not be found

Was this reply helpful? Yes No