I have a problem with this reference From this Site Using Google SpreadSheet as Database. the problem is that. the Android Application cannot fetch the data in a google spreadsheet. The Application can successfully run but couldn't find data in the Spreadsheet.

I Already Updated the codes from the android studio because of the old version used codes. I just copy and paste it and change some of it.

Codes Below:

The Script Link to fetch the Data :

https://script.google.com/macros/s/AKfycbwZJCWoQ7dpC5KwyRM9JYsjCjymQUspAfPmniOApD_CSEoc-LdP/exec?id=16O_OfgKxASgqa2WWQKePJI1jnJMTdb4OyXbUJU6kWH0&sheet=Sheet1

Link of the SpreadSheet :

https://docs.google.com/spreadsheets/d/16O_OfgKxASgqa2WWQKePJI1jnJMTdb4OyXbUJU6kWH0/edit#gid=0

This is the App Script that Fetches the data:

you can also see the app script codes here : App Script Codes.

    function doGet(request) {

  var output  = ContentService.createTextOutput(),

      data    = {},

      id      = request.parameters.id,

      sheet   = request.parameters.sheet,

      ss      = SpreadsheetApp.openById(id);



  data.records = readData_(ss, sheet);



  var callback = request.parameters.callback;



  if (callback === undefined) {

    output.setContent(JSON.stringify(data));

  } else {

    output.setContent(callback + "(" + JSON.stringify(data) + ")");

  }

  output.setMimeType(ContentService.MimeType.JSON);



  return output;

}





function readData_(ss, sheetname, properties) {



  if (typeof properties == "undefined") {

    properties = getHeaderRow_(ss, sheetname);

    properties = properties.map(function(p) { return p.replace(/s+/g, '_'); });

  }



  var rows = getDataRows_(ss, sheetname),

      data = ;



  for (var r = 0, l = rows.length; r < l; r++) {

    var row     = rows[r],

        record  = {};



    for (var p in properties) {

      record[properties[p]] = row[p];

    }



    data.push(record);



  }

  return data;

}





function getDataRows_(ss, sheetname) {

  var sh = ss.getSheetByName(sheetname);



  return sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn()).getValues();

}





function getHeaderRow_(ss, sheetname) {

  var sh = ss.getSheetByName(sheetname);



  return sh.getRange(1, 1, 1, sh.getLastColumn()).getValues()[0];  

}

More Codes From the Link Above or click here for not scrolling back.