Hi Daniel Fenton,
I have indeed uploaded a table as a CSV directly ArcGIS Online and I recognize that I can replace this item in order to update it with an updated source file. However, much of our data is sensor data or data that we would like to keep up to date on a daily basis. Therefore, my goal with this post was to seek out alternatives to would allow us to keep our data near real time without manually updating this information as it would be very labour intensive.
With all of our other open data that has a spatial context we've been using FME to publish directly to the ArcGIS Online feature service. Ideally I would like to be able to do something very similar.
When I did upload my CSV to ArcGIS Online I had it create a hosted table as well, would it not be possible to interact with the hosted table since it seems to have all the features of a feature service when I view the REST endpoint?
I appreciate your suggestions,
Warren