Display PDF file stored in database

AppSheet AppSheet Q&A
1

Hi community,

I’m using a postgres database in which I store datafiles like pdf or images(bytea datatype).
I’d like to know if there is any way to display/download these files through appsheet.

Thank you.

regards

2

Hi @tbmaestro_ca! Welcome to the AppSheet Community. Please update this post with the category of “Question”. You will get moire eyes seeing the post.

1 Like
3

I dont have past experience with this, but is it possible to convert the bytea data onto BASE64 ?
And then read Base64 field as image from Appsheet?
Base64 strings could be displayed as image within Appsheet so the question sounds like how to get that from bytea data.

2 Likes
4

Thank you @tsuji_koichi, It really helps! It works for image but I did not manage to display or dowload a pdf, work in progress