2

Since yesterday one of my google script doesn't work anymore. The script

  1. take an image on the drive
  2. copie a slide
  3. replace a shape with an image

But I got this error:

"The provided image is in an unsupported format."

-> I give all access to the image: it doesn't change anything

-> The script work if I take an url outside the drive

Any idea

function test_image(){
  var imageUrls = DriveApp.getFilesByName("DSC_3632.png");
  var file = "undefined";
  while ( imageUrls.hasNext()) {
    var file = imageUrls.next();
  }

  var imageUrl = file.getDownloadUrl() + "&access_token=" + ScriptApp.getOAuthToken();

  var model_file = DriveApp.getFileById("your-id");
  var presentation = model_file.makeCopy("totot");
  var presentation =Slides.Presentations.get(presentation.getId())

  var requests = [{
      "replaceAllShapesWithImage":
        {
          "imageUrl": imageUrl,
          "imageReplaceMethod": "CENTER_INSIDE",
          "containsText": {
            "text": "toto",
            "matchCase": false,
          }
        }
    }];


  var presentationId = presentation.presentationId

  var createSlideResponse = Slides.Presentations.batchUpdate({
    requests: requests
  }, presentationId);


}
Rubén
  • 34,714
  • 9
  • 70
  • 166
Denis Bolomier
  • 350
  • 2
  • 19

1 Answers1

9

How about this answer? Please think of this as just one of several possible answers.

Issue and workaround:

I think that the reason of your issue is due to the following modification of official document.

First, we’re making changes to authorization for the Google Drive API. If you authorize download requests to the Drive API using the access token in a query parameter, you will need to migrate your requests to authenticate using an HTTP header instead. Starting January 1, 2020, download calls to files.get, revisions.get and files.export endpoints which authenticate using the access token in the query parameter will no longer be supported, which means you’ll need to update your authentication method.

By above situation, the URL of var imageUrl = file.getDownloadUrl() + "&access_token=" + ScriptApp.getOAuthToken(); cannot be used. For example, when it accesses to the URL, the login screen is displayed even when the access token is used.

In order to avoid this issue, how about the following modification?

Modification points:

  • The file is shared publicly and put to Google Slides. Then, the sharing file is closed.
    • In this case, even when the share of file is closed, the put image on Slides is not removed.
  • The webContentLink is used as the URL.
    • It's like https://drive.google.com/uc?export=download&id=###.

Modified script:

When your script is modified, it becomes as follows.

function test_image(){
  var imageUrls = DriveApp.getFilesByName("DSC_3632.png");
  var file; // Modified
  while (imageUrls.hasNext()) {
    file = imageUrls.next();
  }
  file.setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.VIEW); // Added
  var imageUrl = "https://drive.google.com/uc?export=download&id=" + file.getId(); // Modified
  var model_file = DriveApp.getFileById("your-id");
  var presentation = model_file.makeCopy("totot");
  var presentation =Slides.Presentations.get(presentation.getId())
  var requests = [{
    "replaceAllShapesWithImage": {
      "imageUrl": imageUrl,
      "imageReplaceMethod": "CENTER_INSIDE",
      "containsText": {
        "text": "toto",
        "matchCase": false,
      }
    }
  }];
  var presentationId = presentation.presentationId
  var createSlideResponse = Slides.Presentations.batchUpdate({requests: requests}, presentationId);
  file.setSharing(DriveApp.Access.PRIVATE, DriveApp.Permission.NONE); // Added
}

References:

If I misunderstood your question and this was not the direction you want, I apologize.

Rafa Guillermo
  • 14,474
  • 3
  • 18
  • 54
Tanaike
  • 181,128
  • 11
  • 97
  • 165
  • Curious. Why not send ``{'Authorization': 'Bearer '+ token}``. It says http headers works right? – TheMaster Feb 06 '20 at 16:31
  • 1
    @TheMaster Thank you for your comment. In OP's script, the text is replaced with the image using Slides API. For this, I modified OP's script. In this case, the image is required to be the URL. And, the URL is required to be able to be accessed from outside. So the request header is not used for the request body of Slides API. By this, in my modification, the file is publicly shared once and replaced with the image and the share is closed. Of course, when the Slides service is used, the blob can be directly used. If I misunderstood your comment, I apologize. – Tanaike Feb 06 '20 at 23:21
  • 1
    @TheMaster Thank you for replying. As other method, when Google Document is used, the images in the Document can be retrieved as the temporal URLs like Google Photo. Although it's the temporal, these URLs are public So this can also used for OP's situation. – Tanaike Feb 07 '20 at 05:07
  • 1
    I faced this issue and tried to use blob base64string but i got a different error complaining about the string length exceeded for the url property. Finally settled with the file permission workaround. – Nirmal Feb 13 '20 at 16:49