Looking for the reverse geocode value to use in XLS

ÉmilieLamontagne

Hi, I tried multiple reverse geocode value(pulldata("@geopoint",${location},"reversegeocode"), pulldata("@geopoint",${location},"reversegeocode.address.Match_addr") in the Calculate field of my xls form, but there are I get no adresses or error message. 

Anyone knows what would be the value to use ?

Thank you very much 

IsmaelChivite

Hi, I suggest you read https://community.esri.com/groups/survey123/blog/2018/07/06/understanding-reverse-geocoding-in-survey123-30 in detail.  In practice, every locator  is different and the response uses different properties. .The key is to understand what the response looks like so you can execute your pulldata function on the right property.

The easiest way to look at the response is to simply use

pulldata("@geopoint",${location},"reversegeocode")

in the calculation of a text question. Make sure  you  make the appearance multiline  and also set the esriFieldLength column to a crazy large number such as 20000.  This is so the JSON response can fit within your text  question.  While in Connect  you can test  your survey and copy the JSON response for further analysis. I like to use https://jsonformatter.curiousconcept.com/  to make the JSON look friendly.

Again, great  info in Claire's blog post above.