Automate AGOL publishing

Roli

We are using ArcGIS Desktop 10.7.1 and trying  to automate AGOL publishing ( overwriting a service)..

We have a service ( created by publishing an mxd) that needs to be updated on a daily basis. We have automated the local data creation/update process using models.

Once the data is updated, we need to  push the updates to AGOL . One option is to re-publish the MXD and overwrite the service. However ,  there must be a better/easier way to do this!

Found a python script online and it seems to be working but not in a consistent way: sometimes we need to have the mxd  open and be logged in to AGOL... sometimes not...  This doesn't make sense because the script contains the credentials.

Not sure if this is an AGOL limitation/issue or an issue with the  python script ( see attached).

Any help is appreciated.

Thanks in advance!

AGOL_Publish_py_script_02-15-22.txt

RussRoberts_0-1719466120753.png

jcarlson

I would advise against overwriting the service. As long as there's no schema change, it's not necessary, and is more likely to result in some error. We have several processes that update hosted layers on a daily basis, and we're able to use the ArcGIS Python API to do so.

A simplified version of it would look like this:

from arcgis import GIS
import pandas as pd

# Log in
gis = GIS('your-portal-url', 'username', 'password')

# Get hosted layer; replace "0" with appropriate index as needed; use ".tables[0]" to get standalone tables from a service
lyr = gis.content.get('itemid of service').layers[0]

# Query source data
df = pd.read_sql('some sql query')

# Truncate existing records
lyr.manager.truncate()

# Apply new features to layer
lyr.edit_features(adds=df)

 

There's a lot more to it than that, but the specifics will depend a lot upon where the data's coming from.