Google App Script downloading .heic form attachments

[rlopbc]

Related Product
Which product is this question related to?

API

Describe the question
We have a Google App Script that fetches form submissions from the People API and downloads the attachments directly from the url values in the attachments array (s3.amazonaws.com/uploads/form_submission_value...). We're encountering a strange bug where most file formats are downloaded just fine (eg. png, jpg, pdf), but the script fails consistently on .heic files (ie. mobile image capture).

What have you tried that worked?

Narrowed it down to specifically to GAS UrlFetchApp.fetch(...) failing with Unexpected error. All other filetype attachments seem to work fine. Current hypothesis is that perhaps the .heic files are returned with extremely large/heavy metadata in the headers, and the script is getting tripped up by that. If I copy the url directly into a browser, the download works just fine, so it's a GAS specific issue.

What have you tried that didn't work?

Passing various options and header metadata to UrlFetchApp.fetch(...), muting http exceptions, stripping parameters from the s3.amazonaws.com url....

Additional context

Any tips or suggestions welcome! Either ideas on solutioning, or even ideas on how to further debug the issue.

I have..

• [ x] Reviewed the documentation found at https://developer.planning.center/docs
• [ x] Searched for previous issues answering this question
• [ x] Removed all private information from this issue (credentials, tokens, emails, phone numbers, etc.)
• Reviewed my issue for completeness

[shanebonham]

Hi @rlopbc,

We don't do anything special with HEIC files, so this sounds like a limitation with Google Apps Script. I don't know how comforting it is, but here's at least one instance of someone describing almost the exact same issue: https://stackoverflow.com/questions/79118546/google-apps-script-unexpected-error-in-urlfetchapp-fetch-method-for-heic-image

Something that might help you troubleshoot further is to put one of the HEIC images that's giving you trouble on a different server and see if GAS is able to download it from there.

Sorry we can't be of more help!