topic Arcade error when accessing empty feature set in Developers Questions

Arcade error when accessing empty feature set

DonMorrison1 — Sun, 26 Apr 2020 15:51:01 GMT

I'm just starting to use Arcade - like it a lot so far but there is one scenario that I can't figure out. I want to retrieve the set of related records associated with a feature for my ArcGIS Online web map popup. I can do this with this statement

var fs = FeatureSetByRelationshipName($feature, "Program", ["ProgramName"], false);‍

It works great except when the feature has no related records. I still get a FeatureSet returned, and I would expect it to contain zero features. But any method I use to access the FeatureSet returns "Execution Error:Cannot read property 'toString' of null". I've tried all of the following:

Count(fs)
for (var f in fs) {}
First(fs)

What is the trick to allow me to detect in my code that the feature set is empty?

Re: Arcade error when accessing empty feature set

XanderBakker — Sat, 11 Dec 2021 09:48:37 GMT

Hi don.morrison ,

You are right to asume that a FeatureSet is returned which will have 0 features if there are no records in the related table. It is strange that you get this unexpected behavior.

I just did a test and it works for me:

var fsrel = FeatureSetByRelationshipName($feature,"RelData");
Console(Count(fsrel));
Console(fsrel);
Console(TypeOf(fsrel));‍‍‍‍

In case of not having a related record in the table it returns as expected:

object, FeatureSet
0
FeatureSet‍‍‍

Did you use the GUI to define the FeatureSetByRelationshipName row in your expression? It is either caused by that or perhaps caused by your data.

If you would be able to share the data or web map with me I could take a closer look.

Re: Arcade error when accessing empty feature set

DonMorrison1 — Sat, 11 Dec 2021 09:48:40 GMT

Hi Xander. Yes - I used the GUI to create the Arcade expression. I have 3 feature classes that have a relationship with the "Program" table and they all seem to have the same problem. If you want to take a look first hand I can send you credentials to our test organization - let me know where to send that.

I thought maybe it had something to do with my data being served up from an ArcGIS server REST endpoint - but you can see here that it works for one relationship but not the other.

var fs1 = FeatureSetByRelationshipName($feature,"Site_ConservationMeasures")
var fs2 = FeatureSetByRelationshipName($feature,"Program")
Console(Count(fs1))
Console(Count(fs2))‍‍‍‍

Use Console Function to output messages.
0

Execution Error:Cannot read property 'toString' of null‍‍‍

Here is what the relationship looks like:

Re: Arcade error when accessing empty feature set

XanderBakker — Wed, 29 Apr 2020 21:38:49 GMT

Hi don.morrison ,

You can have multiple relationships to a table called "Program", but each relationshipname will be different. I think that is what is causing the error that you see. Otherwise you should get a featureset (which could have 0 features).

Re: Arcade error when accessing empty feature set

DonMorrison1 — Wed, 29 Apr 2020 22:17:33 GMT

Do you mean that the "Relationship Class" names must be different? In any case, they are unique, but some of the path labels are not. ROW_Habitat.SDE.Program is the table that seems to be the one that causes the problem - it participates in 4 relationships. It is the origin in all of them.

Relationship Class name	Backward path label	Forward path label
ROW_Habitat.SDE.Program_to_MgtAreas	Program	ManagementArea
ROW_Habitat.SDE.Program_to_MgtMeasures	Program	MgmtArea_ConservationMeasures
ROW_Habitat.SDE.Program_to_Sites	Program	Site
ROW_Habitat.SDE.Program_to_PollinatorScorecards	Program	PollinatorScorecard

Re: Arcade error when accessing empty feature set

XanderBakker — Wed, 29 Apr 2020 23:51:03 GMT

Hi Don Morrison ,

When you want to access data using a relationship name, the best way to do this in AGOL is to go through the interface to make sure you use the correct name for the relationship in Arcade.

So in the Arcade expression GUI, expand the $feature (click on ">" right from $feature):

Next at the bottom you will find something called "Related records" (or similar, sorry for my Spanish screenshot). (click on ">" right from "Related records"):

Then you will see the relationships listed. Click on the link "FeatureSetByRelationshipName(...)" to get the correct line in the Arcade expression editor window.

Re: Arcade error when accessing empty feature set

DonMorrison1 — Thu, 30 Apr 2020 01:40:43 GMT

Hi Xander - that is exactly how I did it. And the expression does work for those features where there exists one or more related records. The only problem is when there are no related records. I'd like to use the Count function to determine whether any records exist in the returned FeatureSet, but the function throws an error (is there a way to catch the error?) when it should return a count of 0.

Re: Arcade error when accessing empty feature set

DonMorrison1 — Sat, 11 Dec 2021 09:48:42 GMT

OK - I finally figured out what I need to do to get this to work. Since the feature class that I'm in is the destination of the 1 to many relationship, there can only be either zero or one related records. So I check the foreign key field for null before calling the FeatureSetByRelationshipName function like this and that avoids the error that I was getting:

if ($feature.ProgramGUID != null) {
 return First(FeatureSetByRelationshipName($feature, "Program", []));
}
else {
 return null
}‍‍‍‍‍‍

Thanks for helping me work through this Xander!

Re: Arcade error when accessing empty feature set

XanderBakker — Fri, 08 May 2020 19:55:24 GMT

Thanks for sharing don.morrison , glad you could resolve it!

Re: Arcade error when accessing empty feature set

DavidMurray_ODWC — Wed, 02 Mar 2022 15:06:26 GMT

I wanted to thank you for posting this. I ran into a similar error that cropped up in FieldMaps.

~My custom scripts were working ~~fine~~ okay* in AGOL and the ExB App, but when viewed from the FieldMaps App would throw 'unknown data type' errors.

My initial statement wound up being:

Features that would have a related record also had a CATEGORY field value containing the text 'Start'

I really ought to revamp the whole thing, I've realized. I don't think a foreign GUID was used.

*At some point, the AGOL map was producing "Execution Error:d is null" errors for the same scripts, but it stopped for no reason I can determine.

Re: Arcade error when accessing empty feature set

KARIMLABIDI — Fri, 18 Mar 2022 15:51:45 GMT

Hello Everybody,

I have the same problem than DonMorrison1 but I can't solved it. I got the same error msg.

I tried the little code of Dan but it doesn't work .

Any idea?

Thanks a lot

Re: Arcade error when accessing empty feature set

JohannesLindner — Mon, 21 Mar 2022 06:03:12 GMT

Your "build out popup" code is wrong.

If you only want to return the first entry of relateData:

var firstRelateData = First(relateData) if(firstRelateData == null) { // no related data return "null" } return firstRelateData.num_arret

If you want to return all related features:

if(Count(relateData) == 0) { // no related data return "null" } var all_num_arrets = [] for(var f in relateData) { if(f.num_arret != null) { Push(all_num_arrets, f.num_arret) } } return Concatenate(all_num_arrets, ", ")

Re: Arcade error when accessing empty feature set

KARIMLABIDI — Mon, 21 Mar 2022 08:19:02 GMT

Thank you Johannes but I Got the same problem. I can't count the relateData with the filter, the problem is in.

I don't understand this error msg because I have data in each row of my table.

Re: Arcade error when accessing empty feature set

JohannesLindner — Mon, 21 Mar 2022 09:32:42 GMT

Hmmm. Try adding this at the start of your script:

if(IsEmpty($feature.IDARRET)) { return "null" }

Re: Arcade error when accessing empty feature set

KARIMLABIDI — Mon, 21 Mar 2022 10:41:36 GMT

yes it works. Thank you!!

Juste one more question about it: do U know how can i put a little symbol just before my attributes. When i do like this

for(var f in relateData) { if(f.num_arret != null) { Push(all_num_arrets, ` "https://xxxxxxxx/rest/content/items/9e3929af55db440ea45c5f72e37cd3c5/data" ${f.hor_theo_1mn} `) Push(all_num_arrets, ` "https://xxxxxxxx/rest/content/items/9e3929af55db440ea45c5f72e37cd3c5/data"${f.hor_theo_2mns} `) } }

, it just gives me the URL and not the image.

Thank you

Re: Arcade error when accessing empty feature set

JohannesLindner — Mon, 21 Mar 2022 11:02:02 GMT

Arcade doesn't evaluate HTML. Maybe what you want to do is possible, but it will be a little complicated.

I suggest posting a new question for this, as this goes far beyond the scope of the original question, and you'll get more views and potential answers.

Re: Arcade error when accessing empty feature set

ZachBodenner — Wed, 23 Aug 2023 16:59:08 GMT

Hello, I'm getting an issue trying to run this procedure but I can't quite figure out what's wrong. Here's my code:

var assets = FeatureSetByRelationshipName($feature, 'epgdb.PARKS.Asset_Inventory', ['*'], true) console(assets) console(count(assets)) console(typeof(assets)) // Get the first park asset (should only be one) var asset = First(assets) Expects(assets, 'AssetType') // If there was an asset, return the AssetType of it, // Otherwise, return null if (!IsEmpty(asset)) { return asset['AssetType'] } else { return null }

I have park assets, with a related inspection table. The table is where I'm placing this code, and the relationship name in the featureSetByRelationshipName function is the backward path label from my EGDB relationship class (is that correct?)

I've tried adjusting a lot of the parameters but the closest I get is always returning null:

The console messages indicate 0 assets, which I guess makes sense considering this is just in the expression builder and probably doesn't know what the related table would be targetting?

The problem is that when I open Field Maps and try to create a related record, the field I add the calculation to just gives me the error: "Failed to calculate"