Latest Contributions by AndrewKesterton

Hi Geonet community,  I am trying to use the Python API in Jupyter Notebook to test the availabilit of ArcGIS Server feature services. When a service is inaccessible an error message in pink is output from the notebook cell, but no exception is raised. I would like to capture these issues to use elsewhere, is there a way to capture either the error outputs from the cell, or have the API raise an exception?  Thanks Andrew   ... View more

Hi dashboard community,  I'm trying out Arcade data expressions in ArcGIS Enterprise 10.9.1 (so Arcade 1.15).  When looking for statistics/summary values with the GroupBy function on a non-hosted feature layer, the data expression doesn't seem to parse the results of the statistics.         var portal = Portal('https://myportalurl/portal'); var fs = FeatureSetByPortalItem( portal, 'b10d26459a3e415f856a8310da14accc', 1, [ 'parentrowid', 'quantity' ], false ); return GroupBy(fs, ['parentrowid'], [{name: 'count_features', expression: 'quantity', statistic: 'SUM' }]);         Returns: The same data expression against a hosted feature layer works correctly.  The feature layers support statistics, and I see them returned correctly by the rest service, but they dont appear in my expression.  Is there a known limitation using Arcade with these feature services?  Thanks, Andrew  ... View more

Hi Survey123 community,  Has anyone else experienced this error since upgrading to 10.9.1?  We are using Survey 123 with Feature Services in Portal, against an enterprise geodatabase (not hosted).  Our users are encountering an intermittent error when refreshing the inbox, that survey 123 is unable to retrieve related records.  The feature service is working correctly, and we can query the relationship for the desired objectid's fine using the rest API.  When looking at the Survey123 logs it seems to be mixing up the relationship id's and querying the wrong relationship - because the query contains attributes that don't exist in the other relationship, the query fails with error 400.  Republishing the Survey123 form with the most recent Survey123 Connect seems to resolve the issue. The Survey123 field app log shows; <10>1 2022-02-15T13:13:18Z L999 ArcGISSurvey123 18372 - [AppStudio@11205 category="PortalRequest" function="onFailed" filename="PortalRequest.qml" line="116"] PortalRequest: PortalRequest failed url: https://myportal.org/server/rest/services/myservice/FeatureServer/1/queryRelatedRecords error: { "code": 400, "details": [], "extendedCode": -2147467259, "message": "Unable to complete operation." and when we look at the query being constructed, it is building a query to the wrong relationship vs the feature service. That relationshipId is for another layer, that doesn't contain the same attributes.  If I submit the same query against the feature service, for the wrong relationshipId I get the same error as Survey123.  <15>1 2022-02-15T13:13:18Z L489 ArcGISSurvey123 18372 - [AppStudio@11205 category="SurveyFolderPageInbox" function="addRelatedQueries" filename="SurveyFolderPageInbox.qml" line="711"] SurveyFolderPageInbox: relatedQueries: 3 <15>1 2022-02-15T13:13:18Z L489 ArcGISSurvey123 18372 - [AppStudio@11205 category="PortalRequest" function="next" filename="SurveyFolderPageInbox.qml" line="456"] PortalRequest: related query body: { "objectIds": "5602,5603,5604,5605", "relationshipId": 3, "outFields": "objectid,globalid,last_edited_date,last_edited_user,created_date,created_user,activity_task_id,activity_id_points,task_point_label,parentrowid", "outSR": 4326, "returnGeometry": true, "returnZ": true, "returnM": false ...  Looking at the feature service page, the attributes in bold belong to a different relationship (in this case it's relationshipId 4).  The relationships section of the feature layer; "relationships": [ { "id": 2, "name": "activity_polylines", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "uniquerowid", "composite": true }, { "id": 3, "name": "activity_polygons", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "uniquerowid", "composite": true }, { "id": 4, "name": "activity_points", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "uniquerowid", "composite": true }, { "id": 0, "name": "tasks", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "parentrowid", "composite": true } Appreciate any tips on how to avoid this happening, as it isn't ideal to republish and re-download the survey when it occurs.   We are publishing using connect version 3.13.251, and field app 3.13.246.  The surveys were originally published some time ago with an older version of connect, and it seems republishing them with the latest version (following the portal upgrade) corrects the issue.  Thanks, Andrew  ... View more

Thanks for adding support for file attachments in surveys 🙂  Of course this leads to other ideas..  Is it possible to use or access the contents of an attached file within the Survey? Either through a calculation, or I guess more likely in a pulldata javascript function?      I have a file question in my survey, and when referring to it in calculation only the file name + i guess its internal item id is returned.  Before I pursue other options to parse the files after submission, i just wondered if there was a way to do so in the survey?  I'm thinking along the lines of validating a CSV using Javascript and using some of the content to populate repeat questions.  Thanks Andrew ... View more