I'm working in AGOL, trying to use the relatively new "Append Data to Layer" tool under the "Update Data" section in the Overview tab of a hosted feature layer to add new data to my hosted feature layer. I have previously used this function to batch append multiple new entries to a point layer, using a zipped file geodatabase, and it was pretty slick. Now I want to "upsert" additional data collected at each of these locations, i.e. add new data to existing features, instead of adding new features. I added fields to my existing database in AGOL, but when I try to "update existing features" using a compressed file geodatabase, I get the following error message: "Error: object reference not set to an instance of an object."
If I use a CSV file, the upsert works, but since one of the new data fields includes comments with commas, I don't want to incorporate this into our workflow going forward.
If I use a compressed Shapefile, the upsert also works, but due to the character limit in shapefile field names, field matching during the Append Data process takes extra work, so again, I'd like to avoid putting this into the permanent workflow if possible.
Any advice for how to get upserts to work with a compressed file geodatabase in AGOL? I have an AGOL Basic license.
I'm matching "ObjectID" to "ObjectID_Orig," a field I created to ensure the unique identifiers were tying the new data to the existing data like I wanted them to. I've checked the area extents and projection. All the settings in the file geodatabase that I've compressed look identical to the one that I successfully used to append new features last week, just with a couple dozen new fields. I referred to an ESRI blog post when getting started with this function, but it's not much help now that I'm troubleshooting. (What’s new with hosted feature layers: Getting to know Append, Part 2 | ArcGIS Blog)