topic Re: Auto-updating Feature Layers from cloud link? in ArcGIS Online Questions

Auto-updating Feature Layers from cloud link?

JohanScheller — Mon, 26 Feb 2018 13:13:56 GMT

Hi!

With ArcGIS online, I can create a Hosted Feature Layer based on a table file in my cloud account. I can also overwrite that Feature Layer manually, which allows me to update my maps with the most recent data. Instead, I would like to overwrite that layer every 30 minutes, so I can have "live" data in my connected apps, but this requires an automatic process of some sort. Are there any simple and free ways to do this?

Thank you,

Johan

Re: Auto-updating Feature Layers from cloud link?

JakeSkinner — Mon, 26 Feb 2018 13:32:32 GMT

Hi Johan,

Check out the following blog on how to do this using the ArcGIS API for Python:

Updating your hosted feature services with ArcGIS Pro and the ArcGIS API for Python | ArcGIS Blog

Re: Auto-updating Feature Layers from cloud link?

FranciscoRodriguez2 — Tue, 05 Jan 2021 13:08:58 GMT

Hey Johan,

What route did you end up going with to refresh your cloud based table? With the rise of Microsoft Flow and the ability to run flows on the cloud, I had a similar need to you relative to creating an automated way of refreshing this table data. Has anyone had any luck replicating this workflow using REST endpoint interactions using POST? I am trying to use a table that receives data updates to run the upsert function on another layer.

Re: Auto-updating Feature Layers from cloud link?

Anneka_France — Tue, 15 Feb 2022 08:59:37 GMT

@FranciscoRodriguez2 Did you ever find a workflow to update your cloud based table? I'd like to automatically update a .csv file in ArcGIS Online from Google Sheets or MS Excel Online so that I can use it as a lookup in Survey123.

Re: Auto-updating Feature Layers from cloud link?

Juan_Toro-Killion — Thu, 26 May 2022 16:36:37 GMT

Any movement on this front @Anneka_France ? I'm trying to do the exact same thing (using MS Excel Online in OneDrive).

Re: Auto-updating Feature Layers from cloud link?

Anneka_France — Fri, 27 May 2022 08:41:45 GMT

Not yet I'm afraid. We ended up setting up a python script that runs daily to update the .csv in ArcGIS Online. Not an ideal solution.