topic Re: Pulldata not auto populating @json results in ArcGIS Survey123 Questions

Pulldata not auto populating @json results

JoshOsowiecki — Mon, 20 Jun 2022 14:30:02 GMT

I am creating a follow-up survey for our program and when viewing our data in the Survey123 dashboard it will be helpful to have the county of our program participants.

I have used the string(pulldata("@json",${address})) calculation to populate the extractable features from the geocode source. The properties I would like to extract are "Subregion" (in our case will be used to represent county since the @json does not populate the county) and "City".

When I update the Survey I do not get any error messages, the fields of Subregion and City that I want to auto populate do not auto populate they are left blank. The calculation I am using to auto populate is below:
pulldata("@json",${address_json},"Subregion")

I have tried many different variants of the calculation and am still unable to get the field to auto populate.

I have attached photos of the rows in my sheet I am having trouble with as well as the json pulldata results.

Re: Pulldata not auto populating @json results

IsmaelChivite — Mon, 20 Jun 2022 15:50:17 GMT

Hi. Add attributes. as a prefix and life will be good!

Re: Pulldata not auto populating @json results

JoshOsowiecki — Mon, 20 Jun 2022 17:06:16 GMT

@IsmaelChivite Thank you!! This worked perfectly!

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Wed, 05 Mar 2025 18:54:14 GMT

@IsmaelChivite I am having a similar problem. I have my json response but I am unable to populate my calculate with my pulldata.. I tried "macAddress.lastData.tempf" , "lastData.tempf" and just "tempf" none of them will caculate.

using pulldata("@json", ${weather_json}, "macAddress.lastData.tempf")

attached is a screenshot of my json response.

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Wed, 26 Mar 2025 12:33:44 GMT

@ChrisLeSueur if you need me to include anything else, please let me know.

Re: Pulldata not auto populating @json results

JamesTedrick — Mon, 31 Mar 2025 16:05:41 GMT

Hi @jeffhyderBRVA - the JSON you provided begins as an array ([]), not an object ({}). You need to address the first element of the array ([0]):

pulldata("@json", ${weather_json}, "[0].macAddress.lastData.tempf")

I'm guessing you're using a JavaScript function to retrieve this information - as an alternative modify the function to return the first (or another) element as opposed to the entire array.

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Tue, 29 Apr 2025 18:28:02 GMT

Deleted

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Fri, 25 Apr 2025 20:16:53 GMT

deleted

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Mon, 28 Apr 2025 15:01:28 GMT

deleted

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Mon, 28 Apr 2025 15:34:48 GMT

I forgot to tag you @JamesTedrick

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Tue, 29 Apr 2025 11:43:52 GMT

I appreciate your assistance but for some reason this still will not work.

pulldata("@json", ${weather_json}, "[0].macAddress.lastData.tempf")

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Tue, 29 Apr 2025 13:24:58 GMT

@JamesTedrick

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Tue, 29 Apr 2025 18:28:36 GMT

After months of beating my head against the wall, I finally got it figured out.

pulldata("@json", ${weather_json}, "[0].lastData.tempf")

This is what worked.

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Thu, 01 May 2025 14:33:47 GMT

@ChrisLeSueur @IsmaelChivite @JamesTedrick

Ok, after thinking I had this figured out. I get hit in the head, again. Everything works correctly in the test environment of Survey123 Connect meaning all my pulldata calculations populate. Everything publishes correctly. But when a survey is submitted it doesn't have any of the data from the pulldata fields there is also no data being populated in my excel file for the survey. What is the problem? What can I do to fix this? Please, I beg of you and for the love of all humanity please help me.

Re: Pulldata not auto populating @json results

jeffhyderBRVA — Thu, 08 May 2025 13:18:55 GMT

@ChrisLeSueur @IsmaelChivite @JamesTedrick

The pulldata function works and populates my fields if the survey is completed with the app but doesn't populate the fields if the survey was submitted using a browser. This is a public survey and participation will greatly decline if the end use has to install an application.