pullFromManagebac.gs

// Exmample of options

var options = {
    method: "POST",
    contentType : "application/json",
    payload: JSON.stringify({
        secret: 'you will have to ask me',
        awesome_table_filters: {
            first_nickname_last: 'StringFilter',
            parent_email_1: 'StringFilter',
            parent_work_email_1: 'StringFilter',
            parent_email_2: 'StringFilter',
            parent_work_email_2: 'StringFilter',
        },
        google_sheets_format: true,
        column_map: {
            first_nickname_last: 'Student',
            parent_email_1: 'P1 IGB Email',
            parent_work_email_1: 'P1 Personal Email',
            parent_email_2: 'P2 IGB Email',
            parent_work_email_2: 'P2 Personal Email',
        },
        columns: ['grade', 'parent_email_1', 'parent_work_email_1', 'parent_email_2', 'parent_work_email_2']
    }),
};

function updateManageBac() {
  Logger.log(options);
  var result = UrlFetchApp.fetch('http://portal.igbis.edu.my/api/students', options);
  var json = JSON.parse(result.getContentText());

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data from ManageBac');
  var columnNum = json.columns[0].length;
  var rowNum = json.data.length;

  sheet.getRange(1, columnStartAt, 1,      columnNum).setValues(json.columns);
  sheet.getRange(2, columnStartAt, rowNum, columnNum).setValues(json.data);
  //TODO: return success or error here
}