topic Re: Automatically updating a csv based on a Survey123 Form in ArcGIS Survey123 Questions

Automatically updating a csv based on a Survey123 Form

AlexanderDyer — Fri, 05 Apr 2024 15:23:01 GMT

Hi everyone,

I'm wondering if it's possible to link a csv file on a shared drive to a hosted feature layer on AGOL that is updated by a Survey123 form, so each time the feature layer is updated the data is automatically reflected on the csv.

From what I've gathered, this is possible through webhooks (?), but I don't know where to start with building one. Any advice would be appreciated.

Thank you!

Re: Automatically updating a csv based on a Survey123 Form

DougBrowning — Fri, 05 Apr 2024 16:06:56 GMT

You can link to a CSV that is hosted in AGOL that the form will update from when opening. You can then use Python or manual update of that CSV in AGOL.

Take a look at these posts

https://community.esri.com/t5/arcgis-survey123-blog/work-with-csv-data-in-arcgis-survey123/ba-p/1157642

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-external-choice/ba-p/1055534

You could also look into the search() appearance type but that assumes you are online when loading the form. https://community.esri.com/t5/arcgis-survey123-blog/dynamic-choice-lists-using-search-appearance/ba-p/1060838

Hope that helps

Re: Automatically updating a csv based on a Survey123 Form

RobertAnderson3 — Fri, 05 Apr 2024 16:19:51 GMT

Are you looking to use the CSV with the Survey123 form, or just have it update from information that is submitted to the survey?

Re: Automatically updating a csv based on a Survey123 Form

AlexanderDyer — Fri, 05 Apr 2024 17:30:35 GMT

Just have it update from the information that is submitted.

Re: Automatically updating a csv based on a Survey123 Form

AlexanderDyer — Fri, 05 Apr 2024 17:42:26 GMT

Thank you for the info Doug, but I think I may have worded my question badly... I'm not trying to link a Survey123 form to a csv, but rather link the data that is created from a Survey123 form to a csv file saved externally.

Re: Automatically updating a csv based on a Survey123 Form

RobertAnderson3 — Fri, 05 Apr 2024 17:48:14 GMT

I think a webhook would likely be your best bet then, if you have access to Power Automate through Microsoft 365 at your organization I'd recommend it, or there's also Make (formerly Integromat) that I believe is free?

Make with Survey123 Blog Post

Power Automate with Survey123 Blog Post

Those should be good to get started, but there's a whole lot of posts and blogs across the Community on these topics (more so Power Automate I find).

Re: Automatically updating a csv based on a Survey123 Form

DougBrowning — Fri, 05 Apr 2024 17:55:22 GMT

If you looked at ArcGIS for Excel? You can just point Excel to AGOL and it would all be live time.

Re: Automatically updating a csv based on a Survey123 Form

RobertAnderson3 — Fri, 05 Apr 2024 18:06:35 GMT

Also a good idea, and probably easier than the webhooks to set up (I've not used it before though).

Re: Automatically updating a csv based on a Survey123 Form

AlexanderDyer — Fri, 05 Apr 2024 19:06:45 GMT

Thanks for the input y'all! I can't add ArcGIS for Excel due to add-in permissions at my organization, but I was able to make something work well enough by using Power Automate to add rows to an excel file on sharepoint each time the Survey123 Form is submitted.

Re: Automatically updating a csv based on a Survey123 Form

DougBrowning — Mon, 08 Apr 2024 20:18:52 GMT

My IT said that same at first but then they agreed to have it as a Managed Add-In with the org. May be worth a shot.

Re: Automatically updating a csv based on a Survey123 Form

DuncanC — Mon, 19 Aug 2024 19:13:06 GMT

You have any details on how to update that linked CSV via Python? Seems like functionality that should be available, but I'm not finding a way to actually do it.

Re: Automatically updating a csv based on a Survey123 Form

DougBrowning — Mon, 19 Aug 2024 21:33:48 GMT

This is all I have seen I think. Few other posts on the forum too. https://community.esri.com/t5/arcgis-survey123-questions/updating-a-hosted-csv-linked-to-survey123/m-p/1241498