How do I execute requests in Google slides apt script replaceAllText

Question

I'm playing around with a dynamic signage project and need a little help finishing off some GAS in Slides. All I want to do is replace some text in the active presentation with some text from (one cell) in a Google spreadsheet. I think I have the Request syntax correct but not sure how to execute the Request on the current presentation as everything I've tried seems to fail. Any help would be much appreciated. Code below which includes the full script which copies some slides etc (and is working) - it's just the last request section that I need help with...

    function updateRBFixtures() {

    var srcPresentationId = "1zRvc0H64yvxxxxxxxxxxxxxznmb2usZ_4w6bvRA";
    var copysrcSlideIndex = 0; 

    var copydstSlideIndex = 1; 

    var src = SlidesApp.openById(srcPresentationId).getSlides()[copysrcSlideIndex];

    SlidesApp.getActivePresentation().insertSlide(copydstSlideIndex, src);


    var selection = SlidesApp.getActivePresentation().getSelection();
    var slide = SlidesApp.getActivePresentation().getSlides()[0];
    slide.remove();

    var dataRangeNotation = 'slideInfo!B2:B2';
    var value = 
    SpreadsheetApp.openById("1jiYxxxxxxxxxxxxxxMqtwXnc").getRange(dataRangeNotation).getValues();

    requests = [{
    replaceAllText: {
    containsText: {
    text: '{fixtureOneMatch}',
    matchCase: false
    },
   replaceText: value
   }
   }];




   }

@Cooper I'm asking how to execute the requests in the current presentation. I thought i could use batchupdate but doesn't seem to work — emrwilks, Jun 11 '20 at 20:10

score 1 · Accepted Answer · answered Jun 11 '20 at 22:04

How about this answer?

Modification points:

getValues() returns 2 dimensional array. In your case, the value is retrieved from one cell. So you can use getValue().
In your case, after the slide was inserted, I think that it is required to use saveAndClose().
In your script, requests is not used.

When above points are reflected to your script, it becomes as follows.

Modified script:

From:

 SlidesApp.getActivePresentation().insertSlide(copydstSlideIndex, src);


 var selection = SlidesApp.getActivePresentation().getSelection();
 var slide = SlidesApp.getActivePresentation().getSlides()[0];
 slide.remove();

 var dataRangeNotation = 'slideInfo!B2:B2';
 var value = 
 SpreadsheetApp.openById("1jiYxxxxxxxxxxxxxxMqtwXnc").getRange(dataRangeNotation).getValues();

 requests = [{
 replaceAllText: {
 containsText: {
 text: '{fixtureOneMatch}',
 matchCase: false
 },
replaceText: value
}
}];

To:

var s = SlidesApp.getActivePresentation();
s.insertSlide(copydstSlideIndex, src);
s.getSlides()[0].remove();
s.saveAndClose();
var dataRangeNotation = 'slideInfo!B2:B2';
var value = SpreadsheetApp.openById("###").getRange(dataRangeNotation).getValue();
var requests = [{
  replaceAllText: {
    containsText: {
      text: '{fixtureOneMatch}',
    },
    replaceText: value,
  }
}];
Slides.Presentations.batchUpdate({requests: requests}, s.getId());

In this case, please enable Slides API at Advanced Google services.

References:

This worked perfectly many thanks. Good spot with the get.value vs get.values as this solved another error i was getting. Cheers! — emrwilks, Jun 12 '20 at 19:04
@emrwilks Thank you for replying. I'm glad your issue was resolved. Thank you, too. — Tanaike, Jun 12 '20 at 23:34

How do I execute requests in Google slides apt script replaceAllText

1 Answers1

Modification points:

Modified script:

References: