Joining structured array to a table using ExtendTable function fails?

Anonymous User — Sat, 11 Dec 2021 22:34:25 GMT

When using the arcpy.da.ExtendTable() function to join the contents of a NumPy structured array to a hosted feature layer based on a common attribute field "geography" it fails with the message below. I am trying to join an array to a table that has identical field names. I want to update existing fields that have the same name as those in the array which is why append_only = False.

Any help or suggestions on other methods to perform this operation would be appreciated.

array = yearCollect.to_records()


feature_service_itemID = "9656cfce75354d88b4c88eca3aa9661e"
item = gis.content.get(feature_service_itemID)
lyr = item.layers[0]
output = lyr.url


arcpy.da.ExtendTable(output, 
                     "NAMELABEL", 
                     array, 
                     "geography",
                    append_only = False)‍‍‍‍‍‍‍‍‍‍‍‍‍‍


---------------------------------------------------------------------------
RuntimeError                              Traceback (most recent call last)
<ipython-input-22-545d38bf9e46> in <module>
      3                      array,
      4                      "geography",
----> 5                     append_only = False)

RuntimeError: The user does not have permission to execute the operation.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Joining structured array to a table using ExtendTable function fails?

DanPatterson — Fri, 16 Oct 2020 17:24:40 GMT

Just a thought. ExtendTable makes permanent changes to the featureclass/table. Do you have permissions to do so?

topic Re: Joining structured array to a table using ExtendTable function fails? in ArcGIS Online Questions

Joining structured array to a table using ExtendTable function fails?

Re: Joining structured array to a table using ExtendTable function fails?