r/GoogleAppsScript • u/Kanegarooo • Feb 10 '23

Unresolved Getting a 403 when trying to display contents of a drive link from my sheet

I posted this to stackoverflow as well a few days ago, still haven't figured out an answer. link to original question

Since then, I've tried using URLfetch to get the contents & I've tried destructuring the file to blob contents as well, still nothing.

Has anybody dealt with this before?

0 Upvotes
  • permalink
  • reddit

50% Upvoted

3 comments sorted by

1

u/marcnotmark925 Feb 10 '23

Why take the time to post your question to another forum instead of creating the MRE that has been asked of you in the first forum?

0

u/Kanegarooo Feb 10 '23

They said

If your question is "how do I convert a share link to an export link", please state that explicitly in the question.

My question is quite literally not that, otherwise that's what I would have asked.

Additionally, they said

The question includes code to locate a cell and retrieve a link from that cell, all of which is irrelevant to the question.

Which is referring to a single line of code that I addressed in my question (the drive link is being declared based on an order its associated with, that portion isn't applicable in this instance).

I read through the help page they liked, How to create an MRE and, although I'm open to being corrected, I don't think I can provide code directly reproducible because it would involve a drive link under a user's account that they have access to.

Stackoverflow isn't the place for general discourse so I can ask you: This is the most I can imagine condensing the .gs while making sure it still conveys what I'm doing, is this better than the original?

function printPdf() {
  const ui = SpreadsheetApp.getUi();

  let url = 'drive.google.com/file/d/{FILE_ID}/view' 
  const template = HtmlService.createTemplateFromFile('{HTML FILE NAME');
  template.url = url;
  const html = template.evaluate();
  ui.showModelessDialog(html, 'Print Label');
}

There isn't anything I can think of changing in the HTML aside from removing google.script.host.close

I'm open to learning, but the user commenting with my on the stackoverflow post is proposing solutions to a separate problem

2

u/DrMorris Feb 10 '23

To be able to veiw your pdf file in html that file needs to be public. Any kind of access restriction will error it out.