Updating a hosted csv linked to Survey123

[Iron_Mark]

Hi,

I need to use pulldata for my survey to retrieve multiple columns of a spreadsheet.

Everything works correctly: the csv is hosted online and linked to the form.

Question is: how can I delegate somebody to update it instead of me? I am the administrator and I have data editor users (mobile workers) and viewers. I see that there are publisher roles but I don't want to ask the company to buy it only to add few rows on a spreadsheet from time to time (The department using the form need to update the spreadsheet and want to deal with it themself).

Is there any other way to update a csv file having mobile worker users and viewers? Or maybe setting like an automatic method of external update like python or something?

[DougBrowning]

I think this is it.

https://github.com/Esri/Survey123-tools/tree/main/Update_CSV_Item 

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

Hope the helps

[Iron_Mark]

This seems to be the way to go, unfortunately I am not having success to make it work.

Have you already tried it? Are you able to guide me on how to use this notebook? Never had to use one before.

Thanks

[DougBrowning]

No sorry never used notebooks always regular scripts.  You should be able to use the code in Python stand alone though.  Usually it is a login issue. easiest way is to have Pro logged in then call gis = GIS('pro') at the top of the script.