LinkedIn
Twitter
Hi to all,
Clearly an interesting topic over here !!
I would say, as usual when mister @tsuji_koichi is involved.
First, Personal Opinion
On a overall topic, โpublicโ endpoint should never be used in a production app. [ google services or any other one ]
Like the uc?export=view&id=xxxxxx but i could name many others.
Those are not reliable, not efficient and are prompt to behaviour change, not to mention some can be deleted. ( google has a long story of switching, turning off those kind of end-point )
Using an API request is the way to do it, at least for production environment.
Return to the main topic,
As @tsuji_koichi mentioned the only way to made a efficient and reliable access to any data is to call an native AppSheet โfunctionโ to make the request. ( remember all those request probably goes into some async loop worker )
So setup 2 with file path will always be the best.
some details :
I never know why but Appsheet seems to use two โdifferentโ methods to feed image inside app. (maybe it depends of security option or maybe even view type )
with a https://www.appsheet.com/get/?i=
this will return a 600 width image.
[the full resolution image can be open with the fullscreen icon, and it seems no new request is send to access it ]
with the https://www.appsheet.com/template/gettablefileurl?appName=
this will return a 600 width image from the https://www.appsheet.com/fsimage.jpg?filename=
[the full resolution image can be open with the fullscreen icon, but a new requested has to be sended to access it, this will generate a wait time and a lot of 404 error, but i think it really depends how you secure your urlโs app, security options : secure url, secure image etcโฆ]
Both method require a unix relative file path, [many way exist to massively generate those path]
the https://www.appsheet.com/fsimage.jpg?filename= can be directly generated and put into a table column with a size parameter, or setting it inside the app with a virutal column, context view, action, user settings etcโฆ
( this is the fastest way to have the image inside the app, plus you can minimize mobile data usage and app reactiveness )
Any way,
Honeslty, i have an App with more than 200K image, and AppSheet handle it natively like a charm.
( only a classic file path column set as image type, without any โoptimizationโ ) [ Iโm still amazed by this ]
End,
I could mention the use of the https://www.appsheet.com/remote/ + Url end-point [view, export, download, http web-app services request ]
( can be useful to if you want to add a document conversion action button but better to use a webhook api for this)
Linked Topic
Itโs funny how time coincidence collide sometimes;
I recently finished the development of an API to give my users access to their personnel directories through a GAS Back-end [a mix of pure drive.app and drive API V2] and a Front-End with JavaScript/JQuery/React/Html.
Basically,
First, i created a JSON Query function to dynamically map and index any requested directorie tree + files.
Then i created a Custom React/JavaS component which take the returned JSON Object to build dynamically the Front-End HTML Code.
This is morish like an AppSheet Deck view type, with some embded icon for go-in-to-folder, delete, rename, view, add or download file or folder.
( the onclick() Html event trigger back the specific GAS Back-end fonction )
So, im more than happy to learn that AppSheet develop a drive access component.
This can maybe solve one of my long time usercase : a fully AppSheet integrated Document Management System
Wait and see 
Iโm not sure how accurate this is. Created the table from the google drive, added Virtual column with TEXT([File]) - Set to image.
There are images in my Google Drive Folder which are not pulled through to the table.
The folder โImagePathโ only contains images and each image has the same naming convention:
Mystery as to why it isnโt collecting ALL the images when I can see them in the driveโฆ
Sure @Scott_Haaland , I canโt see a pattern really, I tested yesterday and found Images in both the local C:\users\dave.willett\googledrive folder and the online Google drive, they were synced correctly. It seems the Appsheet drive table was incomplete but with no pattern. As mentioned earlier, all images ( and there are only images there) are 6 digits, hyphen, incremented digits and .jpg, example:
***** The table contains 100 rows @ 1 image per row, could it be your test limit is 100 instead of 1000 (thousand) ??? ****
12345-001.jpg
12345-002.jpg
12345-003.jpg
54355-001.jpg
54355-002.jpg
And thanks There are also instructions in the Automation Preview Primer doc, which can be found here, in case anyone else wants to learn about how to configure this.
However, it is pretty straightforward once you understand this, as Dave discovered:
- Add a new Table to your app
- Choose โDocuments on Googleโ
- Choose โCollection of Filesโ option on the right hand side
- Select your Drive Folder that you want to use as your data source โ Table
- Add your virtual column with the Image link as TEXT([File])
- Add a View to render your images - the Gallery view works nicely
Hi Scott, I am trying to follow this simple steps but I get the message that there are โNo items in this folderโ even though I have .png and .jpeg files saved here. Just starting with Appsheet, so this is frustrating. Also read through tons of conversations on how to use Google Drive images in Appsheet and I canโt even identify an image id inside the generated url from the โget linkโ url in google drive. What am I missing?
Thank you or anyone else for helping a newbie.
