ArcGIS Dashboards Data Expression using rest service

Question

Hello -

I am trying to use an external service (https://onemap.cdc.gov/onemapservices/rest/services/EJI/EJI_2024_Data_Service/MapServer/0) in my ArcGIS Online Dashboard data expression, but don't seem to be setting it up right. Can someone tell me where I am going wrong?

// Identifies the portal.

var port = Portal('https://onemap.cdc.gov/onemapservices/rest/services/EJI/EJI_2024_Data_Service/MapServer');

//Pulls in the map image service and limits it to the fields required and filters the records to those in Ohio and relevant counties.

var fs = filter(FeatureSetByPortalItem(port, 0, 
 ['GEOID', 'RPL_EJI_CBM', 'RPL_EBM', 'RPL_CBM', 'RPL_SVM', 'RPL_HVM', 'EPL_OZONE', 'EPL_PM', 'EPL_DSLPM', 'EPL_TOTCR', 'EPL_NPL', 'EPL_TRI', 'EPL_TSD', 'EPL_RMP', 'EPL_LEAD', 'EPL_COAL', 'EPL_PARK', 'EPL_HOUAGE', 'EPL_WLKIND', 'EPL_ROAD', 'EPL_RAIL', 'EPL_AIRPRT', 'EPL_IMPWTR', 'EPL_NEHD', 'EPL_SMOKE', 'EPL_BURN', 'EPL_GRGT', 'EPL_RFLD', 'EPL_CFLD', 'EPL_TRND', 'EPL_HRCN', 'EPL_SWND', 'EPL_MINRTY', 'EPL_POV200', 'EPL_NOHSDP', 'EPL_UNINSUR', 'EPL_NOINT', 'EPL_AGE65', 'EPL_AGE17', 'EPL_DISABL', 'EPL_LIMENG', 'EPL_GROUPQ', 'EPL_MOBILE', 'EPL_CHD', 'EPL_ASTHMA', 'EPL_CANCER', 'EPL_DIABETES', 'EPL_MHLTH'], 
 false),

"(STATEABBR='OH' AND (COUNTY IN('LAKE COUNTY', 'CUYAHOGA COUNTY', 'SUMMIT COUNTY', 'LORAIN COUNTY', 'MEDINA COUNTY', 'GEAUGA COUNTY')))" 
);

Thanks!

LJackson29 · Answer

@clt_cabq I expect the same. It doesn't look like you can write a data expression using a layer from a map unfortunately. I want to use the data expression to filter the field list down so it has a better response time. The layer is quite large both field number and record number (I did filter the records in the map) so the dashboard is running quite slow. I did try pulling it into our AGO and the data expression works and the dashboard has a much better response time.

clt_cabq · Answer

I suspect that you can't use the portal function to return a feature set from a REST endpoint like this - the Arcade documentation suggest that is used only for AGOL and Enterprise Portals. That could just be my limited knowledge of Arcade though.

Can you just add the layer into your map from its URL and work with it from there?

LJackson29 · Answer

@clt_cabq Thanks for your response. I think it is related to the rest service - I am not sure how to set that up to pull in the data. Unfortunately, creating an item in our AGOL is not the preferred option.

I have updated the first part of the code to the below (there are no errors showing up in this section or the rest of the code, I just get "Test execution error: Unknown Error. Verify test data." when I try to run it).

// Identifies the portal.

var port = Portal('https://onemap.cdc.gov/onemapservices/rest/services/EJI/EJI_2024_Data_Service/MapServer');

//Pulls in the map image service and limits it to the fields required and filters the records to those in Ohio and relevant counties.

var fs = filter(FeatureSetByPortalItem(port, 'c38778176a6b4a65940ffe77c192eded', 0, 
 ['GEOID', 'STATEABBR', 'COUNTY', 'RPL_EJI_CBM', 'RPL_EBM', 'RPL_CBM', 'RPL_SVM', 'RPL_HVM', 'EPL_OZONE', 'EPL_PM', 'EPL_DSLPM', 'EPL_TOTCR', 'EPL_NPL', 'EPL_TRI', 'EPL_TSD', 'EPL_RMP', 'EPL_LEAD', 'EPL_COAL', 'EPL_PARK', 'EPL_HOUAGE', 'EPL_WLKIND', 'EPL_ROAD', 'EPL_RAIL', 'EPL_AIRPRT', 'EPL_IMPWTR', 'EPL_NEHD', 'EPL_SMOKE', 'EPL_BURN', 'EPL_GRGT', 'EPL_RFLD', 'EPL_CFLD', 'EPL_TRND', 'EPL_HRCN', 'EPL_SWND', 'EPL_MINRTY', 'EPL_POV200', 'EPL_NOHSDP', 'EPL_UNINSUR', 'EPL_NOINT', 'EPL_AGE65', 'EPL_AGE17', 'EPL_DISABL', 'EPL_LIMENG', 'EPL_GROUPQ', 'EPL_MOBILE', 'EPL_CHD', 'EPL_ASTHMA', 'EPL_CANCER', 'EPL_DIABETES', 'EPL_MHLTH'], 
 false), "(STATEABBR='OH' AND (COUNTY='LAKE COUNTY' OR COUNTY='CUYAHOGA COUNTY' OR COUNTY='SUMMIT COUNTY' OR COUNTY='LORAIN COUNTY' OR COUNTY='MEDINA' OR COUNTY= 'GEAUGA COUNTY'))" 
);