Using Integromat to generate summary reports from Survey123

Question

I'm am interested in knowing if it's possible to generate a summary report (merge-continuous) using Integromat? I haven't had too much luck accomplishing this so far. I know that you can comma separate Object IDs, which will create a summary report and separate individual reports, but is there a way to process all of the submissions each day and generate a summary report?

Thanks,

Aaron

mwartman_grey · Answer

I tried following the steps outlined by @ManuelCustodio (thanks!), however this outputs pdfs contained in a zip file. Extra processing steps are needed to extract the zip archive and then merge the pdfs back into a single pdf file.

Is it possible for the Make.com Survey123 Report module to generate a single merged pdf when multiple objectids are provided, similar to the 'Merge' option on the Survey123 website output settings?

ManuelCustodio · Answer

Hi,

I've do that whit Integromat, you need to agregate 3 Modules, previously to the Module "Survey123 create report"

1. Module "HTTP-Make a request": insert the URL  whit the QUERY that you define for the report, this defines the ids to print.

2. Module "JSON - Parse Json": this define the structure of the information (Data) of the previous module.

3. Module "Tools - Set variable": this create a variable where goin to use the function join all the "Id's" separates whit commas.

4. Module "Survey123 - Create report": then you use the variable to define the "Feature ObjectID"

I hope this helps

KeithOlsen · Answer

I would be very interested in this option as well. I have been striking out in my efforts to automate the creation of survey123 summary reports. My survey is on our enterprise, but I'm using the https://survey123.arcgis.com/surveys website to manage them. For whatever reason, I'm also not able to get the generate_report python API to work either (SurveyManager). I'm guessing it's just not available for Enterprise (10.8.1) yet. I keep getting ERR_INVALID_PROTOCOL, but no references to that. I was hoping Integromat, but alas, no. Thanks @JamesTedrick for all you do.  --Keith