topic Pulldata from hosted CSV in ArcGIS Survey123 Questions

Pulldata from hosted CSV

BenBlowers2 — Fri, 08 Oct 2021 15:01:11 GMT

Hi all,

I am trying to use pulldata to pull data from a linked CSV. I have managed to populate a select_one list dynamically with the linked CSV, but now I want to populate another answer based on values in the linked CSV.

This is the pulldata formula I have tried:

pulldata('https://services9.arcgis.com/HmEFp6x93FBcyUml/arcgis/rest/services/Jobs_Simplified/FeatureServer/0','SiteName','No',${job_name})

I don't get any errors, but it just doesn't work. Does anyone know why?

Thanks all,

Ben

Re: Pulldata from hosted CSV

AlfredBaldenweck — Fri, 08 Oct 2021 16:20:08 GMT

Maybe try using search() instead?
Dynamic Choice Lists using Search Appearance - Esri Community

What kind of question are you trying to populate? Depending on what you're trying to do, it might be easier to to set up a cascading select.

Would you be able to post a screenshot of your survey?

Re: Pulldata from hosted CSV

BenBlowers2 — Mon, 11 Oct 2021 07:22:28 GMT

Hi Alfred

It is just a "text" question I am trying to populate. Sure, please see attached screenshots.

BenBlowers2_0-1633936707674.png

BenBlowers2_1-1633936744792.png

BenBlowers2_2-1633936824812.png

Basically, I am using the search appearance to pull through the job names from a linked CSV, but then I want to use the pulldata CSV to pull through the corresponding job number, which is also stored in the CSV.

Thanks,

Ben

Re: Pulldata from hosted CSV

DougBrowning — Tue, 12 Oct 2021 16:32:43 GMT

This is not really linked content you are reading the service. This means needing to be online.

I would change to use linked content. Then you just reference them like any other CSV (just like from the media folder) but the CSV is central on AGOL and gets updates. It is hosted but downloads to the tablet. What you have goes to the internet every time.

Hope that makes sense. Check out https://community.esri.com/t5/arcgis-survey123-questions/can-a-linked-csv-file-on-agol-be-automatically/td-p/1006119

Re: Pulldata from hosted CSV

AlfredBaldenweck — Tue, 12 Oct 2021 16:36:37 GMT

Something else I noticed that might be causing issues is that your CSV doesn't have a set of "name" and "label" columns. I think pulldata() requires both to work, while search() appears to only care about the columns you specify.