Auto Update tables - Google Slides

[Carlin Hatcher]

Greetings,

I'm having issues with my script and I'm seeking assistance. The intended purpose of my script is to update all charts and tables within a google slide that are linked to a google sheet. 

May someone provide some guidance? 

Here is my script:

function onOpen() {

  var ui = SlidesApp.getUi();

  ui.createMenu('Do The Thing')

  .addItem('Batch Update Charts', 'batchUpdate')

  .addToUi();

}

function batchUpdate(){

  Logger.log("Sheets update started");

  var gotSlides = SlidesApp.getActivePresentation().getSlides();

  for (var i = 0; i < gotSlides.length; i++) {

    var slide = gotSlides[i];

    var sheetsCharts = slide.getSheetsCharts();

    for (var k = 0; k < sheetsCharts.length; k++) {

      var shChart = sheetsCharts[k];

      shChart.refresh();

      Logger.log("Sheets update complete");

    }

  }

  

  batchUpdateTables();

  

}

function batchUpdateTables(){

  try {

    Logger.log("Tables update started");

    var gotSlides = SlidesApp.getActivePresentation().getSlides();

    for (var i = 0; i < gotSlides.length; i++) {

      var slide = gotSlides[i];

      var sheetsTables = slide.getTables();

      for (var k = 0; k < sheetsTables.length; k++) {

        var shTable = sheetsTables[k];

        shTable.refresh(); //No refresh function for table object

        Logger.log("Sheets update complete");

      }

    }

  } catch(err) {

    Logger.log(err);

  }

}

[IAlex]

Hi!

What issues do you get?

[Carlin Hatcher]

Nothing is happening. Charts and tables from google sheets do not update