topic Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation" in ArcGIS Survey123 Questions

Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

TJCrowder — Tue, 30 Jul 2019 18:06:15 GMT

I am stuck. I followed the steps in this awesome blog post for creating a connection to an ArcGIS Enterprise instance by Ismael Chivite : https://community.esri.com/groups/survey123/blog/2019/06/04/survey123-tricks-of-the-trade-integromat

My new enterprise connection can see all my surveys in MY portal (this connector only sees surveys owned by the account you use to configure your enterprise connection from what I can tell). My newly configured webhook was automatically added to my survey, I test run the scenario, and then, bummer, I receive this error on every survey I have tried.

We are on duel machine deployment of Portal for ArcGIS 10.7.1 with a federated server. The feature services are "hosted" in our data store and there are no issues with the survey functionality at all. It seems like the 1st step of creating the json payload from the webhook in my Integromat scenario is failing to capture the data. I get the exact same error even with a simple form with no attachment or geopoint questions. I've set sharing to public on all the services and forms. I've turned off server firewalls but the error persists. From my experience this seems like a permissions issue on the service, but I can't seem to figure out a solution. Any insight would be greatly appreciated! 🙂 .... James? James Tedrick

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

JamesTedrick — Thu, 08 Aug 2019 00:12:57 GMT

Hi TJ,

I believe what is occurring is that the query for attachment keywords (used to distinguish one image question from another in Survey123) is failing as that is not yet supported in ArcGIS Enterprise. I'll take this in as an issue to address.

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

TJCrowder — Mon, 12 Aug 2019 14:26:28 GMT

Thanks James. So even if we have a survey with no attachment questions it doesn't work. So essentially survey123 and Integromat webhooks are not supported in ArcGIS Enterprise?

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

JamesTedrick — Mon, 12 Aug 2019 17:54:36 GMT

Hi TJ,

Integromat webhooks should be supported with ArcGIS Enterprise, and we've had other users work with them- given the error, I assumed that you had an image, file or audio (attachment) question in the form.

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

TJCrowder — Tue, 13 Aug 2019 17:47:42 GMT

I just started completely from scratch. Created a brand new survey with 2 questions: A text and a datetime field. Built out a new Integromat "watch survey" scenario to send an email to myself via gmail upon new survey submission and got the same queryAttachment error.

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

KeithOlsen — Fri, 10 Apr 2020 22:19:11 GMT

Hi James,

Any idea when Enterprise will support Survey123 attachments transferred to Integromat scenarios? I cannot find any information in the survey123 payload about the signature attachment image from my survey. I'm running Enterprise 10.7.1.

--Keith

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

JamesTedrick — Tue, 14 Apr 2020 21:44:51 GMT

Hi Keith,

The ArcGIS Enterprise team is working on supporting the capabilities needed in a future release.

Re: Survey123 & Integromat with Portal for ArcGIS: "[500] Error performing queryAttachments operation"

SWilander — Tue, 08 Mar 2022 17:18:37 GMT

Integromat or Make Errors: BundleValidationError, Missing URL, ….Wont Pass Filter

FIX IN INTEGROMAT also known as MAKE, “Scenario”:

Leave the “Advanced Settings” checkbox UNCHECKED in the Integromat -Survey123 Create Report Module and save the Integromat Scenario.

At this time this issue is related to the Feature Layer which is in your ArcGisOnline (AGO) Content for the Survey. In this case I had two Feature Layers in the AGO Survey’s Content. And If I had the “Advanced Settings” checkbox on, I would be able to chose which feature layer was included in the Create a Report Module, which causes the whole Scenario to FAIL at this module. Leaving the Advanced Settings checkbox unchecked somehow allows the Scenario to Include both of the feature layers in the scenario allowing the whole scenario to run with success.

A repeat of this fix; In the end the fix for this was in the Survey123 Create Report Module in the Integromat scenario, and to -leave off the checkbox for Advanced Settings and save the Module with this box UNCHECKED. Like you see in the clip below.

SWilander_0-1646759883481.png