topic Pulldata From Linked csv Not Working in ArcGIS Survey123 Questions

Pulldata From Linked csv Not Working

JoshHabel — Thu, 14 Apr 2022 14:10:06 GMT

Hello,

I am having trouble with the Pulldata function when trying to work with a agol hosted csv file. My goal is to use a Pulldata function to do a lookup on a hosted csv file using the devices "deviceid" to return the users name and possibly additional info in the future. My formula pulldata('myusers', 'users', 'devices', ${ms_deviceid}) appears correct from what i can tell but it does not return anything. I've attached my test survey and csv file that i'm working with.

PS The reason i'm trying to grab the user name this way instead of using the username field is that not all my users will have a esri login. This will be a publicly shared survey.

Josh

Re: Pulldata From Linked csv Not Working

EricaLynn — Thu, 14 Apr 2022 15:47:13 GMT

I was just about to post a very similar question. I have been trying all week with same formula with no success. I'm glad you asked.

Re: Pulldata From Linked csv Not Working

abureaux — Thu, 14 Apr 2022 19:56:22 GMT

I believe you have 'users' and 'devices' backwards:

pulldata('myusers', 'devices', 'users', ${ms_deviceid})

Re: Pulldata From Linked csv Not Working

JoshHabel — Mon, 18 Apr 2022 18:02:12 GMT

Hey thanks that worked! I thought it didn't at first because it still fails in Survey123 Connect but once i tried it in the field app it worked as expected.

Josh

Re: Pulldata From Linked csv Not Working

RENDANIMUDAU — Mon, 06 Nov 2023 10:08:45 GMT

Good day.

This is helpful. I am struggling to assign questions based on the user roles or usernames in ArcGIS survey 123 connect. do you perhaps have an example of the XLSforms? maivha2006@gmail.com