topic Append Hosted Layer to Feature Class in ArcGIS API for Python Questions

Append Hosted Layer to Feature Class

MattFancher1 — Mon, 24 Apr 2023 13:31:29 GMT

Hello all. I'm attempting a script to append records from an ArcGIS Online feature layer to a local geodatabase feature class. I want to run the script nightly as a scheduled task. The below works well when I have Pro open and am logged into ArcGIS Online as my Portal. It fails when I run it as a stand alone script, saying the hosted feature layer does not exist or is not supported. Any advice how to accomplish the append properly? Thanks very much in advance.

import arcpy from arcgis import GIS #connect to ArcGIS Online agol = GIS(username="username",password="password") #find the hosted feature layer item = agol.content.get("6ceffb124830415a9149e7c965e0fd12") lyr = item.layers[0].url #reference the geodatbase feature class fc = r"C:\temp\gdb.sde\GISDB.GIS.TARGET_FC" #empty the feature class arcpy.management.TruncateTable(fc) #append from the feature layer to the feature class arcpy.Append_management(lyr, fc, "NO_TEST")

Re: Append Hosted Layer to Feature Class

RhettZufelt — Mon, 24 Apr 2023 17:29:33 GMT

You are not establishing the connection to your AGOL portal (when logged in in Pro, that is automagic).

Maybe something like (you supply username and password, but need to identify portal URL):

#connect to ArcGIS Online agol = GIS(url='https://yourorg.maps.arcgis.com/',username="username",password="password")

Re: Append Hosted Layer to Feature Class

MattFancher1 — Mon, 24 Apr 2023 17:43:30 GMT

Thank you @RhettZufelt for the response! I tried your suggestion, but unfortunately got the same result saying the feature layer does not exist or is not supported. Any other ideas?

Re: Append Hosted Layer to Feature Class

RhettZufelt — Mon, 01 May 2023 15:03:37 GMT

Suspect maybe the way you are "getting" the feature layer isn't supported for the append tool.

When I append from HFS to local FGDB, I just use something like:

import arcpy from arcgis.gis import GIS arcpy.env.preserveGlobalIds = True fc = r"C:\temp\gdb.sde\GISDB.GIS.TARGET_FC" gis = GIS(url='https://yourorghere.maps.arcgis.com/', username='AdminUser', password='UsersPass') in_lyr = 'https://services3.arcgis.com/5asfasga45zb/arcgis/rest/services/GMTest/FeatureServer/1' #arcpy.management.TruncateTable(fc) arcpy.Append_management(in_lyr, fc, "NO_TEST")