I am trying to implement a program for automated updates on Feature Service hosted on AGO. A hosted map on AGO will display those updates. I am not sure if AGO supports that scenario.
I have a local SQL database that stores Road Statuses. I want to write a program (windows service, if possible) that will read those Road Statuses from a local database and update the Feature Service on the AGO. Then the AGO Map will change the color of a road based on its status.
So, my question is:
Is it possible to automate the scenario above utilizing AcrGIS APIs?
If yes, can you point which API I should use as a best practice.
Please share any related programming samples for ArcGIS Online, if available.
Thanks