We have numerous feature services in ArcGIS Online and would like to create backup copies of the data so that it can be restored in the event a user deletes something they decide they shouldn't have (or didn't mean to). We did have python scripts setup that successfully downloaded a feature service as a .zip file, would extract the data and save it as a Feature Class in a GDB, and these were called nightly by task scheduler. BUT, after our organization shifted to cloud based server infrastructure, the task scheduler component decided to fail.
So I'm looking for an alternative. Can someone point me in the right direction based on what I would like to achieve below:
- Use Power Automate to regularly call a python script that accesses a feature service and saves the data to an Azure location (Data Lake? Data Warehouse? Blob?)
- Be able to access this data in ArcGIS Pro for retrieving features and appending back into the original feature service (I don't know if this is possible with Vector data - I keep finding references to cloud/Azure connections only working for Raster data)
- If dynamic data access isn't an option, then maybe saving the "downloaded" feature service as a feature class in a GDB and then in a .zip which is deposited into a folder on Sharepoint (therefore making it easy to download a .zip, extract the GDB and load into ArcGIS Pro)?
Open to other suggestions on how to make this all work in an automated manner.
NOTE: We are NOT running ArcGIS Enterprise.
