Hello! I have an expression "var d = Dictionary('Accounting', $feature.AssessmentID)return d" and if the value is null, I get an exception: Values = '((Esri.ArcGISRuntime.RuntimeDictionary )result.Result).Values' threw an exception of type 'System.InvalidCastException' I researched that I could write like this "$feature.AssessmentID +'' " and no exception. Any other options? Thanks.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade - 'System.InvalidCastException'

girafee

Hello! I have an expression "var d = Dictionary('Accounting', $feature.AssessmentID)return d" and if the value is null, I get an exception:
Values = '((Esri.ArcGISRuntime.RuntimeDictionary<string, object>)result.Result).Values' threw an exception of type 'System.InvalidCastException'

I researched that I could write like this "$feature.AssessmentID +'' " and no exception. Any other options?

Thanks.

Vind meer berichten getagd met

Accepted answers

All comments

JohannesLindner

I have the same problem

In fact, it's exactly the same problem, this is your thread...

Sadly, I'm as unqualified as before. I don't know anything about JS. I guess you couldn't find help in the JS Community?

I am qualified to look at your Arcade expression (it's different from the one you posted earlier), and I'm not sure what you're trying to achieve.

var d = Dictionary() 
if($feature.AuthorizationNotice == null) {
    d['QuantityActual'] = $feature.Status
    d['Assessor'] = $feature.DueDate
    return d
}

Here's what your expression does:

if AuthorizationNotice is null, return a dictionary
if AuthorizationNotice is not null, return null

Is this the intended behavior?

girafee

Hi! Could you please help me? I have the same problem and I don't know how to solve it. I need to return dictionary from Arcade Expression, and work with it. But if at least one value is null, I get an exception and can't work with other values.

public override async Task ExecuteAsync(Feature feature)
{
Esri.ArcGISRuntime.ArcadeExpression ArcadeEvaluatorExpression = new Esri.ArcGISRuntime.ArcadeExpression("var d = Dictionary() \r\n if($feature.AuthorizationNotice == null) \r\n { d['QuantityActual'] = $feature.Status \r\n d['Assessor'] = $feature.DueDate \r\n return d}"); // $feature.DueDate = null

ArcadeEvaluator ArcadeEvaluator = new ArcadeEvaluator(ArcadeEvaluatorExpression, ArcadeProfile.FormCalculation);

List<KeyValuePair<string, object>> profileVariables = new List<KeyValuePair<string, object>>();

profileVariables.Add(new KeyValuePair<string, object>("$feature", feature));

ArcadeEvaluationResult result = await ArcadeEvaluator.EvaluateAsync(profileVariables); // here we have System.InvalidCastException

Dictionary<string, object> retValues = JObject.FromObject(result.Result).ToObject<Dictionary<string, object>>();

if (retValues != null)
{
   foreach (KeyValuePair<string, object> pair in retValues)
   feature.SetAttributeValue(pair.Key, pair.Value);
}

}

JohannesLindner

Like this?

if($feature.AssessmentID == null) {
    return "null"
}
return {"Accounting": $feature.AssessmentID}

Or do you want to set the value in the table to "null"?

girafee

public override async Task ExecuteAsync(Feature feature)
{

Esri.ArcGISRuntime.ArcadeExpression ArcadeEvaluatorExpression = new Esri.ArcGISRuntime.ArcadeExpression("var d = Dictionary('Accounting1', $feature.AssessmentID)\r\nreturn d"); // AssessmentID = null

ArcadeEvaluator ArcadeEvaluator = new ArcadeEvaluator(ArcadeEvaluatorExpression, ArcadeProfile.FormCalculation);

List<KeyValuePair<string, object>> profileVariables = new List<KeyValuePair<string, object>>();

profileVariables.Add(new KeyValuePair<string, object>("$feature", feature));

ArcadeEvaluationResult result = await ArcadeEvaluator.EvaluateAsync(profileVariables);

Dictionary<string, object> retValues = JObject.FromObject(result.Result).ToObject<Dictionary<string, object>>();

if (retValues != null)
{
   foreach (KeyValuePair<string, object> pair in retValues)
   feature.SetAttributeValue(pair.Key, pair.Value);
}

}

JohannesLindner

You could return a json string representation of the dictionary:

var d = Dictionary('Accounting', $feature.AssessmentID)
return Text(d)

But the problem isn't with the expression. You want to use the output dictionary somewhere and that is what's causing the error.

Can you tell us what you're trying to do? If we know what you're working with and what you want to accomplish, it's much easier to help.

girafee

@JohannesLindnerI'm sure. I need to return the dictionary and work with it.
What options do we have?

JohannesLindner

Hey!

This expression returns a dictionary. Are you sure you need a dictionary and not a string or something else?

What do you want to do with this expression? Is it for an Attribute Rule?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.