Not sure if you are trying to sync both ways, or why you are wanting to use the arcpy.MakeFeatureLayer_management as the bug references, but maybe my process is different enough it won't work for you.
In my case, I have a local eGDB that I published to AGOL for data collection in a Field Maps app.
So, the data is collected in AGOL hosted feature service, but I need to keep the local copy up to date.
I have been using code similar to the following for the last 2 years and have had no issues with it.
Basically, I establish a search cursor on the AGOL and local datasets and load the GlobalIDs into a list. It also compares the two lists, and if there are GlobalIDs in the AGOL list, but not the local list, it means those features need to be copied (appended) over. (So, we are only coping the 'missing' features, not the entire dataset)
Then I use arcpy.management.Append to append the missing features to the local data using a where clause that is an IN() with the GlobalID's from the missing list like so:
import arcpy
Signs = r'\\path_to\\SignDatabase.sde\SignsDatabase.DBO.Signs' # path to the signs local eGDB FC
L0Sign = r"https://services3.arcgis.com/itemID/ArcGIS/rest/services/HostedFeatureService/FeatureServer/0" # URL to AGOL hosted feature
AGOL_SignTable = arcpy.FeatureSet() # define AGOL_SignTable as FeatureSet
AGOL_SignTable.load(L0Sign) # Load hosted feature into AGOL_SignTable
SignList = [] # empty list for local GDB features
AGOLSignList = [] # empty list for AGOL features
with arcpy.da.SearchCursor(Signs,"GlobalID") as cursor: # Get list of GlobalID's from SDE data
for row in cursor:
SignList.append(row[0])
with arcpy.da.SearchCursor(AGOL_SignTable,"GlobalID") as cursor: # Get list of GlobalID's from AGOL data
for row in cursor:
AGOLSignList.append(row[0].upper())
if (row[0].upper() or row[0]) not in SignList: # and if not in local SignList, append to AddSignList
AddSignList.append(row[0])
ith arcpy.EnvManager(preserveGlobalIds=True, maintainAttachments = True):
if AddSignList: # if any 'missing' features in AddSignList, then append to local eGDB
print("adding " + str(len(AddSignList)) + " Sign Records")
Signs = arcpy.management.Append(inputs=[L0Sign], target=Signs, schema_type="TEST", field_mapping="", subtype="", expression="GlobalID IN ('" + '\',\''.join(AddSignList) + "')")[0]
else:
print("No Signs to add")
I can't say the same for any scripts I run using the API python (seem to get a lot of timeout errors, etc. and have to code accordingly). However, I have had good success with the API code here to export an AGOL hosted feature service to a FGDB (including attachments) and download to local folder without having to script any mouse clicks.
R_
