I'm using the pulldata calculation in Survey123 Connect to populate a form with the lower and single tier municipality of the geopoint question in my survey, ${test_loc}.
I'm using the publicly available layer from my organization: https://ws.lioservices.lrc.gov.on.ca/arcgis2/rest/services/LIO_OPEN_DATA/LIO_Open03/MapServer/14
In my XLSX form, the calculation field is filled with the following text to grab the municipal name short form from that layer:
pulldata("@layer", "getValueAt", "attributes.MUNICIPAL_NAME_SHORTFORM", "https://ws.lioservices.lrc.gov.on.ca/arcgis2/rest/services/LIO_OPEN_DATA/LIO_Open03/MapServer/14", ${test_loc})
However, something strange is happening. If I place my geopoint in, say, Pembroke Ontario, the field gets filled: "PEMBROKE". If I put my geopoint in Peterborough Ontario, the field remains empty.
What's going on here? Peterborough and Pembroke both have very similar looking entries in that layer, and the layer has queries enabled...
Thanks for any hints you might have.