Assigned
Status Update
Comments
jk...@gmail.com <jk...@gmail.com> #2
I'm pasting in Evin's comment from the forum thread:
The URL that you supplied redirects to this URL:
https://doc-10-38-docs.googleusercontent.com/a/google.com/docs/secure/qpeq1j6dir1en93us0dp078fdi3btf0d/839jt742gccauf6b2n6k1kvethb30ad7/1277985600000/05874703959588494993/10560464865001279305/0B9bnGfv5JP_oMGI2ZDdkYmYtMGM1Yi00MTZhLThlMmItOWVjYzg5MmUzMWRl?h=08181731109795882708&nonce=bhl19d6j2ni4e&user=10560464865001279305&hash=nbov92asu49g7ei94s7noksq83mtp046
Using that url works fine. Note that the doc list urls are not stable - they change every 24 hours. The base URL to the interstitial works, but then you get the redirect which can't be embedded. This is to avoid folks using doc list as a serving platform.
The real solution is for us to have a variant of insertImage that takes a doc list 'file' as a parameter, rather than a URL. We're working on that, sorry for the inconvenience.
-------------
I'm changing this to a feature request to create a version of insertImage that takes a doc list 'file' as a parameter, rather than a URL.
The URL that you supplied redirects to this URL:
Using that url works fine. Note that the doc list urls are not stable - they change every 24 hours. The base URL to the interstitial works, but then you get the redirect which can't be embedded. This is to avoid folks using doc list as a serving platform.
The real solution is for us to have a variant of insertImage that takes a doc list 'file' as a parameter, rather than a URL. We're working on that, sorry for the inconvenience.
-------------
I'm changing this to a feature request to create a version of insertImage that takes a doc list 'file' as a parameter, rather than a URL.
jk...@google.com <jk...@google.com>
go...@platoacademy.net <go...@platoacademy.net> #3
Is this working yet? Date of this issue was Jul 2010, almost 2 years ago... can an insert image or image widget take a google doc "file" location parameter or Picasa image location rather then a URL?
I need to dynamically assign an image location and it would make sense to get it from docs or picasa rather then a separate webserver
I need to dynamically assign an image location and it would make sense to get it from docs or picasa rather then a separate webserver
lo...@gmail.com <lo...@gmail.com> #4
It is October 2012, I get the same error still. I need this support too.
fe...@gmail.com <fe...@gmail.com> #5
[Comment deleted]
fe...@gmail.com <fe...@gmail.com> #6
It is March 2013 I get the same error still. I need this support too.
ec...@gmail.com <ec...@gmail.com> #7
The same with me.
de...@lafurniturestore.com <de...@lafurniturestore.com> #8
actually I solved this problem very easily and there is no problem. (maybe not at the time of the issue posting)
fe...@gmail.com <fe...@gmail.com> #9
[Comment deleted]
ec...@gmail.com <ec...@gmail.com> #11
Putting it in public folder is not a solution. Imagine inserting a signature to an invoice. Of course the signature has to be private.
[Deleted User] <[Deleted User]> #12
Any news? we need to keep private the images in our Google Apps domain.
st...@gmail.com <st...@gmail.com> #14
I solved this problem for our company by using the Advanced Drive SDK to retrieve the thumbnailLink of the image file and then inserting that into the Sheet using a computed formula string. Really not too hard, and so far it has been working (seems like a miracle). I was also banging my head against the wall for awhile. insertImage() doesn't help, because it inserts one of those floater things, so the url method appears to be the only way. It's a strange workaround to have to use, so I hope this sort of feature gets built-in, because putting images into spreadsheets is pretty common, I should think.
Here's a link to my coded solution.https://gist.github.com/sjsyrek/de2c4b3506287cc87760
Here's a link to my coded solution.
ja...@agrosevilla.com <ja...@agrosevilla.com> #15
March 2017: How is possible that this issue is not yet solved?
ma...@gmail.com <ma...@gmail.com> #16
January 2019: Still very frustrating. Also no clarity on claims it is impossible versus claims it is easy to solve. Given the years that have passed this is flogging a dead horse. This is not an environment in which you can be productive, and believe me I tried!
Comment #14 does not (explicitly) address that this approach works fine for publicly shared files, but not for private files. It also claims the solution requires use of the advanced Drive API, but does not explain why.
If I can see PDF thumbnails in Drive itself, why would I have to make my files public to see them in a private Spreadsheet? Will Google ever speak?
If I can see PDF thumbnails in Drive itself, why would I have to make my files public to see them in a private Spreadsheet? Will Google ever speak?
Description
1. Upload an image on google documents
2. Change sharing settings to make it visible on the web
3. Call insertImage with the url of that image. Google app script throw an error.
What is the expected output? What do you see instead?
The expected output would be to load the image without any error. Instead, google app throw the following error message: "We're sorry, a server error occurred. Please wait a bit and try again. (# 109)."
On which browser & OS?
Internet explorer 8.0.7600.16385 under Windows 7 64bits
Please provide any additional information below.
You can see an more detailed description on the google app script getting started forum:
Cheers,
Olivier