Hey All,
I have successfully implemented this line to pull data from the geopoint 'point_location' field, and insert JSON code into a second Survey123 Field:
pulldata("@geopoint",${point_location},"reversegeocode")<SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>An example of data returned is:
<SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"address"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"Match_addr"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"517 Logan Rd, North Albury, New South Wales, 2640"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"LongLabel"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"517 Logan Rd, North Albury, New South Wales, 2640, AUS"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"ShortLabel"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"517 Logan Rd"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Addr_type"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"PointAddress"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Type"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"PlaceName"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"AddNum"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"517"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Address"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"517 Logan Rd"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Block"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Sector"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Neighborhood"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"North Albury"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"District"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"City"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"Albury"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"MetroArea"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Subregion"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Region"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"New South Wales"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Territory"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"Postal"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"2640"</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"PostalExt"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"CountryCode"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="string token">"AUS"</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"location"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"x"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">146.92148550000002</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"y"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">36.056655</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"spatialReference"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">{</SPAN>
<SPAN class="string token">"wkid"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">,</SPAN>
<SPAN class="string token">"latestWkid"</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4326</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>This is fantastic, as the data is correct. I am now wondering how do I ask the survey to only return the match_addr attribute into this column, and in another column I want to store the X and Y values.
I unsuccessfully tried this in the calculation field of my survey:
pulldata("@geopoint",${point_location},"Match_Addr")<SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>I know im doing it wrong, but unsure how to fix it. I have found this site, the very bottom two paragraphs give me a hint, but I need an example to help me.
Any ideas?