topic Re: Arcade - 'System.InvalidCastException' in Attribute Rules Questions

Arcade - 'System.InvalidCastException'

girafee — Tue, 23 Aug 2022 10:41:36 GMT

Hello! I have an expression "var d = Dictionary('Accounting', $feature.AssessmentID)\r\nreturn 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.

Re: Arcade - 'System.InvalidCastException'

JohannesLindner — Tue, 23 Aug 2022 11:25:22 GMT

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?

Re: Arcade - 'System.InvalidCastException'

girafee — Wed, 24 Aug 2022 16:46:59 GMT

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

Re: Arcade - 'System.InvalidCastException'

JohannesLindner — Thu, 25 Aug 2022 06:34:55 GMT

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.

Re: Arcade - 'System.InvalidCastException'

girafee — Fri, 26 Aug 2022 08:33:02 GMT

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); } }

Re: Arcade - 'System.InvalidCastException'

JohannesLindner — Mon, 29 Aug 2022 08:09:57 GMT

The Arcade expression returns a Dictionary, but it seems like JS can't convert that.

Sadly, I have no idea about the JS API. You can probably get some help in the ArcGIS API for JavaScript - Esri Community

Re: Arcade - 'System.InvalidCastException'

girafee — Mon, 05 Sep 2022 15:04:33 GMT

I want to have a null check in my expression and if it is null, return null as a string: "var d = Dictionary('Accounting', $feature.AssessmentID)\r\nreturn d". For example: "if($feature.AssessmentID == null) $feature.AssesmentID = 'null'".

Thanks.

Re: Arcade - 'System.InvalidCastException'

JohannesLindner — Mon, 05 Sep 2022 15:16:47 GMT

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"?

Re: Arcade - 'System.InvalidCastException'

girafee — Tue, 27 Sep 2022 16:47:53 GMT

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); } }

Re: Arcade - 'System.InvalidCastException'

JohannesLindner — Tue, 27 Sep 2022 18:29:46 GMT

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?