topic Re: Update hosted feature service with a zip file, Unknown Error - error code: 500 in ArcGIS API for Python Questions

Update hosted feature service with a zip file, Unknown Error - error code: 500

LienPham1 — Wed, 19 Jun 2024 21:49:28 GMT

Hi,

I'm seeking assistance to update my hosted feature layer titled "Stands_nd_statistics" using a zipped shapefile. My objective is to both update existing features with new data and add new features where necessary. I've attempted to achieve this using the append operation in ArcGIS Python API, but I encountered an Unknown Error with error code 500.

import arcpy, os, json, zipfile
from arcgis.gis import GIS
from arcgis import features
from arcgis.mapping import WebMap
from arcgis.features import FeatureLayerCollection
from arcgis.features import FeatureLayer
gis = GIS("https://www.arcgis.com", "username", "password")
search_result = gis.content.search("title:Stands_nd_statistics", item_type = "Feature Layer")
layer_item = search_result[0]
feature_layer = FeatureLayer(layer_item.url)
# Upload the zipped shapefile as an item to your GIS
zip_path = r"P:\Projects\Stands_nd_statistics.zip"
shapefile_item = gis.content.add({'title': 'Stands_nd_statistics_upload','type': 'Shapefile'}, data=zip_path)
feature_layer.append(item_id=shapefile_item.id, upload_format="shapefile", upsert=False)
Exception: Unknown Error

Any guidance or insights on how to troubleshoot and resolve this issue would be greatly appreciated! Thank you.

Re: Update hosted feature service with a zip file, Unknown Error - error code: 500

MichaelSnook — Wed, 19 Jun 2024 22:04:59 GMT

I'm seeing the same type of error as I posted here :

https://community.esri.com/t5/arcgis-api-for-python-questions/after-3-3-upgrade-featurelayercollectionmanager/m-p/1481624#M10087

It looks like it could be a file size issue but I don't see anywhere in the updated documentation how to get around it.

Re: Update hosted feature service with a zip file, Unknown Error - error code: 500

EarlMedina — Fri, 21 Jun 2024 15:36:25 GMT

Here's an idea. Load that shapefile into a spatial dataframe.

sdf = pd.DataFrame.spatial.from_featureclass("path\to\your\data\census_example\cities.shp")

Then append like this instead:

adds = sdf.spatial.to_featureset() feature_layer.edit_features(adds=adds)

Re: Update hosted feature service with a zip file, Unknown Error - error code: 500

JakeSkinner — Mon, 24 Jun 2024 11:19:07 GMT

@LienPham1 have you tried executing ArcGIS Pro's Append tool? This provides an upsert option which will update existing features with new data and add new features. To use the upsert option, make sure the field your using in the hosted feature service has a unique index: