topic Re: Update CSV linked to Surveys via script in ArcGIS Survey123 Questions

Update CSV linked to Surveys via script

DuncanC — Mon, 19 Aug 2024 19:16:19 GMT

I want to automate the updating of the CSV files my surveys use. But I cannot find a way to do the equivalent of pushing update data button in the online portal via script. Using either the REST interface directly or the python SDK I can download the CSV, but I can't find a method to replace it with new data.

I could delete it, and upload a new copy, but that will have a new ID and I'm pretty certain it's not going to be linked to my surveys. I've looked into adding a link to the new ID as linked content on the surveys via python, but that also looks to be a dead end and not available.

Hoping I'm just missing something and there is a way to do this. Any advice would be greatly appreciated.

Betreff: Update CSV linked to Surveys via script

HannesVogel — Mon, 19 Aug 2024 19:33:32 GMT

Hi @DuncanC

my colleague is using FME Flow - maybe here is a good starting point: https://community.esri.com/t5/arcgis-data-interoperability-blog/how-fme-flow-or-form-can-write-to-arcgis/ba-p/1218381

Betreff: Update CSV linked to Surveys via script

DuncanC — Mon, 19 Aug 2024 19:52:25 GMT

Thanks for the suggestion.

I should have mentioned I'm using AGOL not a enterprise install so I don't think that solution works.

Betreff: Update CSV linked to Surveys via script

HannesVogel — Mon, 19 Aug 2024 20:10:31 GMT

if you have the FME possibility there is an AGOL connector as well: https://support.safe.com/hc/en-us/articles/25407563623565-How-to-use-the-EsriArcGISOnlineConnector

Betreff: Update CSV linked to Surveys via script

DuncanC — Mon, 19 Aug 2024 20:26:05 GMT

I'm not interested in the FME part, but if their connector can do what it claims it give me hope that what I want is indeed possible, I just need to find the correct REST endpoint.

Re: Update CSV linked to Surveys via script

AmeWunderle — Mon, 19 Aug 2024 21:50:06 GMT

Hi Duncan,

I run a daily python script to update a csv that I reference in one of my surveys in Survey123. I also only use AGOL not enterprise.

The steps I follow are:

1. re-create the csv locally exactly how it is in AGOL so that you can use the update method on the csv in AGOL

2. run the following script

import datetime

from arcgis import GIS

from arcgis import features

from arcgis.features import FeatureLayerCollection

import datetime

import sys

# Connect to the GIS

gis = GIS(profile="") # Your profile name

token = gis._con.token

# set variables and access json

portalUrl = "https://www.arcgis.com"

csvID = "" # the id number of your csv

csv_item_title = "" # the title of your csv

localfile = "" # the local path to your file you wish to replace the csv with

currentdate = datetime.date.today()

# set log file for data logging

fp = open("","a") # set up a log file as this is never a bad idea

# Query to see if item exists

print ("...Searching for feature service...")

the_services = gis.content.search(query = 'title:' + csv_item_title + " AND " + 'id:' + csvID)

if len(the_services)!=1:

print("Couldn't find feature service" + csv_item_title+ " in AGOL. Exiting script")

error_message = currentdate.strftime("%Y/%m/%d")+','+'csv not found\n'

fp.write(error_message)

fp.close()

sys.exit()

print ("....found feature service " + csv_item_title+ " in AGOL")

#Update CSV Table in AGOL from local CSV file

fs = gis.content.get(csvID)

try:

fs.update(data=localfile)

print (".....updating csv file in AGOL")

except:

error_message = currentdate.strftime("%Y/%m/%d")+','+'update in AGOL not successful\n'

print ("..error in updating csv file. Exiting script")

fp.write(error_message)

fp.close()

sys.exit()

# write the success to the log file

message = currentdate.strftime("%Y/%m/%d")+','+'Yes\n'

fp.write(message)

fp.close()

print("Script successful")

Re: Update CSV linked to Surveys via script

DuncanC — Tue, 20 Aug 2024 02:33:43 GMT

Thank you very much!! Not sure how I missed that earlier today but your script helped me find the update method I need.

https://developers.arcgis.com/python/api-reference/arcgis.gis.toc.html#arcgis.gis.Item.update

Re: Update CSV linked to Surveys via script

ChallagundlaSindhuraITS — Thu, 11 Jun 2026 18:43:34 GMT

Hi, How can i get the csvID? csvID = "" # the id number of your csv

Re: Update CSV linked to Surveys via script

AmeWunderle — Thu, 11 Jun 2026 23:56:30 GMT

Hi there,

The csvID in the script is simply referring to the item id of the csv. There are a couple of ways to find it, but generally I go to the information page of the item, and grab the id from the URL or you can copy the Item ID directly from the Overview. It's listed under Details on the right hand side.

Re: Update CSV linked to Surveys via script

ChallagundlaSindhuraITS — Fri, 12 Jun 2026 12:38:34 GMT

Hi, Thnak You for the reply! Somehow i am not able to find it. Here is my scenario: The Survey123 form is created by other user(He is the owner of the form, but have given me permissions to edit and all). I sent the user csv file everyday. The user grabs the csv file puts in the media folder, and clicks the publish button on the Arcgis Survey123 connect. My job is to automate the process using .py script. if i try to grab the ID from the form URL and see its type it says its not the type CSV. I even tried searching with the CSV file name , but no luck. Please advice! Thanks

Re: Update CSV linked to Surveys via script

ChallagundlaSindhuraITS — Fri, 12 Jun 2026 12:52:30 GMT

It looks like the CSV is not saved as Item

Re: Update CSV linked to Surveys via script

AmeWunderle — Fri, 12 Jun 2026 16:02:55 GMT

You will need to upload the csv to AGOL as content (share to your org or group that your author is a part of), and your survey author should then link it directly to the survey in survey123 connect. That will make it a proper csv item and you can update it daily. When users open the survey, it will download the most recent version from AGOL.