topic Re: Arcade Error: Test execution error: Execution error - Cannot access property of null object. Verify test data. in ArcGIS Online Questions

Arcade Error: Test execution error: Execution error - Cannot access property of null object. Verify test data.

ZachBodenner — Wed, 01 Nov 2023 19:08:02 GMT

Hello,

I have a fairly long Arcade expression that is designed to use in the Arcade popup element (for HTML access). In a web service/web map, I have a parcel layer and three tables (Residential, Multi Family, and Commercial). The parcel layer is related to all three tables through the field "PID". In theory, there should be no overlap - if a parcel has a related record in Residential, it should not have one in Commercial. I think there might actually be some overlap, but I think the expression should account for that. What I want to have happen is to return a table constructed of HTML if a filter match is found.

I feel like this should be working but I get "Test execution error: Execution error - Cannot access property of null object. Verify test data." when trying to run the expression. I think the issue is related to the filter Interestingly, if I reconstruct the bare bones of this in a regular Arcade expression, the filter seems to work fine and I can get individual attributes from the related table. An example of something that works in the Arcade Attribute Expression:

var table = FeatureSetByName($map, "Residential",['Assessment_Year','Style']) var thisPID = $feature.PID; var PIDfilter = First(Filter(table, "PID = @thisPID")); var test = PIDfilter['Assessment_Year'] return test

So I'm not 100% sure why the error is occurring.

Re: Arcade Error: Test execution error: Execution error - Cannot access property of null object. Verify test data.

dgiersz_cuyahoga — Thu, 02 Nov 2023 20:39:36 GMT

I think it is because, like you said, any given PID is only in one table. Which means when you check all 3, then 2 of them will return null (lines 13-15). Then you try to set variables using a property of those nulls.

Re: Arcade Error: Test execution error: Execution error - Cannot access property of null object. Verify test data.

ZachBodenner — Fri, 03 Nov 2023 12:40:15 GMT

That sounds like it could be correct, but that's what I'm trying t check against with the if statements at the end. Did I just structure them poorly?

Re: Arcade Error: Test execution error: Execution error - Cannot access property of null object. Verify test data.

dgiersz_cuyahoga — Fri, 03 Nov 2023 13:47:48 GMT

Yeah, I would check them right after setting the variable.

This would also allow you to just use one set of variables, not a unique set for each PID type, and one set of table HTML with those new variables.

Re: Arcade Error: Test execution error: Execution error - Cannot access property of null object. Verify test data.

ZachBodenner — Fri, 03 Nov 2023 18:07:44 GMT

Thanks for the help! If you're curious about my final expression that I got to work, here it is:

// get tables var resProperties = FeatureSetByName($map, "Residential",['PID','Actual_Age','Total_Baths','Total_Bedrm','GB_Area','Style','Assessment_Year']); var multiFamilyProperties = FeatureSetByName($map, "Multi-Family",['PID','Actual_Age','Building_Name','Total_Floor_Area','Assessment_Year','Nbr_Story']); var commericalProperties = FeatureSetByName($map, "Commerical",['PID','Actual_Age','Building_Name','Total_Floor_Area','Assessment_Year','Nbr_Story']); // Identify PID and create final HTML variable var parcelPID = $feature.PID; var decideHTML // Filter statements var PIDres = First(Filter(resProperties, "PID = @parcelPID")); var PIDmf = First(Filter(multiFamilyProperties, "PID = @parcelPID")); var PIDcomm = First(Filter(commericalProperties, "PID = @parcelPID")); // Check if there's a matching PID in the Residential table if (IsEmpty(PIDres)==false){ //if yes, establish variables var resAge = PIDres['Actual_Age']; var resBaths = PIDres['Total_Baths']; var resBedrm = PIDres['Total_Bedrm']; var resGBArea = Text(PIDres['GB_Area'],'#,###'+" Sq.Ft."); var resStyle = PIDres['Style']; var resAssessYr = PIDres['Assessment_Year']; // if yes, final HTML var resHTML = `<div style="background-color:#3f540f;padding:5px;"> Building Information </div> <figure style="width:100%;"> <figure> <figure class="table"> <table> <tbody> <tr> <td> Building Type </td> <td style="padding-right:175px;"> Single Family Residential </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Building Style </td> <td style="background-color:#e1e1e1;"> ${resStyle} </td> </tr> <tr> <td> Year Built </td> <td> ${resAge} </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Total Building Area </td> <td style="background-color:#e1e1e1;"> ${resGBArea} </td> </tr> <tr> <td> Total Bedrooms </td> <td> ${resBedrm} </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Total Bathrooms </td> <td style="background-color:#e1e1e1;"> ${resBaths} </td> </tr> <tr> <td> Assessment Year </td> <td> ${resAssessYr} </td> </tr> </tbody> </table> </figure> </figure> </figure> ` // make decideHTML equal to final Res HTML decideHTML = resHTML } // Check if there's a matching PID in the Multifamily table else if (IsEmpty(PIDmf)==false){ //if yes, establish variables var mfAge = PIDmf['Actual_Age']; var mfBldg = PIDmf['Building_Name']; var mfTotalFloor = Text(PIDmf['Total_Floor_Area'],'#,###'+" Sq.Ft."); var mfAssessYr = PIDmf['Assessment_Year']; var mfNbrStory = PIDmf['Nbr_Story']; // if yes, final HTML var mfHTML = `<div style="background-color:#3f540f;padding:5px;"> Building Information </div> <figure style="width:100%;"> <figure> <figure class="table"> <table> <tbody> <tr> <td> Building Type </td> <td style="padding-right:175px;"> Multi-Family Residential </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Building Name </td> <td style="background-color:#e1e1e1;"> ${mfBldg} </td> </tr> <tr> <td> Year Built </td> <td> ${mfAge} </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Total Floor Area </td> <td style="background-color:#e1e1e1;"> ${mfTotalFloor} </td> </tr> <tr> <td> Number of Stories </td> <td> ${mfNbrStory} </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Assessment Year </td> <td style="background-color:#e1e1e1;"> ${mfAssessYr} </td> </tr> </tbody> </table> </figure> </figure> </figure> ` // make decideHTML equal to final Res HTML decideHTML = mfHTML } // Check if there's a matching PID in the Commercial table else if (IsEmpty(PIDcomm)==false){ //if yes, establish variables var commAge = PIDcomm['Actual_Age']; var commBldg = PIDcomm['Building_Name']; var commTotalFloor = Text(PIDcomm['Total_Floor_Area'],'#,###'+" Sq.Ft."); var commAssessYr = PIDcomm['Assessment_Year']; var commNbrStory = PIDcomm['Nbr_Story']; //if yes, final HTML var commHTML = `<div style="background-color:#3f540f;padding:5px;"> Building Information </div> <figure style="width:100%;"> <figure> <figure class="table"> <table> <tbody> <tr> <td> Building Type </td> <td style="padding-right:175px;"> Commercial </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Building Name </td> <td style="background-color:#e1e1e1;"> ${commBldg} </td> </tr> <tr> <td> Year Built </td> <td> ${commAge} </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Total Floor Area </td> <td style="background-color:#e1e1e1;"> ${commTotalFloor} </td> </tr> <tr> <td> Number of Stories </td> <td> ${commNbrStory} </td> </tr> <tr> <td style="background-color:#e1e1e1;"> Assessment Year </td> <td style="background-color:#e1e1e1;"> ${commAssessYr} </td> </tr> </tbody> </table> </figure> </figure> </figure>` // make decideHTML equal to final Res HTML decideHTML = commHTML } return { type : 'text', text : decideHTML }