nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed

I have a dynamic query layer (polygon) derived from feature class and SQL table, I was able to share it to ArcGIS Online as a web layer.

1- I would like to setup an automated workflow for overwriting or append to hosted feature services within our ArcGIS Online Account (stand alone arcpy script) and schedule that for everyday update. I tried this one Update Hosted Feature Service with Feature Class but got this error. I am not interested using Python API,

2- Where is the path of Query Layer (workspacePath) ? I know its generated and already shared to ArcGIS Online.

3- also I went through this one Best Practise for scripting updating of hosted feature services?

but none of them helped.

scripts.zip

Find more posts tagged with

Accepted answers

All comments

DominguezWilliam

Not sure if this is still an issue but I was able to get this to work from a esri presentation youtube link below. One issue was all date column have their time zone affected. I add batch calculate field to add 1 day to all date columns. This fixes my issue and allows the model to publish as scheduled.

jskinner

Brian Kaplan‌ here is a script that may assist you with the append:

https://community.esri.com/docs/DOC-14843-overwrite-arcgis-online-feature-service-using-truncate-and-append

Anonymous User

I've been exploring the use of the python api and overwrite (FeatureLayerCollection and manager) to update a hosted table. The overwrite works through Windows Task Scheduler running a DOS batch file that calls a python program. The ultimate goal is to update a table that is joined to a feature class. However, when I have the table joined to the feature class, the overwrite of the table fails apparently because the table is "locked" up. I have changed the settings to allow edits to the table and the original feature class but to no effect. The join is one (feature class) to many (table). Anyone experience something similar. I will explore Append to the table for the updates. Append is just a little more complicated. Thanks

HushamMohamed

Hi Jake,

I've created a model its working fine when I run it from the Model Builder - ArcGIS Pro, but which fails when it is scheduled. In the Windows Scheduler window I get a (0x1) "Last Run Result" status. Apparently when working with hosted layers it isn't as simple as it sounds.

Could you provide a simple example of how to create a model that interacts with a hosted feature class with windows Scheduler.

When you get time, I posted few questions here, still looking for answers.

Thanks

HushamMohamed

this exactly what I did, any how will figure it out, my main issue now is how to set the time field

because the append now reset the date/time field to UTC -5, while I need it to be UTC -6 Central Time.

jskinner

As an alternative, you can export the model to a python script, and then try configuring Windows Task Scheduler to execute the script:

https://community.esri.com/docs/DOC-14675-schedule-a-python-script-using-windows-task-scheduler

HushamMohamed

I created the Model for deleting and Appending,

and It work Perfect, the problem now with the Schedule,I keep getting this error. I am not Sure Is windows related or ArcGIS Pro issue.

HushamMohamed

Thank you, Will try this easiest approach. and get back to you.

jskinner

Hi Husham,

The easiest approach would be to create a model and run the Delete Rows to delete all the records from the feature service, and then execute the Append tool to append features from a feature class to the feature service.

Once you have the model created, you can set this up to run at a prescribed time. See the following help document on how to do this using ArcGIS Pro 2.5:

Schedule geoprocessing tools—ArcGIS Pro | Documentation

HushamMohamed

2- Where is the path of Query Layer (workspacePath) ?

I checked its Data source Path, nothing on the DB.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.