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.
@LindsayRaabe_FPCWA - I know this post was from quite a while ago, but I am going through the posts on this forum and thought I would reach out. I am not entirely sure how helpful the ArcGIS Connector for Power Automate would be in this request as the connector acts as means to communicate with your organization's feature layers. There are other actions that are included (such as geocoding, etc.) which won't apply.
However, you can create a webhook on your feature layer whenever a record or attachment is created, updated, or deleted, and then create a flow based on that action.
Please let me know if you need any other additional information or if you were able to come up with a solution.