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.