@pulldata Query (Feature Service/Layer)

[GaryBowles1]

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]

Hello @GaryBowles1, 

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

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"}])

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]

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

--gary