How to decode image stored in MySQL (Cloud Object Storage)

[lpanetta]

Hi there!

I've been using spreadsheets to store all data and google Drive to store images, but recently I moved to MySQL for Data, and Google Drive still to save photos.

Yesterday I switched to what AppSheet calls, "Cloud Object Storage", basically creating 2 more columns on a table in MySQL, to store the label and the image itself. It works great, on the APP I can see the uploaded pictures that are saved to my database.

The problem occurs when I want to retrieve or display that image outside AppSheet. I thought the content column for the picture was basically a base64 encoded image, but when I decode that text, there simply nothing there.

¿How can I achieve that?

Because since I'm storing everything in a proper database, which then allows me to create any sort of reports, It would be proper that the image stored there can be accesible withouth the need of the APP

Thanks in advance!

[Marc_Dillon]

---

@lpanetta wrote:

The problem occurs when I want to retrieve or display that image outside AppSheet.

---

So your issue is with other systems outside of Appsheet then? Perhaps posting on their forums would be better? Or what exactly are you trying to do? How are you decoding the text?

[lpanetta]

mm no. I want to know how can I decode the image data that it is stored in 2 columns by AppSheet, but withouth using AppSheet.

Using the URL "https://www.appsheet.com/template/gettablefileurl?".. works great, but that means that if tomorrows my AppSheet or even AppSheet itselfs shutsdown for whatever reason. ¿How would I be able to convert all that string in my db to an actual image? Is that possible? Or is it encoded in a way only AppSheet can decode it?