Google App Scripts | Sheets Tutorial | dummy data

Code_dummyData.js

/* 
Google App Scripts - Sheets Tutorial
Author: Mark Cameron
*/

function showMessageBox() {
    Browser.msgBox('You touched me!');
    getWebsite();
}

function getWebsite() {

    var stringValue = '';

    // making a call to the target website
    var response = UrlFetchApp.fetch("http://dummy.restapiexample.com/api/v1/employees");
    
    //logging response from target website - In Script Editor > View > Logs
    Logger.log(response.getContentText());
    
    //logging response HEADERS from target website - In Script Editor > View > Logs
    Logger.log(response.getHeaders().toSource());

    //parsing the response data from website
    //https://developers.google.com/apps-script/reference/url-fetch/http-response
    var rawData = response.getContentText();
    var newData = JSON.parse(rawData);

    counter = 0;

    for (var key in newData) {
        //in this loop we iterate over the array containing the data
        
        stringValue = newData[key];
        
        //variable to capture a subset of data from the website
        empNameValue = stringValue.employee_name;
        empSalaryValue = stringValue.employee_salary;

        //setting the spreadsheet and cell location to place the website data
        //make sure to open a new sheet 
        //Link: https://developers.google.com/apps-script/reference/spreadsheet/sheet#getrangerow-column
        var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

        //we are setting the sheet here [1] below. [0] is the first sheet, [1] is the second sheet and so on
        var sheet = SpreadsheetApp.setActiveSheet(spreadsheet.getSheets()[1]);

        //setting cell range (row, column, number of rows, number of columns)
        var column1 = sheet.getRange(counter + 1, 1, 1, 1);
        column1.setValue(empNameValue);
        var column2 = sheet.getRange(counter + 1, 2, 1, 1);
        column2.setValue(empSalaryValue);

        counter++;
    }
}