edit_features Succeeds but doesn't add some attributes

nate0102

Hello,

Issue summary: feature_table.edit_features(add=[...]) adds correct number of records but ONLY attributes for single column come through to the hosted feature table. Everything else other than scientificName is blank. My fields are mapped correctly from python dictionary to Hosted Table.

 

With Python, I am trying to update all records in two AGO Hosted Tables using "feature_table.edit_features(adds=)".

My process is:

1. delete all features - feature_table.delete_features(where="1=1")
2. get the data prepared - list of dictionaries as below example
   
   

 

[{'attributes': {'lga': 'test',
   'scientificName': 'Acacia longifolia',
   'classificationLocal': 'Very High Priority',
   'localScientific': 'Acacia longifolia'}},
 {'attributes': {'lga': 'test',
   'scientificName': 'Amaryllis belladonna',
   'classificationLocal': 'High Priority',
   'localScientific': 'Amaryllis belladonna'}}]

 

• Add the list to the Hosted table
  I get all success, no errors.

 

{'addResults': [{'objectId': 1016,
   'uniqueId': 1016,
   'globalId': '2E655834-2E92-4A57-8F8B-2697122C1DE6',
   'success': True},
  {'objectId': 1017,
   'uniqueId': 1017,
   'globalId': 'F09D7D37-98A9-4364-9D9F-35CC8151FA9E',
   'success': True}],
 'updateResults': [],
 'deleteResults': []}​

 

• ISSUE: only Scientific name data comes through... other fields are blank.
  This same issue happens on two tables i.e. scientific name comes through, everything else blank. It doesn't matter if I do all records or just a subset (two in the examples below).
  

   

Extra info... Hosted Table fields:

{'OBJECTID': 0, 'scientificName': 1, 'lga': 2, 'classificationLocal': 3, 'localScientific': 4, 'GlobalID': 5}
{'OBJECTID': 0, 'scientificName': 1, 'lga': 2, 'classificationLocal': 3, 'localScientific': 4, 'GlobalID': 5}
{'OBJECTID': 0, 'scientificName': 1, 'commonName': 2, 'wons': 3, 'waStateDeclared': 4, 'qldStateDeclared': 5, 'nswStateDeclared': 6, 'vicStateDeclared': 7, 'saStateDeclared': 8, 'ntStateDeclared': 9, 'GlobalID': 10}

 

any ideas? I can't figure out what is going wrong here.

Thanks,

Nathan

 

nate0102

Hi @JakeSkinner, thank you for your response. 

I first read in my data from SQL db as a Pandas Dataframe:

Then iterate through the rows to create the list of dictionaries (the edits). 

# Prepare the data to be added to the lookup table by iterating through dataframe rows
lookup_lga_class_data = []
for index, row in df_arcade_lookup_lga_class.iterrows():
    lookup_lga_class_data.append({
        "attributes": {
            "lga": row["lga"],
            "scientificName": row["scientific_name"],
            "classificationLocal": row["classification_local"],
            "localScientific": row["local_scientific"]
            }
        })

lookup_pwd_data = []
for index, row in df_arcade_lookup_pwd.iterrows():
    lookup_pwd_data.append({
        "attributes": {
            "commonName": row["common_name"],
            "scientificName": row["scientific_name"],
            "wons": row["wons"],
            "waStateDeclared": row["wa_state_declared"],
            'qldStateDeclared': None,
            'nswStateDeclared': None,
            'vicStateDeclared': None
            }
        })

# test to make sure dictionary has populated correctly (it does).
lookup_lga_class_data[:2]
lookup_pwd_data[:2]

# delete the existing features
ft_lookup_lga_class.delete_features(where="1=1")

# add the edits
ft_lookup_pwd.edit_features(adds=lookup_pwd_data)
ft_lookup_lga_class.edit_features(adds=lookup_lga_class_data)

The main difference I can see between our code is that I edit_features in one line by adding the whole list in, instead of a for loop.

Thanks again for your time.

Nathan