Hello,
I have built a ModelBuilder that will query and delete features from a Hosted ArcGIS Online Feature Service that I am owner of and I am also an Administrator for the ArcGIS Organization.
I am using
I want to do this with only selected features and not the entire Hosted Feature Service, so replacing/overwriting the Hosted Feature Service is not an option.
When I run the ModelBuilder while ArcGIS Pro is open, then the model will run successfully; the old features are selected from the query, deleted, and appended with the new features.
However, when I use ArcGIS Pro to "schedule" the model to run on a certain time interval, then I receive an error that states the following lines within the Geoprocessing History of the scheduled event -
1). Executing (Select Existing Cells Layer By Attribute): SelectLayerByAttribute EDGE_Survey_Cells "New selection" "Stream_Name = 'GMR' And ProjectNumber = 'TST2021-0004-001'" #
2). Start Time: Wednesday, March 3, 2021 3:53:10 PM
3). ERROR 000358: Invalid expression
4). Failed to execute (Select Existing Cells Layer By Attribute).
So I am wondering if I will need to devise some sort of Python for ArcGIS scripting or if this is actually achievable within the use of Model Builder and the Select by Attributes tool or a combination of both.
Any information or direction within the right direction would be greatly appreciated.
Solved! Go to Solution.
Solved this myself by using the "Make Table View" while pointing the output workspace to my FGDB and everything went smoothly. Selected the correct features within the Hosted Feature Service, completed the delete on just those features, and then completed the append.
Solved this myself by using the "Make Table View" while pointing the output workspace to my FGDB and everything went smoothly. Selected the correct features within the Hosted Feature Service, completed the delete on just those features, and then completed the append.