{"id":76061,"date":"2017-03-14T08:22:17","date_gmt":"2017-03-14T08:22:17","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/updating-your-hosted-feature-services-with-arcgis-pro-and-the-arcgis-api-for-python\/"},"modified":"2018-05-14T18:53:28","modified_gmt":"2018-05-14T18:53:28","slug":"updating-your-hosted-feature-services-with-arcgis-pro-and-the-arcgis-api-for-python","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/analytics\/analytics\/updating-your-hosted-feature-services-with-arcgis-pro-and-the-arcgis-api-for-python","title":{"rendered":"Updating your hosted feature services with ArcGIS Pro and the ArcGIS API for Python"},"author":4031,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[24341,23391],"industry":[],"product":[36841,36551,36561],"class_list":["post-76061","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-python","tag-spatial-analytics","product-api-python","product-arcgis-online","product-arcgis-pro"],"acf":{"short_description":"Many organizations share public maps on ArcGIS online and have defined a process to update and synchronize the feature layers from their ...","flexible_content":[{"acf_fc_layout":"content","content":"

Many organizations share public maps on ArcGIS online and have defined a process to update and synchronize the feature layers from their local data. One method is well defined using ArcMap; you select the option to overwrite the hosted feature layers when publishing your updates back to ArcGIS online.\u00a0In\u00a02013<\/a>\u00a0and\u00a02014<\/a>\u00a0we explained how you could update your hosted feature services automatically, at a prescribed time, using Python. In the spirit of this incredibly popular workflow to schedule updates, this blog will provide simpler Python code to update services using ArcGIS Pro 1.4 and the new\u00a0ArcGIS API for Python<\/a>.<\/p>\n

<\/p>\n

\"Publish<\/p>\n

This post assumes you\u2019ve already shared a web map from ArcGIS Pro to ArcGIS online. You\u2019ll need to make note of the user name and password of the publisher account, the service name as well as the original project file (.aprx). When publishing a web map from ArcGIS Pro, the underlying feature layers may have _WFL1<\/em> appended to the name to ensure they are unique within organization. Investigate your hosted content and be certain of the service definition (.sd) and feature layer names before proceeding.<\/p>\n

\n

The first step is to install the ArcGIS API for Python; from within ArcGIS Pro, find and add the\u00a0arcgis<\/strong> package using the Python Package Manager<\/a>. Alternatively, open a Python command prompt from: Start<\/strong> > ArcGIS<\/strong> > ArcGIS Pro<\/strong> > Python Command Prompt <\/strong>and\u00a0<\/strong>use the following command, agreeing to update packages (if necessary):<\/p>\n

\u00a0<\/em>conda install -c esri arcgis<\/p><\/blockquote>\n

After installing the ArcGIS Python API you need to define the steps of your update process. Typically, this will involve one or more authors working on the local datasets that were shared to ArcGIS online. The source documents and data will be used to create a service definition (.sd) file using Python. At a prescribed time, perhaps every night at midnight, the local .sd file with your new data will be uploaded to ArcGIS online where it will be used to replace the hosted service.<\/p>\n

\"Process<\/p>\n

Copy the following code and save it locally as a Python file (updatewebmap.py). This code creates the .sd file and upload\/publishes it on ArcGIS online. A number of variables will need to be set within the script; the path to the project, service name username, password, metadata and sharing options when you create the file.<\/p>\n

[sourcecode language=”python”]
\nimport arcpy
\nimport os, sys
\nfrom arcgis.gis import GIS<\/p>\n

### Start setting variables
\n# Set the path to the project
\nprjPath = r”C:PROJECTSNightlyUpdatesNightlyUpdates.aprx”<\/p>\n

# Update the following variables to match:
\n# Feature service\/SD name in arcgis.com, user\/password of the owner account
\nsd_fs_name = “MyPublicMap”
\nportal = “http:\/\/www.arcgis.com” # Can also reference a local portal
\nuser = “UserName”
\npassword = “p@sswOrd”<\/p>\n

# Set sharing options
\nshrOrg = True
\nshrEveryone = False
\nshrGroups = “”<\/p>\n

### End setting variables<\/p>\n

# Local paths to create temporary content
\nrelPath = sys.path[0]
\nsddraft = os.path.join(relPath, “WebUpdate.sddraft”)
\nsd = os.path.join(relPath, “WebUpdate.sd”)<\/p>\n

# Create a new SDDraft and stage to SD
\nprint(“Creating SD file”)
\narcpy.env.overwriteOutput = True
\nprj = arcpy.mp.ArcGISProject(prjPath)
\nmp = prj.listMaps()[0]
\narcpy.mp.CreateWebLayerSDDraft(mp, sddraft, sd_fs_name, ‘MY_HOSTED_SERVICES’, ‘FEATURE_ACCESS’,”, True, True)
\narcpy.StageService_server(sddraft, sd)<\/p>\n

print(“Connecting to {}”.format(portal))
\ngis = GIS(portal, user, password)<\/p>\n

# Find the SD, update it, publish \/w overwrite and set sharing and metadata
\nprint(“Search for original SD on portal…”)
\nsdItem = gis.content.search(“{} AND owner:{}”.format(sd_fs_name, user), item_type=”Service Definition”)[0]
\nprint(“Found SD: {}, ID: {} n Uploading and overwriting…”.format(sdItem.title, sdItem.id))
\nsdItem.update(data=sd)
\nprint(“Overwriting existing feature service…”)
\nfs = sdItem.publish(overwrite=True)<\/p>\n

if shrOrg or shrEveryone or shrGroups:
\nprint(“Setting sharing options…”)
\nfs.share(org=shrOrg, everyone=shrEveryone, groups=shrGroups)<\/p>\n

print(“Finished updating: {} – ID: {}”.format(fs.title, fs.id))
\n[\/sourcecode]<\/p>\n

You can run the code from command line with the following command.<\/p>\n

C:Program FilesArcGISProbinPythonenvsarcgispro-py3python.exe c:mycodeupdatewebmap.py<\/p><\/blockquote>\n

Once you\u2019re sure the script has properly updated your hosted feature service, you can use the command in a scheduled task. This blog has more information<\/a> about creating a scheduled task.<\/p>\n

Important Notes:<\/p>\n<\/div>\n