topic Re: problem update hosted feature in portal in ArcGIS API for Python Questions

problem update hosted feature in portal

OrrGvili — Wed, 15 Feb 2023 14:23:02 GMT

trying to update hosted feature on ArcGIS Enterprise 10.8.1+ from local GDB

this is the Exception
Exception: 'appendUploadFormat' must be one of the following: shapefile, geojson, csv, featureCollection, excel.

in the API working with fgdb is option ,

this is the function i use for the update what am i missing ?

def append_and_update(agriplots,gdb, url,username,password): gis = GIS(url = url, username=username, password=password) layer_for_update = FeatureLayer(agriplots,gis) print("Uploading File Geodatabase") fgd_properties={'title':"Temp GDB deleted at the end", 'tags':'temp file geodatabase', 'type':'File Geodatabase'} gdb_item = gis.content.add(item_properties=fgd_properties, data=gdb + ".zip") print("updating... ") result = layer_for_update.append(item_id=gdb_item.id, upload_format="filegdb",source_table_name='AP_WGS84',return_messages=True) print(result) delete_result = gdb_item.delete() print(delete_result)

Re: problem update hosted feature in portal

LSaunders — Thu, 22 Jun 2023 14:18:45 GMT

Did you ever find a solution for this?

Re: problem update hosted feature in portal

AnthonyAtkins2 — Fri, 21 Jul 2023 16:28:11 GMT

I too am getting this error and I'm using a FGDB. Any help would be appreciated!

Re: problem update hosted feature in portal

AnthonyAtkins2 — Fri, 21 Jul 2023 20:25:56 GMT

You posted this back in February, so I'm wondering if you found a solution? I haven't "officially" figured out why we are getting this message, but I have a strong hunch. I bet you're logged into Portal as opposed to AGOL, right? I KNOW; why would there be a difference? Well, when I run my script when connected to AGOL, it works perfectly, but when I'm connected to Portal, NOPE!

So, if someone from ESRI is reading this would you please explain why this is the case? I'm still searching for a Portal solution (Unless you have Big Data and GeoAnalytics, the managed_data append method is out), so if someone knows of one, please let me/us know.

Re: problem update hosted feature in portal

LSaunders — Fri, 21 Jul 2023 20:29:45 GMT

Portal will only allow me to do it with shapefiles...not great!

Re: problem update hosted feature in portal

JeredHansenNPS — Thu, 31 Aug 2023 22:48:51 GMT

Any updates on this error? ESRI documentation clearly states that file geodatabases are an acceptable format. We are still running Portal/Server 10.9.1. Potentially that is the source of the issue.

Re: problem update hosted feature in portal

AiminFan1 — Tue, 19 Sep 2023 17:09:20 GMT

I am running 11.1 and got this error too

Re: problem update hosted feature in portal

MiguelVillafranca — Wed, 08 Nov 2023 14:27:26 GMT

Exactly the same issue here. ArcGIS enterprise 10.9.1 fails with "filegdb", although the documentation says it should work.

Re: problem update hosted feature in portal

NanaeAubry — Wed, 06 Mar 2024 18:34:18 GMT

Hello, sorry for a VERY late reply but we have no idea why this is occurring.

We are looking into it and will post a solution here when we have one. In the meantime you can see the supported append formats on a feature layer (both online and enterprise) with:

`feature_layer.properties.supportedAppendFormats`

We don't know why only append formats are being supported on certain feature layers. But this is why you are seeing the error, the format is not supported.

Re: problem update hosted feature in portal

NanaeAubry — Wed, 06 Mar 2024 18:37:10 GMT

We are looking at WHY only certain formats are supported but to see what formats are supported on the feature layer you can see it in the properties:

`feature_layer.properties.supportedAppendFormats`

This is more of an Enterprise/Online issue rather than Python API but we will update our error handling on this and also try to understand why.

Re: problem update hosted feature in portal

Iron_Mark — Thu, 26 Sep 2024 09:53:11 GMT

What a joke! So much time wasted solving all sorts of non sense issues with the File geodatabase, portal item query and so on and forth, and at the end you discover there there is the final BUG happening since more than a year ago that still hasn't been fixed...for a proprietary file format! unbelievable

Re: problem update hosted feature in portal

Adrian — Mon, 13 Jul 2026 12:56:51 GMT

Two years later, working with ArcGIS Enterprise 11.5 and it's still not possible to append data to a hosted feature layer with an uploaded file geo database. My layer supports only the following formats for appending:

'csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile'

Using arcpy.Append_management would work with a local fGDB as source and a hosted feature layer as target. However, this tool is painfully slow (1 minute for appending 2'000 point features). That's why I hoped, uploading first, appending directely on the server afterwards would be faster. I was not expecting, that this is not possible.

We are still looking for a fast and stable aproach to keep our 1000+ feature services up to date in a fully automated process. Working with transfer formats like csv or geojson is not recommended, because they are not preserving the data (e.g. no support for true curves). Currently we are overwriting the whole feature service in case of any slight data changes. However, this is like using a sledgehammer to crack a nut and sometimes, it ends up with a corrupted feature service and an unspecific "job failed" error.

Off topic but somehow related is the fact, that a hosted feature layer is losing every information about its source. This makes it difficult to keep it up to date. We have to maintain a separate data structure to store the mapping beween all feature layers and feature classes. A hidden field for a business key on every layer and every portal item would be nice.