pulldata @layer returning no results

[susic]

I am attempting to pull data from a simple layer.  the Layer has 2 fields, "event_name", and "active".   I am trying to query the layer in the calculation field for a text question in Survey123 Connect 3.18 to return the event name that has the active field set as yes.  The layer is set to public.  

The question never pulls any data.  If the quotes are removed from around the yes, I recieved a message in the text box that yes is not defined.

pulldata("@layer", "getValue", "attributes.event_name", "https://services1.arcgis.com/YBWrN5qiESVpqi92/arcgis/rest/services/service_400a7c2583ae4a558c1c675e6...", active = "yes")

Any guidance would be appreciative.

[JodyZhengLiu]

Hi @susic ,

The "active = 'yes'" should be quoted as well:

pulldata("@layer", "getValue", "attributes.event_name", "https://services1.arcgis.com/YBWrN5qiESVpqi92/arcgis/rest/services/service_400a7c2583ae4a558c1c675e6...", "active = 'yes'")

Thanks,

Jody Zheng Liu

[susic]

Did not work, also attempted to change URL to the following;

https://services1.arcgis.com/YBWrN5qiESVpqi92/ArcGIS/rest/services/service_400a7c2583ae4a558c1c675e6...