topic Re: MS Flow to grab photos in Survey123 and add them to a sql report in ArcGIS Survey123 Questions

MS Flow to grab photos in Survey123 and add them to a sql report

JevitaWebster — Wed, 24 Apr 2019 15:02:53 GMT

i'm using MS Flow to grab data from a Survey in Survey123, but the survey has photos. Can i use MS Flow to grab these photos and add them to the SQL report?

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Thu, 25 Apr 2019 21:01:07 GMT

Hi Jevita,

Currently, downloading an attachment in Flow is somewhat difficult. Here is an example workflow:

The steps are:

Send a request to the QueryAttachments Resource
Parse the results of the request as JSON
Extract the attachment id from the result (the ‘Compose’ step)
(optional) Extract the attachment’s file name (the ‘Compose 2’ step)
Request the attachment, using both the objectid of the feature and the id of the attachment

For steps 1 & 5, you will also need to provide a token of a user with the ability to query the feature service – Flow currently cannot access the token of the submitting user.

We are working to make this less cumbersome in the future.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JevitaWebster — Thu, 25 Apr 2019 21:36:46 GMT

does this work if the images question is in a repeater?

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Thu, 25 Apr 2019 22:46:23 GMT

Hi Jevita,

This basic technique would work for images in related records - the main difference is the URLs used in steps 1 & 5 should refer to the layer number of the repeat table in the service.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JevitaWebster — Mon, 29 Apr 2019 18:15:42 GMT

James, Can you export the flow?

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Tue, 30 Apr 2019 22:24:16 GMT

Hi Jevita,

Here's the JSON export of the flow.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

NicholasConnolly — Wed, 15 May 2019 16:45:48 GMT

Hi James,

Flow doesn't seem to be exposing the "attachmentInfos" "id" field. How do I get to the attachment id?

Thanks

Nicholas

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Mon, 20 May 2019 22:49:06 GMT

Hi Nicholas,

It looks like you may have supplied the wrong payload to the queryAttachments step.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

RichardHughes2 — Mon, 12 Aug 2019 15:06:56 GMT

Hi James,

Today I am going to try a recreate your Flow to use attachments from a Survey. We had issues with the Survey 123 Connector but we want to use Flow for handling event escalation and email notification from filtered surveys. Do you know if there has been any progress on the MS Flow and Survey 123 issues in the past few months?

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Tue, 13 Aug 2019 21:29:28 GMT

Hi Richard,

There have not been any updates regarding Survey123 Connector/Attachment interactions in Flow.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

RichardHughes2 — Fri, 16 Aug 2019 01:11:29 GMT

Okay thanks for the response... I was able to get a prototype flow together to grab photos an put into a template by following the steps in your flow. I was surprised how relatively user friendly Flow is. I think I will start incorporating it into more of my projects.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

StevenBowden — Mon, 16 Sep 2019 03:16:53 GMT

Hi James Tedrick,

I am trying to use MS Flow to save survey123 attachments to a OneDrive folder. To try and understand and get the process working I am trying to follow the sample json file using the same feature service as listed in the file. I am just trying to return the attachment for objectID 1 from that feature service.

When I get to the "Get Attachment" step it doesn't seem to be retrieving the attachment. The attachment appears on the e-mail with the correct image name and extension but the file size is only 1kb, it its correct file size (it is also not viewable because it has nothing in the file).

Here is what I have in the "Get Attachment"

The get attachment code view

And here is the code view of the "Send an email"

Any ideas on what I am missing to get the actual data in the attachment?

Regards

Steve

Re: MS Flow to grab photos in Survey123 and add them to a sql report

StevenBowden — Mon, 16 Sep 2019 05:17:52 GMT

I worked out what my issue was, I was hard coding the objectID in the "Query Attachments" step but but then using "@{triggerBody()?['objectid']}" in the "Get Attachment" URI instead of the hardcoded objectID from the first step.

So now that I have the process working, hopefully I can adapt it to work with my feature layer.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

StevenBowden — Mon, 16 Sep 2019 06:25:07 GMT

Hi James Tedrick‌,

Do you have to use a "When HTTP request is received" as the first step in the process or can a Survey123 "When a survey response is submitted" be used as the trigger for the process so that you could have a flow that looked somthing like this to save the attachment

Regards

Steve

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Mon, 16 Sep 2019 16:05:10 GMT

Hi Steven,

You do not necessarily have to use 'When an HTTP request is received', but it may make the process easier for the branch of your workflow that works with attachments. The alternative would be to insert an HTTP request that generates a token, or have a long-lived token embedded in the flow.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

StevenBowden — Tue, 17 Sep 2019 07:14:02 GMT

Thanks James Tedrick‌,

I am trying to replicate the process now using the "When an HTTP request is received". I have created the webook in the Survey123 Survey using the process that Tom Ruff‌ outlines in this thread MS Flow Webhook - Error (TrustFailure) for creating the webhook. However when I enter the Queries parameters they don't seem to be accessible from the http request.

For example I have to manually enter json for the f parameter

If I add @triggerBody()?['f'] as in the sample code, it defaults to html and not json. The same is happening with the objectIds with @{triggerBody()?['objectid']} and the token with @triggerBody()?['token'] No values seemed to be passed through.

When you view the code it looks the same as the sample code

My test

From the sample code

If I hard code the values for f, objectIds and the the token through the whole process it works. So it must be something that I am doing wrong in the initial stage that I can't get the values for those parameters.

Any idea where I am going wrong?

I have also tried to import the sample json zip file that is attached here so that I can view how it is presented in Flow, but it fails to import into Flow. Any ideas on why that might be as well? Flow doesn't give any specific error message.

Regards

Steve

Re: MS Flow to grab photos in Survey123 and add them to a sql report

JamesTedrick — Tue, 17 Sep 2019 20:34:14 GMT

Hi Steve,

A couple of things:

- I would expect hardcoded f:json key/values. You always want to process this in JSON

- What is triggering the 'When an HTTP request is received'? If Survey123, you aren't accessing the objected or other parameters correctly. Take a look at my response in https://community.esri.com/thread/238790-format-of-event-data-sent-in-webhook to get some guidance on that - by far the easiest way to get this correct is to feed MS Flow a sample payload from a test submission.

Re: MS Flow to grab photos in Survey123 and add them to a sql report

NatalieAyala — Mon, 20 Jan 2020 19:07:29 GMT

Are there any updates to this? Or possibly a new version of this JSON export? I've tried uploading this into Flow but get an error message. I've also tried recreated the flow as described but am having trouble finding the connectors from your screenshot above.

I've got a Flow set up to generate a word document based on Survey123 data but need to include photos into the document as well.