open google doc by id

user1070396 picture user1070396 · Feb 1, 2013 · Viewed 19.1k times · Source

What I am trying to do is make a copy of a template doc, the append sheet data to the new file. I am using the doc URL as the id. However, when I try to access the file I am getting this error "Document is missing (perhaps it was deleted?) (line 21)" Line 21 is

    var templateid = "URL";
    var file = DocumentApp.openById(templateid);        

Can anyone advise on what the problem could be?

Answer

Charles Stewart picture Charles Stewart · Feb 1, 2013

The document id is not the URL of the document, but it is a UID generated when the document is created, e.g., it is the value of id after var id = createDocWithTable("doc with table").

You need to keep track of this id separately. If you have the document object, you can retrieve it with its getId() method. The ID is also encoded into the URL, so https://docs.google.com/document/d/3ckYOu8kuIfBzbu-Dtu9XwGHUnUJG32PK7wHe5xMv3VG/ has document id 3ckYOu8kuIfBzbu-Dtu9XwGHUnUJG32PK7wHe5xMv3VG