topic Re: SurveyMonkey Document Download in Workato Pros Discussion Board

SurveyMonkey Document Download

dan-lowry — Tue, 19 Apr 2022 03:13:09 GMT

I am working on a SurveyMonkey integration that is looking to download any documents (typically PDFs) that are loaded into response answers. I'm able to extract a"download_URL" value using "https://api.surveymonkey.net/v3/surveys/{Survey ID Datapill}/responses/{Respondent ID}/details?simple=true".

The document download URL retrieved is NOT an API endpoint, but rather can be navigated to for a direct automatic download (provided a user session is active).

When testing this using the "Get Files from URL" utility connector, the step does not error, but when I try and use the file contents to upload to another platform, I recieve an error that should not occur if the file was downloaded correctly initially.

"Get Files from URL" says it requires a publicly-accessible URL, but has anyone ever used it to extract a file from a platform you were previously authenticated for within that recipe? If not, any recommendations on how to download a file from an authenticated app that does not provide an API GET endpoint for that file.

Re: SurveyMonkey Document Download

roland-daane — Tue, 19 Apr 2022 03:19:08 GMT

What's the question?

Re: SurveyMonkey Document Download

dan-lowry — Tue, 19 Apr 2022 03:27:01 GMT

Can "Get Files from URL" utility connector be used to extract a file from a platform you were previously authenticated for within that recipe? If not, any recommendations on how to download a file from an authenticated app that does not provide an API GET endpoint for that file. Just trying to see if I missed an outside the box possibility.

Re: SurveyMonkey Document Download

roland-daane — Tue, 19 Apr 2022 03:30:10 GMT

Maybe an idea to embed some python which can download a file from a url.
The embed that python in a recipe.

Idea?

Re: SurveyMonkey Document Download

dan-lowry — Tue, 19 Apr 2022 03:36:22 GMT

Definitely a possibility. I have been discussing that with my team, but wanted to see if there were any other known solutions before creating our own ruby or python script.

Re: SurveyMonkey Document Download

james-ng — Tue, 19 Apr 2022 13:51:44 GMT

When the File Content is downloaded, you cannot use the [File Content] datapill directly to upload to another platform.

You should use [File Content].encode_base64 in formula mode.

More details in documentation: https://docs.workato.com/features/handling-binary-files.html#base64-encoding