Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys

BrendonJoyce1 — Wed, 27 Sep 2023 12:11:07 GMT

Good morning all, making another post similar to here: Previous Post

Trying to use a custom connector with Portal to create reports, upload to OneDrive, and email/notify upon survey submission. This works great on a public survey, but is not working on internal/non-public surveys. Is this a limitation of the custom connector or Power Automate/Esri for non-public surveys?

I cannot use HTTP due to IT/Data loss policies.

Error on run:

{ "error": { "message": "Layer specified by featureLayerUrl does not exist or is not accessible.invalid json response body at https://maps.xxxxx.com/portal/sharing/rest/info reason: Unexpected token < in JSON at position 0", "code": "102", "details": [ "invalid json response body at https://maps.xxxxx.com/portal/sharing/rest/info reason: Unexpected token < in JSON at position 0" ] }, "success": false

Raw Inputs:

{ "host": { "connectionReferenceName": "shared_arcgis-20enterprise-20connector-5ff9xxxxxx-xxxxxxxx", "operationId": "FeatureReportSubmitJob" }, "parameters": { "createFeatureReportBody/surveyItemId": "xxxxxxxxxxxx65718d82fa57afb", "createFeatureReportBody/featureLayerUrl": "https://maps.xxxxxx.com/arcgis/rest/services/Hosted/service_xxxx4ffb69c4d689649c40ea94788da/FeatureServer/0", "createFeatureReportBody/templateItemId": "https://maps.xxxxx.com/portal/home/item.html?id=xxxxxxd13bc068200285d6f3d", "createFeatureReportBody/queryParameters/objectIds": 14, "createFeatureReportBody/outputReportName": "4 Main St Fire Station", "createFeatureReportBody/outputFormat": "pdf" } }

It can even see the data being submitted like the report name and data inside, but it will not create the report and allow it to be uploaded to OneDrive - Again works flawlessly on a public survey.

At this point it seems as though there is a limitation on this custom connector... Any input is appreciated, thanks!

Re: Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys

ZacharySutherby — Mon, 01 Jul 2024 14:01:32 GMT

Hello @BrendonJoyce1,

Is https://maps.xyzxyz.com/arcgis/rest/services accessible on an external network without VPN? If so are you able to generate reports through the Survey123 website for the non-public surveys?

Re: Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys

BrendonJoyce1 — Thu, 28 Sep 2023 11:09:29 GMT

Hi @ZacharySutherby

It appears I can open this directory without login, and it only shows the public facing layers as it should:

As for the non-public surveys - yes I can create reports through S123 Portal site - This is my workflow now, to manually do this.

Thanks,

Brendon

topic Re: Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys in ArcGIS Survey123 Questions

Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys

Re: Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys

Re: Survey123 Enterprise custom connector in Power Automate does not create report on non-public surveys