topic Re: FeatureSetByName or ByID with Flat Table? in ArcGIS Enterprise Questions

FeatureSetByName or ByID with Flat Table?

InvenergyGIS_User — Mon, 24 Aug 2020 15:08:32 GMT

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

Re: FeatureSetByName or ByID with Flat Table?

XanderBakker — Tue, 25 Aug 2020 20:18:18 GMT

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.

Re: FeatureSetByName or ByID with Flat Table?

DavidTreering1 — Tue, 25 Aug 2020 20:23:47 GMT

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.

Re: FeatureSetByName or ByID with Flat Table?

XanderBakker — Wed, 26 Aug 2020 13:17:50 GMT

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?

Re: FeatureSetByName or ByID with Flat Table?

DavidTreering1 — Wed, 26 Aug 2020 17:14:35 GMT

10.7.1