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

626
2
09-27-2023 05:11 AM
BrendonJoyce1
Occasional Contributor

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!

0 Kudos
2 Replies
ZacharySutherby
Esri Regular Contributor

Hello @BrendonJoyce1

Is https://maps.xxxxxx.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? 

Thank you,
Zach
0 Kudos
BrendonJoyce1
Occasional Contributor

Hi @ZacharySutherby 

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

BrendonJoyce1_1-1695899230516.png

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

0 Kudos