CODEWITHSUNDEEP
javascriptgoogle-apps-script
test api
test api

Reputation: 45

Google Apps Script - how I can get JSON?

I have scripts:

function mySheet(e){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheetId = ss.getId();
  var name = ss.getName();
  var sheetName = ss.getSheetName();
  var maxCol = ss.getLastColumn();
  var maxRow = ss.getLastRow();
  var data = ss.getRange(sheetName+"!A1:"+maxCol+maxRow).getValues();

  Logger.log(sheetId +" "+ name +" "+ JSON.stringify(data));
}

I have values in json, but i need JSON like $service->spreadsheets_values->get($spreadsheetId, $range) return... how I can do that? i heed data like: {"majorDimension":"ROWS","range":"'Sheet1'!A1:Z3","values":...} I search, but can't find method...

Upvotes: 0

Views: 104

Answers (1)

idfurw
idfurw

Reputation: 5852

User Sheets API

https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/Sheet1!A1:Z3

Sheets.Spreadsheets.Values.get(ss.getId(), 'Sheet1!A1:Z3')

Upvotes: 2

Related Questions