Customer experience | Sales, Customer Insights,...

Answered

How to check for Null condition while retrieving data using plugin

(0) Share

Report

Posted on by HimaM

135

Hello All,

I want to check null condition before i retrieve the value

Entity simEntity = service.Retrieve("sim", simid,new Microsoft.Xrm.Sdk.Query.ColumnSet("ordernumber", "number", "cps"));

String number = simEntity.Attributes["number"].ToString();

when the value is null in sim entity i get plugin error as System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

I tried using the below format but no luck:

Entity simEntity = service.Retrieve("sim", simid,new Microsoft.Xrm.Sdk.Query.ColumnSet("number"));

if (simEntity .Attributes.Contains("number") && entity["number"] != null){

String number = simEntity.Attributes["number"].ToString();

}

Please suggest.

Regards,

Hima

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello Hima,

Everything depends on how you plan to use the value from the field.

Here is one way you can do it:

if (simEntity.Contains("number") && simEntity["number"] != null)

{

var number = simEntity["number"].ToString();

}

alternative way is following but you have to define what type you expect:

var number = simEntity.GetAttributeValue<string>("number");

if simEntity will not contain "number" field this GetAttributeValue will return null.

Was this reply helpful? Yes No
HimaM 135 on at

Like (0)

Report

Hello Andrew,

Thanks you so much for the reply.

When I'm retrieving fields from the other entity using

Entity simEntity = service.Retrieve("sim", simid,new Microsoft.Xrm.Sdk.Query.ColumnSet("number"));

if the number field is null its doesn't return the null value and proceed instead we get an error message as given key not found. How do i fetch the field value even if its null? any idea?

Regards,

Hima

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hima,

That's a platform feature. If the field has null value it is not returned so you should use one of approaches I recommended in my reply.

Good luck.

Was this reply helpful? Yes No
HimaM 135 on at

Like (0)

Report

Thank you! it’s working now.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to check for Null condition while retrieving data using plugin

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How to check for Null condition while retrieving data using plugin

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 > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates