topic Re: @pulldata Query (Feature Service/Layer) in ArcGIS Survey123 Questions

@pulldata Query (Feature Service/Layer)

GaryBowles1 — Thu, 14 Mar 2024 14:32:24 GMT

I am trying to query a feature service using @pulldata in the calculate field. I am receiving the following error:

...:Couldn\'t understand the expression starting at this point: ...tStatistics=[{"\xcd\x8estatisticType":...

Here is the pulldata request:

pulldata("@layer", "getValue", "attributes.field1", "https://gis.srcx.com/server/rest/services/APPS/APPS_RUN_LOG_BINGHAM_MR/FeatureServer?outStatistics=[{"statisticType": "avg","onStatisticField": "field1","outStatisticFieldName": "field1_avg"}])

The feature service is the same one that the Survey points to.

Survey123 Connect 3.19

ArcGIS Enterprise 11.1

Thanks,

--gary

ZacharySutherby — Fri, 05 Apr 2024 23:31:33 GMT

The quotation marks in your outStatistics string is throwing off the URL string.

You'll need to use something like:

pulldata("@layer", "getValue", "attributes.field1", 'https://gis.srcx.com/server/rest/services/APPS/APPS_RUN_LOG_BINGHAM_MR/FeatureServer?outStatistics=[{"statisticType": "avg","onStatisticField": "field1","outStatisticFieldName": "field1_avg"}]')

GaryBowles1 — Sun, 07 Apr 2024 14:48:52 GMT

Thanks Zach I will give it a try and let you know what happens.

--gary