FeatureSetByName or ByID with Flat Table?

[InvenergyGIS_User]

I am getting no records returned from a FeatureSetByID Arcade expression for a flat table in my $map or $datastore.  Is this expected behavior?  Does the FeatureSet function work on flat tables or only on spatial data?

FeatureSetById($datastore, "2") returns the field names, but no data.

Using ArcGIS Enterprise 10.7.1

[XanderBakker]

Hi Invenergy GIS User ,

Arcade can work with flat tables and featurelayers. 

Did you construct this line manually or did you use the interface to create it, like this: 

If the test returns an empty featureset (just field names) you should check is the service is up and working correctly. 

[DavidTreering1]

Thanks, Xander Bakker‌!

I used the interface as in your screenshot.

I gave the records in the flat table a fake lat/long and republished so it became a spatial featureset.  Then the FeatureSetByName and ByID work fine.

You said Arcade works with flat tables, which I see is true, but that particular function just gives me empty featuresets.

[XanderBakker]

Hi David Treering ,

I'm glad you could make it work, but it remains strange that without the coordinates it is not working for you. What version of Enterprise are you using?

[DavidTreering1]

10.7.1