topic Re: Survey 123 Webhook to Moderate Content? in ArcGIS Survey123 Questions

Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Tue, 02 Apr 2019 19:14:45 GMT

Is there any way to use MS Flow to start an approval process that pushes a public facing survey response to a private feature service until the content has been approved? Trying to figure out how to screen crowd source images and text before posting to the public facing service. Possible? Thanks, cob

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Tue, 02 Apr 2019 22:32:46 GMT

Hi,

Yes, it is quite possible to set this up. The specifics would depend on the exact workflow you wish to implement, but here is a sample idea:

- The feature class includes a 'review_status' field, that is either null (blank), 'In review', 'Approved', 'Not Approved'

- The form does not include a review_status question, meaning it will be blank when submitted

- You could have a Webhook attached to the form that e-mails the designated reviewer, notifying them of the new submission. I would suggest either including the content to be reviewed in the e-mail or providing a link for the person to review

- If you can include the entire content, you could include a link that triggers a second webhook with the id and have it update the feature to approve.

- Otherwise, you would have an editing app available that could let the review approve or not approve the submission

Re: Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Wed, 03 Apr 2019 15:10:29 GMT

Thanks James - I haven't used Flow much, just to send notification emails, but we are trying to use the Flow approval process when a new survey response is submitted. Will Flow hold the survey response in limbo until it is approved or will it be posted before the workflow is initiated? Why do I need to add fields to the feature class when using the Flow process? I am basically stuck at what to do if Response (for the approval in Flow) is 'Reject' where I would just want to delete the record from the survey without posting. The only option for the S123 connector at that point is 'Get Surveys' and I can't see a way to reference anything from the target survey I set initially. Also, my understanding is that the dynamic content links for the S123 webhook do not recognize image attachments which is obviously one of our main concerns in this situation. But really if Flow will just hold the response and notify the reviewer that would meet our needs well enough.

Can you elaborate a bit on how to set the second webhook using the survey content? Or is there a better way given the information above? Thanks, cob

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Wed, 03 Apr 2019 17:59:32 GMT

Hi Charles,

Flow doesn't hold the response in limbo - that was why I suggested adding a field to the feature class, to store the status of the feature in the feature's table - this makes it pretty easy to filter those records not approved for other maps and applications.

With regard to images, you are correct - it would probably be more appropriate for the reviewer to use another application to present the full submission if that is part of the review. In terms of deleting records if rejected, that can be done either in an application that is being used to review, or could be automated via geoprocessing script or webhook - the latter would need some familiarity of the ArcGIS REST API).

Re: Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Wed, 03 Apr 2019 18:42:58 GMT

Got the first part, apologies for my denseness. But you've intrigued me with the second webhook - would that be done in Flow as well? Can you give a brief example of how it would work? Thanks, cob

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Thu, 04 Apr 2019 22:01:32 GMT

Hi Charles,

Actually, I've found that this is built into MS Flow - see Create a flow to manage project approvals - PowerApps | Microsoft Docs and Approvals - Connectors | Microsoft Docs . The first link is a little out of date, but should get you started. See the image below for a sample I made in exploring this; the 'If no > Send an email' would change to an HTTP action to the feature layer's applyEdits URL that would update the field.

Re: Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Mon, 08 Apr 2019 15:03:32 GMT

Ahh, I thought it might work that way - but which action do I use from Flow when entering the Http action? I assume you are referring back to the REST API? Can you show an example of what that would look like, say to change an approval field from No to Yes? Thanks for all your help, James.

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Tue, 09 Apr 2019 17:18:19 GMT

Hi Charles,

I plan to work on a fuller document presenting this as a workflow, but the call would most likely be an applyEdits call at either the Feature Service or Feature Layer resource. Exactly which call would depend on how your data processing work, but the 2 most likely:

- an update to the feature to change the status field to an approved state when approved

- a delete to remove the feature when rejected

Re: Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Tue, 09 Apr 2019 18:02:43 GMT

Thanks James. Please keep me posted on your progress - I will be monitoring

this thread in case you have news. For now we are sending emails and

editing the hidden field as you suggested. The response also triggers an

email to the (public) submitting individual advising of the status. Thanks

again James - cob

Re: Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Thu, 11 Apr 2019 17:11:33 GMT

Well I couldn't leave this alone James... have an https request connecting to the feature service through Flow (I think) but it doesn't do anything. The request works fine in the API in AGOL (having to hard code the objectid of course - I tried that in the Flow to no avail). In Flow it breezes right through with status 200 but fails to update the field. What am I missing here? Anything need to go in the header or am I totally off base? Thanks, cob

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Tue, 23 Apr 2019 21:58:18 GMT

Hi Charles,

In the request, you're missing both the f (json) and token parameters (queries). What is the message returned from the request?

Re: Survey 123 Webhook to Moderate Content?

ILoveMap — Wed, 29 Jan 2020 19:58:11 GMT

Hi James,

Have you made a document pertaining to this process?

I'm also very interested in implementing this workflow.

Re: Survey 123 Webhook to Moderate Content?

ILoveMap — Tue, 18 Feb 2020 17:34:45 GMT

Hi Charles,

Did you ever get this workflow to work? I am also confused about the HTTP Request component.

Re: Survey 123 Webhook to Moderate Content?

CharlesBailey3 — Tue, 18 Feb 2020 18:11:11 GMT

No, we just had the recipient manually update the field. The http request is for the update service on the rest API for AGOL I think. I didn't know what James meant by the json and query parameters. Sorry couldn't be more help - cob

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Wed, 19 Feb 2020 21:14:35 GMT

Hi Chris,

Please review Update Features—ArcGIS REST API: Services Directory | ArcGIS for Developers - I mentioned specifically that the request shown in the screenshot was missing some required parameters:

f=json - the format you want to receive the response in

token=<TOKEN> - the token that allows the request to access secured services.

Re: Survey 123 Webhook to Moderate Content?

ILoveMap — Fri, 21 Feb 2020 12:25:51 GMT

Hi James,

I'm trying to execute the following workflow described by Tom Thompson here (and very similar to what OP described)

Webhooks, Microsoft Flow and the ArcGIS Rest API – Automating Your Web GIS

However, I keep getting the following error when performing a GET request query operation. I was hoping you could help.

{"error":{"code":400,"message":"Cannot perform query. Invalid query parameters.","details":["Unable to perform query. Please check your parameters.","No where clause specified."]}}

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Fri, 21 Feb 2020 18:04:49 GMT

It appears you're prematurely percent-encoding the '=' to %3D - Power Automate will take care of that for you

Re: Survey 123 Webhook to Moderate Content?

ILoveMap — Tue, 25 Feb 2020 19:30:56 GMT

I removed the percent-encoding but the same error is persisting.... the status code in power automate is 200 when it runs but the error code can be found in the body of the http query operation. Any help would be appreciated!

Re: Survey 123 Webhook to Moderate Content?

JamesTedrick — Thu, 27 Feb 2020 19:06:18 GMT

Hi Chris,

I would also remove all of the parameters from the URL, placing them in the queries section - if Powerr Automate isn't autofilling the URI based on the queries, you are sending the 2 f and token parameters.

Re: Survey 123 Webhook to Moderate Content?

ILoveMap — Thu, 27 Feb 2020 19:27:56 GMT

Hi James,

Thanks for the response. I removed the URL parameters but it still returns the same error code 400. The URI shown in the screenshot is copied below as well, I believe the percent encoding may be necessary but I'm not sure.

https://services1.arcgis.com/FNjlrOFR0aGJ71Tg/arcgis/rest/services/service_2467f8239e464e73a5fac7d2e1d0b4cf/FeatureServer/0/query?where=Site_ID+@{triggerBody()?['feature']?['attributes']?['Site_ID']}