Hello all,
First time posting so please feel free to redirect/clarify/suggest revisions!
I am trying to develop an easy workflow for the non-GIS folks in my office to update the attributes of a layer used in a Web Map (and subsequently a Web App). My intention is that end users will be able to make edits to text, add hyperlinks, and include attachments for formatted display in the Web App pop-ups, all by editing a source spreadsheet and then pushing those changes to the hosted layer - I am formatting the pop-ups and symbology, and want them to be able to seamlessly update the content of the attributes. I am seeking guidance in determining the most effective, user-friendly way to do this.
If possible, I would prefer to avoid changing the schema or anything else major (e.g. field names) about the layer and its attribute table - I do not want the settings I am implementing for symbology and pop-up formatting to need correcting after the changes are made. If I understand correctly, this rules out using joins via ArcGIS Pro (please correct me if not!).
So far I am considering:
1) Writing a script using ArcGIS API for Python, to attempt to directly edit the hosted layer attributes;
2) Writing a script to make the edits locally, e.g. using an Update Cursor, and then including instructions to overwrite the Web Feature Layer with the updated layer;
3) Setting up a ModelBuilder workflow that involves using the source data table with Joins, Calculate Fields, and other tools (e.g. Add Attachments).
Currently I have ArcGIS Pro set up with a map that pulls the live Web Feature Layer, so I can make edits through Pro (but I don't know how - or if it's even possible - to use scripts i.e. with an update cursor on a hosted layer).
Any suggestions re: which approach would likely offer the least resistance for end users, any other workflows not already under consideration, and/or specific references for coding the script-based approaches (especially the API one) are so gratefully accepted!
The interactions between Pro and AGOL, along with all the different options for hosting and editing (service definitions, web feature layers, etc.) are at the limits of my understanding so any and all context is appreciated!
Thanks in advance.
