Overwrite a hosted feature layer with new CSV

Question

I'm new to the esri community and would like to know if there is a way to overwrite the data in a hosted feature layer while retaining the layer definition. The issue I am running into is after I execute the python script to overwrite the existing layer, all of custom layer definitions, such as "drawingInfo", "maxRecordCount", and "typeIdFieldID", are set back to the default.

As a workaround, I attempted to retrieve the layer definition by retrieving the 'properties' of the feature layer and then using 'manager.update_definition' to re-establish the custom definition but when I do that I get 'TypeError: Object of type PropertyMap is not JSON serializable'

Any help would be appreciated.

Thank you

JustinReynolds · Answer

It was the same for me.  It is getting confused here {'properties': the_properties}

In the update_definition method it will do a json.dumps trying to encode the dictionary {'properties': the_properties} to JSON.  The issue here is that the_properties is already a json_string, based on how it was retrieved, and in a json string you see json values like null, true, & false.  So when creating the dict {'properties': the_properties} you are creating a python dictionary with the key set to a json string.

This confuses the process because json.dumps is looking for None, True, & False values instead of null, true, & false when encoding the string.

So, since the_properties is already a json string, what you want to do before calling the update_definition is convert the json string to a python dictionary or list of dictionaries whatever it may be. Get everything in a python format then pass it to the update_definition where it will encode the dictionary to a json string successfully.  At least this is what I have to do in a Jupyter Notebook.  It looks something like this:

# parsing _field_info creates a python dictionary, 
# where true=True, false=False, & null=None
json_string_to_dict = json.loads(f'{_field_info}')

# Create the update_dict
update_dict = {"fields": json_string_to_dict}

# Update the definition --> the update_definition method uses json.dumps
# to convert the python dictionary to json_string
result = feature_layer.manager.update_definition(update_dict)
print(str(result))

Or in your case:

json_string_to_dict = json.loads(f'{the_properties}')
dict_update = {"properties": json_string_to_dict}
result = feature_layer.manager.update_definition(dict_update)

PaulMarano · Answer

Hi Minbin:

I appreciate your time and help.

When I do this, I get the error:

TypeError: Object of type PropertyMap is not JSON serializable

Anonymous User · Answer

have a try with:

the_point_layer.manager.update_definition({'properties': json.dumps( the_properties}))