google docs - Apps Script: DocumentApp.openByUrl Unexpected Error - Stack Overflow

admin管理员组

文章数量:1124691

I'm working on a Google Apps Script project and facing an issue with the openByUrl method from the DocumentApp class.

Here's the problem: I'm using the following document URL:

When I try to open the document using DocumentApp.openByUrl, I get this error:

Unexpected error while getting the method or property openByUrl on object DocumentApp.

Below is the code snippet:

var url = ";;
var doc = DocumentApp.openByUrl(url);

I've verified the following:

The URL is correct and accessible.

The document is shared with the script.

Does anyone have an idea of what could be wrong? Is there a better approach to opening a document using a URL?

Thank you!

I'm working on a Google Apps Script project and facing an issue with the openByUrl method from the DocumentApp class.

Here's the problem: I'm using the following document URL: https://docs.google.com/document/d/1bmad4K86Ov1zQHiu8gbX6GpOSL9kbNGKiE3jmaJN9N8/edit?usp=drive_web

When I try to open the document using DocumentApp.openByUrl, I get this error:

Unexpected error while getting the method or property openByUrl on object DocumentApp.

Below is the code snippet:

var url = "https://docs.google.com/document/d/1bmad4K86Ov1zQHiu8gbX6GpOSL9kbNGKiE3jmaJN9N8/edit?usp=drive_web";
var doc = DocumentApp.openByUrl(url);

I've verified the following:

The URL is correct and accessible.

The document is shared with the script.

Does anyone have an idea of what could be wrong? Is there a better approach to opening a document using a URL?

Thank you!

• google-apps-script
• google-docs

Share Improve this question Follow asked 2 days ago Vikram AruchamyVikram Aruchamy 18222 silver badges1212 bronze badges 2

• 1 I found a very similar post in Reddit reddit.com/r/GoogleAppsScript/comments/1hxc2z8/… also posted two hours ago. – Wicket Commented 2 days ago
• 1 Please add a minimal reproducible example – Wicket Commented 2 days ago

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Does anyone have an idea of what could be wrong? Is there a better approach to opening a document using a URL?

Based on my research, there are some similar cases to yours, however, their issue involves incorrect document ID as it is not following the 44 character format, which does not work with your case.

As per the method itself, I don't think that there is an issue with your current approach, it should work as intended, unless there's more to your code that you still haven't provided through your question, or a possible bug.

I would suggest using the openById() method instead as each document has a unique ID, which does not change even with altering the location of the document within the Google drive, therefore, you would not experience the disadvantage of changing the URL each time.

You can try this approach:

function myFunction() {
  var url = "1bmad4K86Ov1zQHiu8gbX6GpOSL9kbNGKiE3jmaJN9N8";
  var doc = DocumentApp.openById(url);
}

If this is not suitable for your needs, kindly provide more information and show us your complete code. It might be due to different parts of it. Also provide the Oauth scopes you have within your script, It can be the reason why it does not acknowledge the method you are using.

Reference: openById(), openByUrl()

本文标签： google docsApps Script DocumentAppopenByUrl Unexpected ErrorStack Overflow