edit_features to add FeatureLayer records to hosted table

Question

I am attempting to query existing hosted FeatureLayer features and push them to an existing hosted table using the edit_features function and adds parameter. The FeatureLayer and table have the same schemas with the exception of geometry not present in the table.

The code executes all the way through but no new records are added to the hosted table. There are only 64 records being added so there is no limitation issue. Is edit_features the correct function to use or should append be used instead?

#pacpInspects is existing hosted FeatureLayer
#histInspects is existing hosted table
#existPipes is a list of PipeIDs
numExistPipes = 64
records_to_add = []
for x in range(0,numExistPipes):
    pipe = existPipes[x]
    pipeQuery = pacpInspects.query(where="""PipeID = '%s'"""% pipe, out_fields='*')
    feature_to_be_added = deepcopy(pipeQuery.features[0])
    records_to_add.append(feature_to_be_added)
histInspects.edit_features(adds=records_to_add)

KyleGallagher16 · Answer

I was able to make this work after simply adding the return_geometry=False parameter to the pipeQuery.

records_to_add = pacpInspects.query(where=f'PipeID IN({id_list})',out_fields = '*',return_geometry=False)

KyleGallagher16 · Answer

Here is the result:

[{'objectId': -1, 'uniqueId': -1, 'globalId': None, 'success': False, 'error': {'code': 1000, 'description': 'Object reference not set to an instance of an object.'}}]

I found this post that may or may not be related. Seems like geometry may be a factor here.

https://github.com/Esri/arcgis-python-api/issues/600

jcarlson · Answer

That's interesting. Assign the edit_features line to its own variable so that you can inspect it.

add_feats = histInsects.edit_features(adds=records_to_add)

print(add_feats['addResults'])

There should be some message in there about whether or not it was successful.