FeatureSetByPortalItem - Picking an Enterprise Portal?

Question

Hello,

I am trying to build a new data expression in a serial chart within my ArcGIS Dashboard app using FeatureSetByPortalItem().

I can create one connecting to my AGOL account, however I don't seem to be able to create one connecting to my local Enterprise Portal account.  When I try I get the following error message:

Execution Error:Item does not exist or is inaccessible.

From what I can read via: https://developers.arcgis.com/arcade/guide/types/#portal

I should be able to connect to a service via its service ID.  The service exists, but I am not able to connect to it.  Right now the service is shared with a Beta Testing group within our Portal.

Is there a chance my share settings are blocking it?  I am an admin and member of said group.  I have tried both the default 'www.arcgis.com' and the URL for my Enterprise Portal.

Any ideas?  Thanks

var p = Portal('https://www.arcgis.com');

var features = FeatureSetByPortalItem(
  p,
  'xyz',
  0,
  ['*'],
  false
);
Count(features);

jcarlson · Answer

attributes is a dict, not an array, and I realize I had that wrong in my expression.

It should be:

{
  attributes: {
    SIZE: f['SIZE'],
    RISKCNT: Count(xs_pts)
  }
}

I will update my post accordingly.

ghaskett_aaic · Answer

Thanks again for your help on this.

I updated my script to the following and while the returned numbers seemed valid when testing, the return lacks information in the SIZE and RISKCNT fields.

What am I doing wrong?

var p = Portal('https://maps.xyz.com/portal/')
var sql = "(DATE > CURRENT_DATE - 7)"
var sqlST = "(STATE = 'CO')"

// the polygon layer
var fsHail = FeatureSetByPortalItem(p, 
'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',
0, ['label', 'SIZE', 'DATE_TEXT'], true
);

var fHail = Filter(fsHail, sql);

// the pts layer
var fsInforce = FeatureSetByPortalItem(p, 
'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',
0, ['PolicyNumber', 'LocationID', 'LOB', 'TIV', 'RiskCount'], false
);

var fInforce = Filter(fsInforce, sqlST);
/*Count(fInforce);*/

// output dict
var out_dict = {
    fields: [
        {name:'SIZE', type:'esriFieldTypeInteger'}, 
        {name:'RISKCNT', type:'esriFieldTypeInteger'}
    ],
    geometryType: '', 
    features:[]
}

// loop through polygons, get points
for (var f in fHail) {
    var xs_pts = Intersects(f, fInforce)
    Push(
        out_dict['features'],
        {
            attributes: [
                {
                    SIZE: f['SIZE'],
                    RISKCNT: Count(xs_pts)
                }
            ]
        }
    )
}
return FeatureSet(Text(out_dict))

jcarlson · Answer

Spatially intersecting two layers works the same, regardless of where the two layers come from. Here's a rough idea of what this would look like, though you'll need to make some adjustments.

var p1 = Portal('portal-url')
var p2 = Portal('agol-url')

// your portal fs; i'm assuming that this is the polygon layer
var fs1 = FeatureSetByPortalItem(
    p1,
    'itemid',
    0,false
    ['objectid'],
    true
);

// your agol fs
var fs2 = FeatureSetByPortalItem(
    p2,
    'itemid',
    0,
    ['objectid'],
    false
);

// output dict
var out_dict = {
    fields: [
        {name: 'polygon_id', type: 'esriFieldTypeString'},
        {name: 'point_count', type: 'esriFieldTypeInteger'}
    ],
    geometryType: '',
    features: []
}

// loop through polygons, get points
for (var f in fs1) {
    var xs_pts = Intersects(f, fs2)

Push(
        out_dict['features'],
        {
            attributes: {
                polygon_id: f['objectid'],
                point_count: Count(xs_pts)
            }
        }
    )
}

return FeatureSet(Text(out_dict))