Retrieve filterViewId from batchUpdate request addFilterView

Question

I'm able to make an addFilterView request using the batchUpdate. My question is that how can I retrieve the created filterViewId?

Here is the code I'm using:

 var filterSettings = {
  "title":criteria,
  "range": {
    "sheetId": sheetId,
    "startRowIndex": startRowIndex,
    "endRowIndex": 99999,
    "startColumnIndex": 0,
    "endColumnIndex": lastColumn
  },
    "criteria": {

    }
  };

  filterSettings.criteria[colNo] = {
         "condition": {
           "type": "TEXT_CONTAINS",
           "values": [
             {
               "userEnteredValue": criteria
             }
           ]
         }
       }

   var requests = [{
  "addFilterView": {
    "filter": filterSettings
  }
  }];

Sheets.Spreadsheets.batchUpdate(
        {
          requests:  requests 
        },
        ssId
        );

Answer 1

• You want to retrieve filterViewId from the created filter view.
• You want to achieve this using Google Apps Script.

If my understanding is correct, how about this answer? Please think of this as just one of several possible answers.

Pattern 1:

In this pattern, when the method of batchUpdate is run, filterViewId is retrieved from the returned value.

Please modify as follows.

Modified script:

From:

Sheets.Spreadsheets.batchUpdate(
        {
          requests:  requests 
        },
        ssId
        );

To:

var res = Sheets.Spreadsheets.batchUpdate({requests:  requests}, ssId);
var filterViewId = res.replies[0].addFilterView.filter.filterViewId;
Logger.log(filterViewId)

Pattern 2:

In this pattern, filterViewId is retrieved from using the method of spreadsheets.get in Sheets API. In this case, the result is retrieved by the sheet name and filter view title.

Sample script:

function myFunction() {
  var sheetName = "Sheet1";  // Please set the sheet name.
  var filterViewTitle = "sampleName";  // Please set the filter view title.

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var ssId = ss.getId();
  var res = Sheets.Spreadsheets.get(ssId);
  var sheet = res.sheets.filter(function(s) {return s.properties.title == sheetName});
  if (sheet.length == 1) {
    sheet[0].filterViews.forEach(function(f) {
      if (f.title == filterViewTitle) {
        Logger.log(f.filterViewId)
      }
    });
  }
}

Note:

• In above scripts, it supposes that Sheets API has already been enabled at Advanced Google services.

Reference:

• Method: spreadsheets.get

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