topic Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro in ArcGIS Online Questions

Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Sun, 05 Apr 2020 14:36:21 GMT

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.

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Mon, 06 Apr 2020 18:07:52 GMT

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

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

JakeSkinner — Tue, 07 Apr 2020 16:45:34 GMT

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Tue, 07 Apr 2020 18:11:46 GMT

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Tue, 07 Apr 2020 19:46:34 GMT

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.

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

JakeSkinner — Tue, 07 Apr 2020 21:04:52 GMT

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Tue, 07 Apr 2020 21:28:54 GMT

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.

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

JasonSimpson — Wed, 08 Apr 2020 13:44:13 GMT

Have you tried the convert time geoprocessing tool? I had this issue a few weeks back and had to incorporate this tool into my process. Not sure if this helps you, but it worked for me.

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Mon, 13 Apr 2020 16:59:28 GMT

Did not worked for me, did your original date/time with your local time Like my Case?

Thanks

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

HushamMohamed — Tue, 14 Apr 2020 14:35:14 GMT

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

Anonymous User — Wed, 12 Aug 2020 14:52:32 GMT

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

JakeSkinner — Wed, 12 Aug 2020 17:20:17 GMT

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

Re: Overwrite Or Append a web feature layer Arcpy, ArcGIS Pro

DominguezWilliam — Fri, 09 Sep 2022 23:23:00 GMT

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.