AnsweredAssumed Answered

Joining structured array to a table using ExtendTable function fails?

Question asked by CWB393@mt.gov_montana on Oct 16, 2020
Latest reply on Oct 16, 2020 by danretired

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.

Outcomes