Need help encoding appsheet images to base64

[Binkodyl (Dylan Binkowski)]

Hi there! I’m trying to encode images of drawing type to base64. Any ideas on how I can convert the image itself to base64 so I can send it through an integration?

[Stefan_Quartemont]

I’ve done it by sending the URL to a Google Cloud Function via a Webhook and then having the Cloud function convert it to base 64 or whatever image file type I needed and manage the additional communication steps.

You could probably also do this with Google App Scripts (particularly if the file is in Google Drive)

[Steve (Steve Coile)]

AppSheet has no built-in method of converting images to base64.

[GreenFlux (GreenFluxLLC)]

@Stefan_Quartemont

You could probably also do this with Google App Scripts (particularly if the file is in Google Drive)

Already did

Base64Decode Images to String with Apps Script, for Use in Webhook Templates

AppSheet webhooks can send POSTs to create records in other web-services but they don’t offer multipart/Form-Data templates. There’s also no expressions for converting the image to a Base64 string, so there’s no easy way to include images in webhooks. The following Apps Script code can be added to your spreadsheet to monitor for new images and write the Base64 strings back to a new column of that row in the sheet. Paste code into new script: Tools/Script Editor var imgFolder = DriveApp.getFol…