Hi,
I am having a challenging time trying to write a code using the ArcGIS Python API in Notebooks to update or overwrite an existing hosted table with new data obtained via a Survey123 form. The ultimate goal will be to set this to update automatically at regular intervals.
I have tried to resolve using similar previous posts (e.g. Overwrite Hosted Table), but to no avail.
My initial steps were to run my analysis code and add the output table as a CSV to my organisational AGOL account, which I then manually published as a Hosted Table. However, when I run the below steps, the output messages appears to be fine, but when I go to check the hosted table data in my 'Content', it has not updated. Code is in the image, below:
As additional context:
- Given my analysis is all scripted, the hosted table name, properties and schema are remain the same.
- Code runs ALL Survey123 data each time, rather than just those new records submitted since last run (there's are <1000 records).
Any assistance would be much appreciated as I am still relatively new to Notebooks and python language. Happy to include additional information if needed.
Thanks!!