topic Re: Adding Survey123 Feature Report as Output File to Integromat Workflow in ArcGIS Survey123 Questions

Adding Survey123 Feature Report as Output File to Integromat Workflow

BenVan_Kesteren1 — Fri, 24 May 2019 02:45:10 GMT

Hey,

So I have Integromat successfully detecting when a survey is submitted, it then sends the data to create a report, which works great, this setup looks like this:

An email is sent which is fine, but what I am having trouble with is working out how to get the outputted report from the Create Feature Report module, and insert this into the attachment field for the GMAIL Send an Email module...

These are the settings I think are working in Create Feature Report:

Then in the GMAIL Send Email module, I am unsure about this, what do I put in the Data field, within the Attachment section?:

Cheers

CC Henry Clark‌

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

Jim-Moore — Fri, 24 May 2019 03:35:55 GMT

Hi Ben

Nice work with the scenario. The trick here is to use the HTTP Get a file module between the Create feature report and Gmail modules. This module will retrieve the output DOCX file, which can then be attached to your email. The URL to the file is in the resultFiles part of the payload:

Over on our EAC there's a short video demonstrating the Create feature report action. Please see the link at the bottom of this post.

UPDATE: For more info please refer to this very useful GeoNet blog post: https://community.esri.com/groups/survey123/blog/2019/06/04/survey123-tricks-of-the-trade-integromat. The Working with Survey123 attachments section covers how to retrieve a file using the HTTP module and include it as an email attachment.

Best regards,

Jim

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

BenVan_Kesteren1 — Fri, 24 May 2019 04:02:53 GMT

Fantastic, thanks for that Jim.

I now have two follow up questions if you dont mind

Can we rename the attachment that is sent to the end user?
Can we convert the .docx file to be a pdf instead?

Thanks again

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

Jim-Moore — Fri, 24 May 2019 07:10:28 GMT

Hi Ben, great to hear this was useful. To answer your questions:

1. In the attachments settings in the Gmail module you can select "Map" for the source file, which allows you to specify a different filename. You can enter the filename manually or have it populated from parts of a payload.

2. We are currently researching methods for PDF output for feature reports and we're looking to implement this in a future release. No timeline available as yet but I'll endeavour to keep this thread updated.

Cheers,

Jim

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

BenVan_Kesteren1 — Sun, 26 May 2019 06:48:35 GMT

Thanks for that Jim. I was successfully able to rename the file. It took me a second to realise that when I map another field (survey title for example) that I had to manually tell it to end in .docx otherwise the file come through without the extension. Thats a simple mistake from my end, but hopefully this post helps someone in the future.

Also with regards to the PDF not being supported yet, that is a major bummer, our reports are actually 'certificates' to home owners, so sending a docx file is not really appropriate, so this is a major hurdle we just hit.

We eagerly await any updates from you as to when PDF outputs will be supported.

Cheers

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

Jim-Moore — Mon, 27 May 2019 02:30:10 GMT

Hi Ben

Thanks for the additional feedback, I've added your comments to our internal discussion and will certainly let you know of any progress. In the meantime, there might be other third party modules in Integromat that could covert the DOCX to PDF; I haven't investigated this so unsure of the options but could be worth checking out.

Good catch re: the .docx file extension!

Cheers,
Jim

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

BenVan_Kesteren1 — Tue, 28 May 2019 00:28:02 GMT

Ok another update... I think I have all steps required, in order to achieve what I need... You were correct, there is a CloudConvert tool in integromat which I have been able to utilise, so my final workflow looks like this:

The user submits a survey on the Survey123 app, the Create Feature Report picks up on this submission and converts the survey into a docx report, and then the HTTP tool is able to grab this attachment, and supply it to the CloudConvert Tool, which then creates a PDF for me, which is then added to an email and sent out via Gmail....

Very handy workflow thus far. I do not want to discourage ESRI from enabling the feature report to export as a PDF, as the CloudConvert tool is only free for your first few conversions each day, and then you have to pay... so if I can remove the converter and have the PDF created from the beginning, this will save my organisation some money.

Thanks again for your help.

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

GlenGardner1 — Thu, 30 May 2019 13:51:03 GMT

Is this Create Report Action going to be added to Microsoft flow?

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

GlenGardner1 — Thu, 30 May 2019 13:51:22 GMT

Is this Create Report Action going to be added to Microsoft flow?

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

JamesTedrick — Fri, 31 May 2019 00:48:30 GMT

Hi Glen,

We are looking into supporting the feature report action in MS Flow; that being said, the different environments have different configuration mechanisms and have different limitations in supporting these actions.

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

DavidBooth — Wed, 31 Jul 2019 15:01:25 GMT

The Create Feature Report module works great in Integromat. However, many existing business workflows are within the Microsoft environment. For many users, keeping workflow processes like Survey123 in this same Microsoft environment and using MS Flow is probably the preferred solution since it integrates better with existing network systems. Hopefully this will be made available for Flow soon.

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

JoelBrea_Rasquin — Mon, 05 Aug 2019 04:19:42 GMT

Hello, I am trying to configure sending a feature report by gmail but it is throwing me a error "Missing value of required parameter 'URL'." please help me to solve it?

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

Jim-Moore — Mon, 05 Aug 2019 23:27:02 GMT

Hi Joel

Thank you for the screenshots. Please try removing 4. Data from the Content-ID in the Gmail attachment settings. Content-ID is used when embedding inline images into the body of your email. In this case, we're attaching a DOCX file so this parameter is not applicable.

Hope this helps,

Jim

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

JoelBrea_Rasquin — Tue, 06 Aug 2019 05:33:28 GMT

Thanks Jim, now it's working. I am waiting for the update to send the report in PDF

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

Jim-Moore — Tue, 06 Aug 2019 05:59:12 GMT

Hi Joel, good to hear it's working! PDF feature reports is a work in progress at the moment but please stay tuned to GeoNet for updates.

Best,

Jim

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

BenBaker1 — Wed, 04 Sep 2019 20:38:21 GMT

This looks exactly like a workflow I just put together. I am having trouble renaming the file in CloudConvert. I've tried a static name, and tried to build the file name from attributes. Do you have any advice on how to make this work? Is it because I'm trying to go from the .docx to a .pdf and rename it in the same step?

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

BenVan_Kesteren1 — Thu, 05 Sep 2019 05:53:58 GMT

Hey Ben Baker‌,

I have looked into this previously but could not work it out myself. I am unsure if a rename is possible at this point.

Hopefully someone else sees this and can help us both!

Cheers

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

BenBaker1 — Thu, 05 Sep 2019 21:00:59 GMT

Ben Van Kesteren wrote:
Thanks for that Jim. I just got the file renamed successfully. It took me a second to realise that when I map another field (survey title for example) that I had to manually tell it to end in .docx otherwise the file come through without the extension. Thats a simple mistake from my end, but hopefully this post helps someone in the future.

So you were or were not able to rename the file?

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

EricChez — Tue, 17 Sep 2019 16:07:49 GMT

James,

How soon will this be supported in MS Flow? (anxiously waiting) our organization is using Microsoft, and having this action available to us in Microsoft Flow would make us very happy campers.

Integromat is good for some, but companies that use Office365, (probably larger audience) would love it if its available in Flow

Re: Adding Survey123 Feature Report as Output File to Integromat Workflow

wcozzens — Wed, 18 Sep 2019 18:50:14 GMT

Hi Ben,

Would it be possible for you to post a screen shot of the working Cloud Convert function you're using in Integromat to change the filename? I have the same scenario running as you, but I cannot figure out how to rename the file that gets exported from Cloud Convert.

Thanks!